How to create list and count from a table?

P

PL

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.
 
S

steve_doc

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help: Creating Data List and value 3
combining data from 2 sheets 11
List all tables, including document structure 0
show if has two specific records 3
Can't figure out query 0
Tables 6
extract data from another worksheet 0
List from a Table 1

Top