Excel personnel tracking sheet
Closed
hudabble
Posts
1
Registration date
Sunday March 27, 2011
Status
Member
Last seen
March 27, 2011
-
Mar 27, 2011 at 11:20 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 28, 2011 at 04:07 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 28, 2011 at 04:07 AM
Hello,
I am trying to make an excel sheet that counts consecutive days that a person is on the list...the list being days that certain personnel were present or not. For example, in the first column there is a list of names of personnel in alphabetical order. The names are highlighted either red or yellow depending if they were there that day....If the names are yellow 15 days in a row I want the name cell to turn a specific color and 16 days a different specific color. If the name column is red I want to reset the count back to zero. I figured that I could create a date column next to the name that changes to a set date once it is first highlighted yellow and creates the condition (first.yellow.date. + 16>actual date) and if red set conditions back to zero.......PLEASE ADVISE
I am trying to make an excel sheet that counts consecutive days that a person is on the list...the list being days that certain personnel were present or not. For example, in the first column there is a list of names of personnel in alphabetical order. The names are highlighted either red or yellow depending if they were there that day....If the names are yellow 15 days in a row I want the name cell to turn a specific color and 16 days a different specific color. If the name column is red I want to reset the count back to zero. I figured that I could create a date column next to the name that changes to a set date once it is first highlighted yellow and creates the condition (first.yellow.date. + 16>actual date) and if red set conditions back to zero.......PLEASE ADVISE
Related:
- Excel personnel tracking sheet
- Mark sheet in excel - Guide
- Sheet right to left in google sheet - Guide
- Windows network commands cheat sheet - Guide
- How to screenshot excel sheet - Guide
- How to open excel sheet in notepad++ - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 28, 2011 at 01:25 AM
Mar 28, 2011 at 01:25 AM
how have you designed the data sheet. post a very small extract. Instead of 15 days restrict to 5 days (for samplle purposes).take only five names
The solution depends upon the data sheet.
The solution depends upon the data sheet.
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 28, 2011 at 04:07 AM
Mar 28, 2011 at 04:07 AM
Could you please upload a sample Excel file WITH sample data, macro, formula, conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc.
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
P. S.: your data need not be to be real data but a good representative of how data looks like
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
P. S.: your data need not be to be real data but a good representative of how data looks like
