Create A summary based on Existing Data

Hi,

I need your help with a workbook. A sheet has different customer names I've done the conditional formatting so that it is highlighted in that particular sheet.

My requirement: I have a blank summary sheet which i need populated based on month. Say this is April, i want to be able to see the April names and the next month I need to be able to see the May name.

All help is much appreciated !

God Bless

Please attach a sample workbook with expected output for better understanding

Hi,

Sorry about that. Just attached the file for ur understanding in my main thread

IN C9 and copy down and across, this ARRAY formula.

=INDEX(Birthday!E$5:E$40,SMALL(IF(MONTH(Birthday!$F$5:$F$40)=MONTH(TODAY()),ROW(Birthday!E$5:E$40)-4),ROW(Birthday!E1)))

..I really need a little help understanding how to put the formula in C9

What kind of help?

Wow ! Thanks a Million !!!

Quick Question: If its May will the summary reflect the dates in May ??

............................

Sorry to bother you for one last time.

I really have trouble replicating the formula for the service anniversary sheet.

I know i'm asking too much of you. Just this one please

Btw, the formula u've created is great...

Question: if there is nothing to populate will it appear as NUM (Excel error).

Thanks again

=IFERROR(INDEX(Birthday!E$5:E$40,SMALL(IF(MONTH(Birthday!$F$5:$F$40)=MONTH(TODAY()),ROW(Birthday!E$5:E$40)-4),ROW(Birthday!E1))),"")

1. I tried replicating the formulas for service anniversary sheet, something is going wrong (Guess its a problem with me)
2. The IFERROR works for the error but removes the contents (Again it can be my mistake)

I've attached my messed up Excel for your magical touch.

Thanks in Advance !!

(It would be lovely if I could take a copy of your completed work )

Just now i work on a computer using Excel 2003, so i can not understand why IFERROR does not works for you.. In any case i use IF(ISERROR, and here is the result..

.

.It would be lovely if I could take a copy of your completed work

Not sure that i understand what you mean by this!

Hi,

The I have highlighted a cells on the Summary page. It is supposed to give only the April Dates, but its giving May and June dates also.

Please see my attachment.

Please Help !!!

The reality is to try to understand how formula works and modify this, as you need.

In this case a slight modification of formula in column C, would be able to give you the correct result. In this case you don't need me or anyone else to help you. You can do it alone.

God Bless you too.