Blank cells

[Diane K]

I have an exported file that looks something like this:

A B
1 NAME AMOUNT
2 Indiana Finance 100.00
3 30.00
4 27.50
5 TOTAL 157.50
6 Ace Hardware 1.50
7 35.00
8 12.00
9 92.00
10 TOTAL 140.50
11


It only lists the name once in column B but I need it repeated for sorting
purposes. Is there a formula I can use to check B3 and if it's blank, take
the value from cell B2 and if it's not blank leave it alone? In C3 I tried
=IF(A3="",A2,""). That worked for the first cell, but then the others gave a
value of 0.

Ideas?

TIA!
Dino

 

[FM]

A B

1 NAME AMOUNT
2 Indiana Finance 100.00
3 30.00
4 27.50
5 TOTAL 157.50
6 Ace Hardware 1.50
7 35.00

try:

in C2:
=A2

in C3 (to be copied below):
=IF(A3="";C2;A3)

FM

 

[Diane K]

Thanks FM. That worked!

try:

in C2:
=A2

in C3 (to be copied below):
=IF(A3="";C2;A3)

FM