Any excel wizards out there....

[Postforce]

...Hi all

I've got some data that has a different amount of completed cells in each row - what I need to do is take the last completed cell from each row and copy it to its own column. - Anyone know of a simple formula for such a nasty task??

Thanks in advance

 

[spreadsheetsdirect]

Hi, if they're all text and not numbers try...

=OFFSET(A1,,MATCH("",$A1:$E1,-1)-1,)

where A1 is the first cell in the row and $A1 : $E1 is the full range of cells in the row to check.

 

[Astaroth]

=OFFSET(A1,0,COUNT(1:1)-1)

The above would be the formula for Row 1. Row 2 would be:

=OFFSET(A2,0,COUNT(2:2)-1)

etc

This only works if there is no blanks

 

[JackieC]

I am not sure I have grasped the problem. Can you send me an example and I will see what I can do for you? Jackie dot Campbell at WebWorking4u dot co dot uk.

Jackie