How to create list and count from a table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

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
How to export table from outlook into ms access table? 0
show if has two specific records 3
Tables 6
Create a Sub Autonumber that re-assigns autonumber to each data groupin a sorted field. 1
Match and Sort for two range of data on different worksheets? 3
I've 5 columns, of assorted items.how do I tally them up? 5
different sheets (ledgers) 1

Back
Top