Upload a sample workbook.
i cannot upload anything here , we have restrictions to do that.
Please let me know if you need more information.
I need something to work with. These things often depend on how you want the sheet set up.
Mock up what your sheet and data look like. Check out the following video:
Help me to help you. Without something to work with, I can't do much for you.
I'm looking for a way to count the number of weeks a particular item has a Red or count as per color.
Color displaying based on 3 status values. example : approved, rejected, inprogress.
So the problem is i need to count the no of weeks that has approved status ,no of weeks that has rejected status etc
. I would like to be able to show how many weeks, including this week that this has been Red.
I then want to add this to a Tablular format that displays the results or count of weeks for a particular status.
My data (in excel) has columns for date (weekly), ref code, status plus others.
Any ideas please?
You could have had this done by now.
And if your data is in excel, it's even easier for you to chop out proprietary columns, shrink down the number of rows, etc. (The first step in that video is to put your data into excel for easier manipulation.)
Again, some of what you will need to do depends on how you have things set up. That's why I need to see a workbook. (Not just an excel file.) Also, when you upload a workbook, I'll know what version you are using, and I can return a modified workbook to you in the right version.