Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I remove repeating rows automatically in excel?
Dear All Excel Macro programmers
I need help on this: Let's say I have 5 row, each row with 3 columns: kam POP 5 seng SOR 4 seng APDS 5 kam DS 6 kam MAM 4 boon PROJ 2 boon ENG 2 kam RAD 2 I want to produce data whose rows start with "kam", i.e., kam POP 5 kam DS 6 kam MAM 4 kam RAD 2 Note: no blank rows are produced, also I don't want to manually delete any rows. If I want to produce data whose rows start with "seng", then I should get: seng SOR 4 seng APDS 5 Is there any macro, program or excel function that can do what I want? Thanks if you know the answer. Frankie Kam Coordinator SOCS Stamford College Malacca Malaysia 15th November 2005 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I remove repeating rows automatically in excel?
Hi Frankie,
Look at Excel's built in Autofilter and Advanced filter features. If you are nit familiar with these, see Debra Dalgleish's tutorials at: http://www.contextures.com/xlautofilter01.html and http://www.contextures.com/xladvfilter01.html --- Regards, Norman wrote in message ups.com... Dear All Excel Macro programmers I need help on this: Let's say I have 5 row, each row with 3 columns: kam POP 5 seng SOR 4 seng APDS 5 kam DS 6 kam MAM 4 boon PROJ 2 boon ENG 2 kam RAD 2 I want to produce data whose rows start with "kam", i.e., kam POP 5 kam DS 6 kam MAM 4 kam RAD 2 Note: no blank rows are produced, also I don't want to manually delete any rows. If I want to produce data whose rows start with "seng", then I should get: seng SOR 4 seng APDS 5 Is there any macro, program or excel function that can do what I want? Thanks if you know the answer. Frankie Kam Coordinator SOCS Stamford College Malacca Malaysia 15th November 2005 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Automatically remove blank rows | Excel Discussion (Misc queries) | |||
Repeating rows in Excel | Excel Discussion (Misc queries) | |||
How Do I set repeating numbered rows (in Excel)? | New Users to Excel | |||
How do I automatically remove carriage returns in Excel? | Excel Discussion (Misc queries) | |||
Why have I got some repeating rows after a Excel 2003 sort | Excel Discussion (Misc queries) |