Hello,
If I have a sheet e.g 1000 rows which is constantly updated with codes...
eg.
col A B C D E
code title notes year year etc
How can i check in the columns if I have accidently copied the same code in(A) E.G 211 ROWS down...
I think I would need to lable another column eg g as (same)
then type =IF SOMEthing to find same....Can someone help me with this formula which would be applied right down all 1000 columns..? I know its quite straight forward.
this is in relation to my previous which I'm yet to elaborate on on '' check'' which compares 2 worksheets.
Many Thanks
Bookmarks