Re: $$Excel-Macros$$ Hard to find Status for me...

use this IF(COUNTIFS(A:A,A2,B:B,B2)=COUNTIFS(A:A,MAX(A:A),B:B,B2),"Active","Deactive") drag it down On Thu, Oct 18, 2012 at 11:18 AM, Manoj Kumar wrote: > > > Dear Expert. > > Please help me.. > File attached below.. > > Regard > Manoj > > > -- > Join official facebook page of this forum @ >

$$Excel-Macros$$ Hard to find Status for me...

Dear Expert. Please help me.. File attached below.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent