LinkBack URL
About LinkBacks
Daniellowitz 
Copying into a blank spreadsheet what I've typed in my reply doesnt produce an error for me.
Copy the formula in my reply and paste it in.
Perhaps you need semi colons ; instead of commas , as you are in Denmark?
Copying into a blank spreadsheet what I've typed in my reply doesnt produce an error for me.
Copy the formula in my reply and paste it in.
Perhaps you need semi colons ; instead of commas , as you are in Denmark?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi again
I found out that I also need to check for duplicates if only two columns. Column A has 66.000 rows. I thought that this would work, but I get the result 1 on each of the cells
=IF(OR(NOT(ISNA(VLOOKUP(B1;A$1:A$66000;1;0))));1;0)
Thanks
Daniel
nevermind I found a solution.
Thanks for replies.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks