Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
take values from column A for values0 in column B
I have a table similar to Sheet 1 and need convert to Sheet 2, Exist a
function or how work??? Sheet 1 Sheet 2 Cod Value | C1 C5 C7 C1 25 | C2 | C3 | === C4 | C5 10 | C6 | C7 2 | |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
take values from column A for values0 in column B
Hazarding a guess here, piecing from your subject line and posting ..
Presume you want to extract horizontally & bunched to the left in Sheet2, only the codes: C1, C5, C7 (in Sheet1's col A) for values 0 in the "Value" col (in Sheet1's col B) Data is assumed running in row2 down in Sheet1's col A and B In Sheet2, Put in A2: =IF(Sheet1!B20,ROW(),"") Copy down to cover the max expected extent of data in Sheet1's col B. Leave A1 empty. Hide away col A. Put in B2: =IF(COLUMNS($A:A)COUNT($A:$A),"",INDEX(Sheet1!$A: $A,SMALL($A:$A,COLUMNS($A:A)))) Copy B2 across to cover the max expected number of returns. In B2 across will appear the required results: C1, C5, C7 (based on your sample posted) with all results neatly bunched to the left. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Mauricio G." wrote: I have a table similar to Sheet 1 and need convert to Sheet 2, Exist a function or how work??? Sheet 1 Sheet 2 Cod Value | C1 C5 C7 C1 25 | C2 | C3 | === C4 | C5 10 | C6 | C7 2 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions |