Select data from 1st of up to 6 columns & Xfering to other workshe
 

In Worksheet Data, I have an unpopulated column 'a' and 6 columns 'b' through
'g' which may have data in all or only one of the columns.
I would like to copy the 1st 10 bits of data from the 1st of columns 'b'
through 'g' that is populated.
Then I would like to copy the resulting data in column 'a' from Worksheet
Data to column 'g' Worksheet Report.
Many thanks
jpg

Select data from 1st of up to 6 columns & Xfering to other workshe
 

One interp & a formulas play ..

In Data,

Put in A1's formula bar, then array-enter the formula
(press CTRL+SHIFT+ENTER):

=IF(ISNA(MATCH(TRUE,B1:G1<"",0)),"",INDEX(B1:G1,M ATCH(TRUE,B1:G1<"",0)))

Copy A1 down to say, A10
to cover the max expected extent of data in cols B to G

Col A will return the leftmost populated cells from cols B to G

Then in Report,

Put in G1: =IF(Data!A1="","",Data!A1)
Copy down to G10

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JPG" wrote:
In Worksheet Data, I have an unpopulated column 'a' and 6 columns 'b' through
'g' which may have data in all or only one of the columns.
I would like to copy the 1st 10 bits of data from the 1st of columns 'b'
through 'g' that is populated.
Then I would like to copy the resulting data in column 'a' from Worksheet
Data to column 'g' Worksheet Report.
Many thanks
jpg

Select data from 1st of up to 6 columns & Xfering to other workshe
 

Hi
Many thanks for help. I have tried the recommended solution.
Unfortunatly, only response is to return #VALUE in column B1 thro B12; MS
Excel Help tells me that I should ensure that the Function is not using an
incorrect argument.

"JPG" wrote:

In Worksheet Data, I have an unpopulated column 'a' and 6 columns 'b' through
'g' which may have data in all or only one of the columns.
I would like to copy the 1st 10 bits of data from the 1st of columns 'b'
through 'g' that is populated.
Then I would like to copy the resulting data in column 'a' from Worksheet
Data to column 'g' Worksheet Report.
Many thanks
jpg

Select data from 1st of up to 6 columns & Xfering to other wor
 

"JPG" wrote:
Unfortunately, only response is to return #VALUE ...

The suggested formula has to array-entered, as stated. Array-entering means
pressing CTRL+SHIFT+ENTER to commit the formula, instead of just pressing
ENTER. Try it again ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---