A bit clearer?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"da" wrote in message
...
Hi
If I want to replace 0 with a name above zero, is there a way to do it? I
have about 350 names to replace, where the zero is under the name row. I
got
the zero when tried to get a sub total of hours and amount columns (not
shown).

thank you and Happy New Year.


8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 SANTIAGO
8 Total 0
14 LECOURS
14 LECOURS
14 LECOURS
14 LECOURS
14 LECOURS
14 LECOURS
14 LECOURS
14 LECOURS
14 LECOURS
14 Total 0
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 BRUNO
25 Total 0