Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Index match Duplicate

Hi All Il make this simple to understand I have a data - for example Name and Location  Each time a duplicate name appears down the row -indicate person most recent location. For example  ...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

    Have you solved your problem?

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please feel free to ask.

    Best Regards,

    Cherry

     

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

 

I still have a little confused about your requirement. 



in excel i use the index match function - as the Match(fx) will bring me John 1 (row level 2 (most recent entry))


 

If it is convenient, could you share your desired output so that I could understand your logic better and get the solution.

 

Best  Regards,

Cherry