| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I suppress repeating data in Excel
I am importing data into Excel and there are many rows where the first column
repeats 3-4 times. For example, the first column lists a patient name, while the other columns list different payors and related information for that patient. I would like to print the name of the patient the in the first row it appears and then suppress it the next 2-3 times so that those cells are left blank. The report will be much more readable this way. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up repeating data in Excel | Excel Worksheet Functions | |||
| Suppress duplicate data | Excel Worksheet Functions | |||
| suppress printing a repeating value in a column | Excel Discussion (Misc queries) | |||
| repeating a data pattern in excel | Excel Discussion (Misc queries) | |||
| Can I suppress display of duplicate data in columns? | Excel Discussion (Misc queries) | |||
Threaded Mode
