Originally Posted by
MartinGTC
Thanks, sorry, I should be clearer;
See attached. I'm really trying to avoid a helper column...I can do it with one, but for speed I didnt know if there was a function (like conditional formatting or remove duplicates - but that removes a full row, I only want to remove the dupe cells and keep all other info)
Once the info is de-duped, i need to run a count function on the column so I'm counting unique values in a column. If this can be done in the middle of a formula...perfect!
Bookmarks