| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
suppress duplicate leading cells
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 | |||
| finding & filtering out duplicate cells | Excel Discussion (Misc queries) | |||
| Is there any way of searching for duplicate cells? | Excel Discussion (Misc queries) | |||
| Is it possible to show leading zeros for "number" cells? | Excel Discussion (Misc queries) | |||
| find duplicate cells in Excel | Excel Discussion (Misc queries) | |||
| how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) | |||
Threaded Mode
