Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I stop data from repeating?
Hello,
A client has provided me a spreadsheet that has rows of data with certain columns that have repeating data. For instance one column lists job title. For that column, "Registered Nurse" could be repeated for 100 rows. The column is not part of the sort criteria. Is there a way to have only the first occurance of each new/different title displayed as one reads down the spreadsheet? Thanks very much for any help out there!! :-) Donald D. |
#2
|
|||
|
|||
You could use conditional formatting to hide the duplicates.
Debra Dalgleish shows how at: http://contextures.com/xlCondFormat03.html#Duplicate But once they scroll down a little bit, wouldn't it be more useful to see that info--instead of having to scroll back to the top to see the value? Donald D wrote: Hello, A client has provided me a spreadsheet that has rows of data with certain columns that have repeating data. For instance one column lists job title. For that column, "Registered Nurse" could be repeated for 100 rows. The column is not part of the sort criteria. Is there a way to have only the first occurance of each new/different title displayed as one reads down the spreadsheet? Thanks very much for any help out there!! :-) Donald D. -- Dave Peterson |
#3
|
|||
|
|||
Perfect! THANKS SO MUCH!!
Regards, Donald "Dave Peterson" wrote: You could use conditional formatting to hide the duplicates. Debra Dalgleish shows how at: http://contextures.com/xlCondFormat03.html#Duplicate But once they scroll down a little bit, wouldn't it be more useful to see that info--instead of having to scroll back to the top to see the value? Donald D wrote: Hello, A client has provided me a spreadsheet that has rows of data with certain columns that have repeating data. For instance one column lists job title. For that column, "Registered Nurse" could be repeated for 100 rows. The column is not part of the sort criteria. Is there a way to have only the first occurance of each new/different title displayed as one reads down the spreadsheet? Thanks very much for any help out there!! :-) Donald D. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
how to stop repeating a number in worksheet(e.g. cell A1 is 6655 . | Excel Discussion (Misc queries) | |||
help with macro to save repeating data entry | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |