display value

[flakedew]

I have 4 columns having data in any one or two columns against each row.
in the 5th column i need the value of the first cell from the 4 columns

In the 3rd row under column5 the value is 5, which is the first cell in the row, through there 2 entries in that row, only the first entry is shown in column5.

I need a formula or macro please.

[Russell Dawson]

Hi

Try this in F1

Please Login or Register  to view this content.

and copy down

[flakedew]

Working Perfect....
Thanx Thanx Thanx

[Russell Dawson]

My pleasure. Please don't forget to show your appreciation in the usual way. It would be much appreciated. Cheers.