Help Me - Excel Formula

S

sathish202

Joined
Apr 6, 2009
Messages
2
Reaction score
0
Hi,


I am trying to match a single value in Column A with the whole range of values in Column B to identify the number of occurences and list them in Column C

For Example,

Column A Column B Column C
1-213 2-111 ?
1-219 1-213
1-214 2-111
1-215 1-215
1-216 1-213
1-217 1-215
1-218 1-219
1-219 1-218
2-111 1-217

Can anybody help me how i can do this in excel. I tried many formulas but it seems my knowledge in excel formulas is very limited

Thank you,

Sathish
 
Excel Formula

A B C
-- -- --
1 3 =COUNTIF(Sheet1!B1:B6,Sheet1!A1) Result = 1
2 4 =COUNTIF(Sheet1!B1:B6,Sheet1!A2) Result = 0
3 3 =COUNTIF(Sheet1!B1:B6,Sheet1!A3) Result = 2
4 4 =COUNTIF(Sheet1!B1:B6,Sheet1!A4) Result = 3
5 4 =COUNTIF(Sheet1!B1:B6,Sheet1!A5) Result = 0
6 1 =COUNTIF(Sheet1!B1:B6,Sheet1!A6) Result = 0


Counif function should give u respite. above is the exmaple which u can see it working when u replicate it in a worksheet.

rgrds
Manohar
 
Back
Top