| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Suppress duplicate data
you have a suggestion at your other thread in .misc.
Prema wrote: 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. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Suppress duplicate data
Suppose your columns are as follows:
A B C D Apples green type1 10 Insert two new columns between B and C: A B C D E F Apples green type1 10 Enter this formula in C2 (row1 is supposed as a header): =IF(A2=A1,"",A2) and fill it right to D2 then select C2:D2 and fill it down as necessary! You can hide columns A:B if you want! Regards, Stefi €˛Prema€¯ ezt Ć*rta: 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. |
| Reply |
| 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 | |||
Hybrid Mode
