hi every one,
in column A employee no is given on daily basis
in column B attendance date is given
in C5 i want employee start date
in C6 in want employee end date
how can i bring these answer. can anyone help me.
Regards,
Raj.
hi every one,
in column A employee no is given on daily basis
in column B attendance date is given
in C5 i want employee start date
in C6 in want employee end date
how can i bring these answer. can anyone help me.
Regards,
Raj.
=max(if(a1:a100="employee no",b1:b100))
=min(if(a1:a100="employee no",b1:b100))
Array foemula. Control+Shift+Enter
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Dear Fotis 1991,
Thanks a lot.
Regards,
Raj
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks