I have a worksheet with time values in the first column (values are hh:mm:ss am/pm) and a text value in the next column. Text is either red, green or yellow. Already I've made a column that has a value of 1 if the its red, and another column that gives a value of -1 if its green.
The purpose is to find out how many reds I have of a minute (minus greens becuase green means its not red anymore. )
So what I did was a another column with this value: =J7+G8+H8
J is the column with the total for red values, G has a 1 if red, H has a -1 if green.
K, follow that? So now I'm looking for a sum per minute, or the highest value in J for the times that match to the minute.
K, total newb to this, dunno if I need a macro or not, or what.
Please help, and if you could in a way that will teach so Im not just getting someone to do my work
The purpose is to find out how many reds I have of a minute (minus greens becuase green means its not red anymore. )
So what I did was a another column with this value: =J7+G8+H8
J is the column with the total for red values, G has a 1 if red, H has a -1 if green.
K, follow that? So now I'm looking for a sum per minute, or the highest value in J for the times that match to the minute.
K, total newb to this, dunno if I need a macro or not, or what.
Please help, and if you could in a way that will teach so Im not just getting someone to do my work