How to start count after 4 times the number show up

[davi65]

I am having a problem with this. How can I start count after a work show up in the column for 4 times.

I attached the sheet.

[Richard Buttrey]

I don't follow. New York has shown up 7 times before you note on D53 that the count should be started. Why not start on row 26 after the 4th occurrence?

[davi65]

Richard. I can repeat new york 4 times before I can start count. So from the begin of the year I can repeat new york only 4 times after that I need to show the number of times I enter new york on the list.

[José Augusto]

Try this
F1=4 and F2="NEW YORK"
Use in F3 and copy down

Please Login or Register  to view this content.

[davi65]

All most there !

[CAABYYC]

C3=MAX(COUNTIF(B$1:$B3,$B3)-4,0) then copy down

0 means that work shows up for less than or equal to 4 times
1 or other greater than 0 number means the sequence number after 4

I am having a problem with this. How can I start count after a work show up in the column for 4 times.

I attached the sheet.

[davi65]

No CAA just turn True and false

[José Augusto]

Hi Davi65
See if is this what you want
Use in F3 and copy down

Please Login or Register  to view this content.

See the file

[davi65]

hi davi65
see if is this what you want
use in f3 and copy down

Please Login or Register  to view this content.

see the file

thank you !!!!

[José Augusto]

I'm happy to have helped.
Thanks for the reputations points added.

[davi65]

Good Morning Folks,

I need your help again. On Cell J5 I needs to do a count down base on number of times a person enter the word UA and when that count hit 0 stop count so I will do from 6 to zero and stop.

Now the big issue.

On the Total Rolling Year column K I need to add up the total numbers of entries after 6 entrie I have the formula that Jose gave to me. Here is the sheet check Column K...

line 35 if we add 2.00 point that will total 3 when needs to be 2 not 3.

[davi65]

My first problem i was able to resolved

=IF(J5=0,6,IF(J5=1,5,IF(J5=2,4,IF(J5=3,3,IF(J5=4,2,IF(J5=5,1,IF(J5=6,0,IF(J5>6,0)))))))) Just doing a count down to 0. Envery time you enter a UA will count down on j4

[popipipo]

Please Login or Register  to view this content.

Try this

[Glenn Kennedy]

Is this what you mean??? J11, copied down:

=MAX(6-COUNTIF($B$11:B11,"UA"),0)

[Glenn Kennedy]

I don't understand what you want in column K, at all!!

[davi65]

I don't understand what you want in column K, at all!!

After you enter 6 times UA I will start count. If you enter 8 times UA 6 OUT THAT 8 will not count as point per year.


Now when I enter in the sheet 8 times UA the total per year add up to 3 not 2... where....

6 TIMES will not count

7 - count

8 count

so the total per year should be 2 not 3.

[davi65]

Is this what you mean??? J11, copied down:

=MAX(6-COUNTIF($B$11:B11,"UA"),0)

Cool this work.

THANK YOU

[Glenn Kennedy]

I'm still not sure if I follow the logic of this... Hopefully you will!!! In K11, copied down:

=MAX(COUNTIF($B$11:B11,"UA")-6,0)

[davi65]

I'm still not sure if I follow the logic of this... Hopefully you will!!! In K11, copied down:

=MAX(COUNTIF($B$11:B11,"UA")-6,0)

NO. Glenn


Here is the rules to add up.

Unexcused Absence(After 6 sick days exhausted) UA 1
Tardy T 0.25
Early Quit EQ 0.5


If I copy down your formula I will not be able to sum when the user enter T or EQ. I need Column G to show 1.00 every time a UA appears after 6 times right now I am adding up after after UA appear 6 times.

[Glenn Kennedy]

maybe this:
=IF(B15<>"UA","",IF(COUNTIF($B$11:B15,"UA")>6,1,""))

copied down

[davi65]

maybe this:
=IF(B15<>"UA","",IF(COUNTIF($B$11:B15,"UA")>6,1,""))

copied down

Thank you Glenn. All done.