| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Suppress duplicate data
I have a worksheet where data could be the same for first two columns of some
rows. I would like to supress this and show the data only on one line. e.g if I my data is like Apples green type1 10 Apples green type2 12 Apples red type1 9 Apples red type3 21 Pears green type2 5 Pears green type1 14 Then I would like it to be displayed as Apples green type1 10 type2 12 red type1 9 type3 21 Pears green type2 5 type1 14 What do I have to do to achieve this? Thank you for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Can I suppress display of duplicate data in columns? | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
