Count Unique in a column

[stephme55]

Hello. How can I get a count of unique based on column numbers. I want a 1 for the first occurance and then blanks for any duplicates. Thansk!!

[mcmahobt]

Based on column numbers? As in your data spans columns not rows? If, for example, your data (I'm assuming numerical) starts in A1 and goes across columns (as in B1, C1, etc.), you can try this in A2:

Please Login or Register  to view this content.

and drag across.

[stephme55]

Thanks. that worked. I dragged it down 40,000 rows and it worked but when I try to copy paste values it freezes excel. Is it too much to paste values over? Thank ye.

[mcmahobt]

...I dragged it down 40,000 rows and it worked

Were you looking for a count based on columns (left to right) or rows (top to bottom)? The formula will need to be adjusted if the latter.