[Swankrain]

Hello all.

Hope you can help me.

Here is my situation. I have one worksheet that is pulled from our server that provides number of days since an issue has been started next to a specific subject number. It is in number format the ones that are complete are blank.

What i am trying to accomplish is I have created a list of all the subjects that are part of this project and I need to be able to display which subjects have issues that are between 1-30 days old 31-60 days old and 61 and 90 days old. This is on a totally different sheet so references are to be made.

I have attached screenshots to give the idea of what I'm trying to get done.

Thank you in advance for any and all help.

[Stoneboysteve]

Have you tried Pivot analysis? You have a data sheet, with a Pivot table or two you could display by days.

Stoneboysteve