Pull last columns' answer until answer changes

[Kevin M]

Hi all, TIA

I'm working on a sheet that is tracking jobs per week. If the guys are
working for Company A, they enter the company name in one cell and then leave
that row empty until the next job for a different/or same company. What i'd
like to do is to count the daily # of jobs but Company A is only typed in one
column so the answer needs to remain the same as the last one unless there is
another Company A typed further down the row:

C D E F
G
Company A Company A
Company A
So instead of counting 1, 0, 0, 2, 0 it will instead keep the previous
number until there is a new entry: 1, 1, 1, 2, 2
I tried a Countif embedded in an IF:
In C1024=IF(COUNTIF(D11011,"Company
A")<>C1024,C1024,(COUNTIF(D11011,"Company A")
This half works, the failure is that it will not recognize and report change.

I hope this is somewhat readable.

 

[Dave Peterson]

If I were doing this, I'd fill those empty cells with the value from above.
Then I'd use format|conditional formatting to hide those (white font on white
fill, so the cell looks empty).

If that sounds reasonable, make a visit to Debra Dalgleish's site:

http://www.contextures.com/xlDataEntry02.html
and
http://www.contextures.com/xlCondFormat03.html#Duplicate