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
This conversation is currently closed to new comments.
... although it would require a bit of work, would be to sort the entire worksheet on the columns that have blanks in them. The spaces will come to the top or the bottom, depending on how you sort. Then, all you have to do is select all of the rows you want deleted and press delete.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel 2007 - not displaying duplicates in subsequent columns
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