Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select distinct row
Hie guys,
i need another guide. how can i select distinct row and transfer to another sheets? below are the example in sheet 1: Name | Payment | Date ----------------------------- John | $50 | 20/04/04 Andy | $28 | 20/04/04 Andy | $10 | 21/04/04 so for sheet 2 and 3, how do i come about macro/function t automatically create the sheet and transfer the row distinctly b "Name"? eg: Sheet 2 Name | Payment | Date ----------------------------- John | $50 | 20/04/04 eg: Sheet 3 Name | Payment | Date ----------------------------- Andy | $28 | 20/04/04 Andy | $10 | 21/04/04 Thanks in advance! Cheer -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help With MS Query Sum Distinct | Excel Discussion (Misc queries) | |||
distinct | Excel Worksheet Functions | |||
Distinct | Excel Worksheet Functions | |||
Select Distinct Maximums | Excel Worksheet Functions | |||
howto select distinct values from list | Excel Worksheet Functions |