J
jjk
Hello I need some help with a few formulas. Any help is appreciated..ok
lets say every day a colour is picked monday to friday(sometimes 2 colours a
day are picked) at any rate there are 5 different colours. i need a formula
that will automatically calculate how many times a month a certain colour
shows up. also will let me know if the same colour shows up on the same day
more then once. i have attached a sheet of a month of colours, but i cant
figure out a formula to calculate what i need to know. I would also like to
monitor over a few months and see if a pattern developes. are graphs
possible, to show percentage of times any given colour comes up through the
month?
Thanks in advance for all your help
emaIL ME (e-mail address removed)
lets say every day a colour is picked monday to friday(sometimes 2 colours a
day are picked) at any rate there are 5 different colours. i need a formula
that will automatically calculate how many times a month a certain colour
shows up. also will let me know if the same colour shows up on the same day
more then once. i have attached a sheet of a month of colours, but i cant
figure out a formula to calculate what i need to know. I would also like to
monitor over a few months and see if a pattern developes. are graphs
possible, to show percentage of times any given colour comes up through the
month?
Thanks in advance for all your help
emaIL ME (e-mail address removed)