Multiple occurence value

[Nitin Suntwal]

Hi There,

Need help on a formula, attached is the dummy sheet! Thanks in advance.

In sheet1 there is acutal dump form tool, where the emp id will be repeated & based on each emp id the amount will differ. In sheet2 I have the same dump from other tool, & want to match the amount based on # of time the emp id is repeated. I tried the fornula with index, small & if, however for few id's i am getting the answer remaining i am getting #N/A.

Can some one help me out.

Regards,
Nitin Suntwal.

 

[NARAYANK991]

Hi ,

See if this is what you wanted.

Narayan

 

[PCosta87]

Hi,

Please refer to attached... you were almost there

 

[bosco_yip]

Another option of Index+Small formula (non-array formula)

Please refer to the attachment

Regards
Bosco

 

[Nitin Suntwal]

Thank you very much to all.
This is was I was exactly looking for. I have to choose any of the 3 alternatives (all of them arriving to same information).
Thanks Once again.