LinkBack URL
About LinkBacks
vjharry 
Hi,
I have attached a Master data of all persons, where i need to find out those persons whose Birthday are today (by Formula).
I tried by formula (in same sheet) but couldnt make it. So please help me out.
Thanks
Today's Birthday List
Hi,
I have attached a Master data of all persons, where i need to find out those persons whose Birthday are today (by Formula).
I tried by formula (in same sheet) but couldnt make it. So please help me out.
Thanks
Click on (*), if you agree.
Try
=IFERROR(INDEX(Table1,SMALL(IF((MONTH(Table1[@[Date of Birth]])=MONTH(TODAY()))*(DAY((Table1[@[Date of Birth]]))=DAY(TODAY())),ROW(Table1[Date of Birth])-ROW($C$4)+1,""),ROWS($A$4:A4)),MATCH(G$3,Table1[#Headers],0)),"")
John, i tried but its not working.
Try
=IFERROR(INDEX(Table1,SMALL(IF((MONTH(Table1[Date of Birth])=MONTH(TODAY()))*(DAY((Table1[Date of Birth]))=DAY(TODAY())),ROW(Table1[Date of Birth])-ROW($C$4)+1,""),ROWS($A$4:A4)),MATCH(G$3,Table1[#Headers],0)),"")
With John's array formula in G4 dragged down, you just need simple lookups in H4 to K4, dragged down:
Formula:
H4 =IFERROR(INDEX(Table1[Name],MATCH($G4,Table1[Code],0)),"")
I4 =IFERROR(INDEX(Table1[Date of Birth],MATCH($G4,Table1[Code],0)),"")
J4 =IFERROR(INDEX(Table1[Qualification Category],MATCH($G4,Table1[Code],0)),"")
K4 =IFERROR(INDEX(Table1[Deptt.],MATCH($G4,Table1[Code],0)),"")
Edit: Just ignore this. After John's post below, I realised I'd read the final Match to include $G$3.
Last edited by Aardigspook; 06-15-2016 at 08:44 AM. Reason: Add acknowledgement of next post.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
It is easier just to drag the formula across and down (as per the original): the formula matches the column..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks