| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| MATCH UP DATA IN COLUMNS | Excel Worksheet Functions | |||
| Data in narrow columns truncated when saving as DBF | Excel Discussion (Misc queries) | |||
| SELECT large amount of data in a worksheet | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
Hybrid Mode
