| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to create list and count from a table?
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 in a seperate worksheet is: abc 2 rst 2 xyz 3 which show the unique data from the table with the number it appeards. Hope you can help me. Thank you in advance. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to create list and count from a table?
Assuming your data is in col A, B, C, D on Sheet 1
Your Summary is on Sheet 2 in the cell to the right of Summary abc - Formula is =COUNTIF(Sheet1!$B$2:$D$4,A1) Autofill down for a fara as is needed "PL" wrote: 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 in a seperate worksheet is: abc 2 rst 2 xyz 3 which show the unique data from the table with the number it appeards. Hope you can help me. Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| How to create a data list from a pivot table | Excel Discussion (Misc queries) | |||
| How to create adress list so can mail merge and create labels? | Excel Discussion (Misc queries) | |||
| Want to Create a List in Excel 2002; Don't see List in Data Menu? | Excel Discussion (Misc queries) | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
Linear Mode
