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

J

JPG

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
 
M

Max

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,MATCH(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
 
J

JPG

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.
 
M

Max

JPG said:
Unfortunately, only response is to return #VALUE ...
Click to expand...

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 ..
 
Top