List of data depending on date

[Skinnyboy12]

Hi,

I have the attached file (simplified from a big report spreadsheet I use for work).

I try to improve by isolating particular project depending on the date they are due on.

I would like to enter, today's date, and get a list of all the project due on today or tomorrow and their stage.

V lookup doesn't work as their might be several project due on the same date.

Thank you for your help and suggestion.

[cbatrody]

Hi,

Welcome to the Forum.

Can you please post a sample file in excel format rather than image? Images are impossible to edit and requires a lot of effort to recreate the file in excel.

See the following URL for help on how to upload a file.
http://www.excelforum.com/members/da...ch-a-file.html

[Skinnyboy12]

Hi cbatrody,

Thanks for the welcome and help.

I added the excel file to this message.

[FDibbins]

Which column do you want this based on?

Have you considered using filters for this?

[Skinnyboy12]

Hi FDibbins,

This could be based on several column. For one date, I can get a project due in stage 1 and another project due in stage 3. I will need this 2 project to appear.

The file I shared is already a filtered part of a bigger spreadsheet. It is doable with filters, but very time consuming, especially for a report. The need is to isolate the relevant data quick for the day.

Hope this explains a bit better the issue.

[FDibbins]

There are other ways to do this, but see if this works for you - it uses a helper column in K...
K2=IF(COUNTIF(A2:J2,">="&TODAY())>0,K1+1,K1)
copied down as needed

This tests to see if ANY date in the row is >= today, if so, it creates a unique sequence number

On a new sheet...

	A	B	C	D	E	F	G	H	I	J
1	Project ID	Stage1 Base	Stage1 Forecast	Stage1 Actual	Stage2 Base	Stage2 Forecast	Stage2 Actual	Stage3 Base	Stage3 Forecast	Stage3 Actual
2	Project 5	42394	42394	42394	42528	42549	Not Submitted yet	42544	42585	Not Submitted yet
3	Project 6	42409	42409	42409	42527	42543	42543	42543	42557	Not Submitted yet
4	Project 8	42522	42544	42544	42551	42608	Not Submitted yet	42646	42646	Not Submitted yet

A2=IFERROR(INDEX(Sheet1!A:A,MATCH(ROW()-1,Sheet1!$K:$K,0)),"")
copied down and across as needed

[Skinnyboy12]

Hi FDibbins,

I had to do a few modification to your formulas for my report spreadsheet but it works.

Thanks a lot for the help.

[FDibbins]

Awesome, happy to help

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)