Formula to find repeated values for the same month..

[Asheesh]

Hi All -

I already spent over 2 hours to build a logic around this..but all in vein...so here I am looking for saviour..

I am building a dashboard in excel which is completely formula driven and no VBA at all..as somehow..I am avoiding VBA for quite sometime and dont know why..

Neverthless, the issue is..we have a list of employees and their reporting managers..And we need to identify people leaders from the list of employees..so I simply use vlook to find out if the employee number exists in reporting managers employee number field..if found then PL or else IC. Now, there is a possibility that an employee who is a people leader in the month of jan now becomes IC in the month of Feb..so this guy is a people leader for the month of Jan and IC for the month Feb..

I am attaching a sample file for your reference..

Let me know if havent been able to convey my requirement clearly..

 

[NARAYANK991]

Hi Asheesh ,

There seems to be some discrepancy ; why is employee #2 an IC in the month of March ?

Narayan

 

[Asheesh]

Hi Sir -

Right you are..this is a typo error...this guys will be a PL for the month of march..

 

[NARAYANK991]

Hi Asheesh ,

In which case , can you not use the following array formula , to be entered using CTRL SHIFT ENTER :

=IF(ISERROR(VLOOKUP(A2 & B2,$A$2:$A$100 & $D$2:$D$100,1,0)),"IC","PL")

Narayan

 

[Asheesh]

oh yes...I dont know where was i lost...so neat and simple...thanks a lot..