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.
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.