Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & Extract
hi,
I have data in Col A and i would like to get the data in Col B only if the value in Col A is greater than 3 and less than 5 . A B 1 2 2 3 3 4 4 5 6 I am looking for a formula. Any ideas on this please. best regards, Meeru |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & Extract
try this
=IF(AND(A13,A1<5),A1,"") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Meeru" wrote: hi, I have data in Col A and i would like to get the data in Col B only if the value in Col A is greater than 3 and less than 5 . A B 1 2 2 3 3 4 4 5 6 I am looking for a formula. Any ideas on this please. best regards, Meeru |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & Extract
Why did you type 2,3,4 while the one and only answer, to the presented data,
is: 4 ? Micky "Meeru" wrote: hi, I have data in Col A and i would like to get the data in Col B only if the value in Col A is greater than 3 and less than 5 . A B 1 2 2 3 3 4 4 5 6 I am looking for a formula. Any ideas on this please. best regards, Meeru |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & Extract
I have data in Col A and i would like to get the data in Col B only if the
value in Col A is greater than 3 and less than 5 . Here's one way, assuming the data starts in row 2. It uses column C as a helper column. In C2, put =IF(AND(A23,A2<5),MAX(C$1:C1)+1,"") In B2, put =IF(ROW()-1MAX(C:C),"", OFFSET($A$1,MATCH(ROW()-1,C:C,0)-1,0)) Select B2:C2 and copy down as far as column A can reach. Row 1 and column C can be hidden, if desired. Modify to suit. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and extract text from cell | Excel Discussion (Misc queries) | |||
how to use vlookup/find etc to extract rows | Excel Worksheet Functions | |||
search or find, and extract? | Excel Discussion (Misc queries) | |||
find a name from a list then extract it | Excel Discussion (Misc queries) | |||
Find a worksheet and extract data | Excel Worksheet Functions |