Search results

Each name can only contain 1 file and/or 3 files. 123 and 1234 contains 3 files and also 1 file

No it wont be for what i am needing it to be. 400 can only have 3 files and 500 can only have 3 files or it could be just 1 file like for "name" 123 or 1234

see attached there are 3 sheets I will be looking at two sheets "Data" and "Doc". I need to match the "name" from "data" to the "name" from "doc". "doc" will have multiple duplicates of the name with a different "file". I will need to have the "doc" create new rows with "name" and "op"...

Thank you

Thanks for the reply but it wont work if column B has the same value later.

Try highlighting column A change it from general to long date (your current date format will be "dd mmm yyyy h:mm:ss AM/PM" which you can create under custom) and then try your formula again

Is it possible to make sure all duplicate values in column A and the value in column B are the same and column C will be true. If column B has different values but Column A is the same display false in column C. Example below. A______B____C 123456 10 TRUE 123456 10 TRUE 123456...

Thank you the above formula seems to work...I have a lot of information to go through

1. Yes column B will always be longer. 2. 95% of the time column A will match the beginning of column B. Column A format will have a mixture of letters and numbers and special characters. Column B may have 1 or more characters at the end of column A (column A will have 123 and column B will...

Is it possible to show only the difference between two columns and have what is different in another column. example column A_______Column B 123___________123-ce.abc 234___________a234.bcd 123___________103-a.cde Then column C i would want it to say Column C -ce.abc a.bcd 0-a.cde