Find start date and end date

Dear Team,

I have a transactional data which contains emp id , name and month.

I want to find the first entry month and last entry month using the formula.

For example i have a Transactional data from A1 : C20 cell. if i put the Emp code 1001 start month is Jan21 and Aug 21 is End month. Emp Code 1002 start month is Jan 21 and Nov 21 End month.

I am attaching the sample file with

Thanks

Your profile indicates that you are using XL, however, the file is using format that was originated with XL2007. What version of Excel are you using. Please update your profile as solutions are based upon the version you are employing.

Thanks alan. Can you have any excel based formula to find this start and end date? instead of using power query

This for start date =aggregate(15,6,if($a$2:$a$20=f11,$c$2:$c$20),1)
this for end date
=aggregate(14,6,if($a$2:$a$20=$f11,$c$2:$c$20),1)

In G6 copied down, use

Formula:

Please Login or Register  to view this content.

and change the formula to maxifs for col H

Hi, to all!

I leave two options in the file.

First Option: Formulation, included unique extract of Emp Id into the solution.
Second Option: Pivot Table.

Check file. Blessings!