CODEWITHSUNDEEP
excel
tonyG_cyprus
tonyG_cyprus

Reputation: 23

Excel lookup query

I'm not all that with excel and this is driving me nuts. I have a table with 3 columns A B C.

After the numbers have been entered in C, I need to find who in A has a match to the numbers in C and how many times. I.E:

Bill    7
Mary    4
in C--      2 7 5 4 4

Results need to show (could be on another sheet):

Bill    1
Mary    2

have spent hours googling, but either can't find help, or I'm too stupid to see it.

Upvotes: 0

Views: 66

Answers (1)

Jerry
Jerry

Reputation: 71538

You can use COUNTIF to do that.

You can copy/paste to get the name list to the other sheet first.

Then, use:

=COUNTIF(Sheet1!C:C, VLOOKUP(A1, Sheet1!A:B, 2, 0)))

Or if you are able to copy both columns A and B into Sheet2, 

=COUNTIF(Sheet1!C:C, B1)

Then copy/paste as values and last delete column B.

If it can be done on the same sheet, you can consider:

=COUNTIF($C$1:$C$5, B1)

Upvotes: 1

Related Questions