| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help: Creating Data List and value
I need to create a unique data from a spreadsheet with the design as below:
1/1/07 2/1/07 3/1/07 ...... (date at row 1) 9am abc xyz (empty) 11am rst abc xyz 2pm xyz rst (empty) The expected result is: abc 2 rst 2 xyz 3 which show the unique data from the table with the number it appeards. Thank you for your help in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Data Validation List based on a Value in another cell | Excel Worksheet Functions | |||
| Creating a Detailed List from a Summary List | Excel Worksheet Functions | |||
| Creating a list (data validation) fromt wo different source ranges | Excel Discussion (Misc queries) | |||
| Creating a summary list from source data - can you?? | Excel Discussion (Misc queries) | |||
| Creating a list from Table Data | Excel Worksheet Functions | |||
Threaded Mode
