Hello! I am going crazy... :D
I have column A, column B and column C
Column A: list (all cells have a value, a lot of duplicates)
Column B: contains a formula that shows the values of column A but removes all the duplicates and places a blank cell instead of showing the duplicate, so what the formula does its that if it finds a duplicate then it shows "" (a blank value)
Column C: I want simply the list present in column B without the blank cells, so I need the range in column B just with the cells that have a value, what formula will help achieve that please??
Alternative request: if column B can just directly show the values of column A without the blank cells of the duplicates.
Thanks in advance for precious help!
Bookmarks