Unique Values in a Table

Question

I have a 9x9 table in excel that represents a box of vials of cells that we have stored. The rows and columns are not sorting anything, only marking a location. So I don't want there to be anything interrogated or counted by row or column individually. For example, one part of our location map might look like this:

Cell type A	Cell Type A	Cell Type A
Cell Type X	Cell Type C	Cell Type B
Cell Type D	Cell Type B	Cell Type X

I want to get a count of how many of each type of vial we have per box (and eventually total because we have about 50 boxes with 80 spots in each) but I can't find any way to count unique values in a table, only per column. I want to do this with a formula so as we take vials out and add them in, the counts will change automatically and not have to be done manually. I was thinking that I could do this by making a list of each unique value (each cell type) and then counting how many times that value appears in the table (how many vials of each cell type per box).

Answer 1

Hi,

Enter this formula in cell F2 and copy down

=COUNTIF($A$2:$C$4,E2)

Hope this helps.

Answer 2

To: K

re:  count of vials in storage

Quick Uniques is part of the free Professional_Compare Excel workbook.

See image below for typical results...

It finds the first two blank areas to the right of the data to place the unique list.

It is case sensitive; note the count for "Cell type D".

Another image...

Download from MediaFire (no ads)...

*http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents*