One big nested if should do nicely...
J4 = If(G4<"",G4,If(F4<"",F4,If(E4<"",E4,If(D4<"",D 4,If(C4<"",C4,B4)))))

Not tested could be missing a paren.
--
Charles Chickering

"A good example is twice the value of good advice."


"jonco" wrote:

I have a spreadsheet that has data in row 4, colums B thru G. There are
formulas in these cells that get numbers from other cells (if applicable -
sometimes these cells are blank). Sometimes the cells in the row might only
contain numbers from B4 to D4. Other times the numbers might be in cells
B4 to F4.
What I need is to be able to put the last visible amount in row 4, wheter it
be in column B,C,D,E,F or G into another cell... J4 for example.

Any help would be appreciated.

Jonco