Scenario:
150+ rows
First column – duplicate names
Second column – duplicates removed (leaving gaps)*
Third column – additional info added manually, creating duplicates in this column
Forth column – duplicates removed*
Question:
Is there any way to achieve the actions marked with *? I prefer to work ‘dynamically’ with (often complex) formulae. I can’t think of a way of effectively moving across the sheet and reducing the quantity of names displayed.
Imagine 6 identical names in first column, reducing to a single name in the second column, effectively blanks next to 5 of the names and the name repeated on the 6th.
Hope this makes some sense!
I could use the ‘remove duplicate’ functions or advanced filter but I need to keep the spreadsheet ‘live’ as more data may need to be added.
Many thanks
Kevin