Dear all,
I want to create a formula to get last date of every employee from the other sheet "Data"
Find the attachment
Waiting your feedback
Dear all,
I want to create a formula to get last date of every employee from the other sheet "Data"
Find the attachment
Waiting your feedback
Try this in B2 and copied down:
Formula:Please Login or Register to view this content.
Note this is an array formula and needs to be confirmed with Ctrl+Shft+Ent rather than just Enter,
BSB
Non-array formula:
=LOOKUP(10^10,INDEX(Data!$C$2:$C$14,MATCH(Report!A2,Data!$B$2:$B$14,0)):INDEX(Data!$I$2:$I$14,MATCH(Report!A2,Data!$B$2:$B$14,0)))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Here is a non-array version for excel (2010, 2013, 2016)
Enter in B2 and copy down
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Another non-array formula. Works across versions.
=MAX(INDEX((Data!$B$2:$B$14=A2)*(INDEX(Data!$C$2:$I$14,MATCH(A2,Data!$B$2:$B$14,0),)),0))
Life's a spreadsheet, Excel!
Say thanks, Click *
Another optionFormula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks