Hello!!! Need some Help plz,
I have the table bellow
data1 date1 20
data2 date2 -35
data3 date3 35
data4 date4 10
data5 date5 20
data6 date6 30
data7 date7 50
If the values in column 3 is greater than 20 I would like to return the hole array in a different array ,the problem is when i have many arrays with that condition . I would Like all of them to be returned the
one below the other .
Thank you
Καλησπέρα πατρίδα!
What you mean when you say "array"? range?
Can you upload a small sample workbook?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi,
you can use a custom filter, where you filter column 3 with the condition of > 20. After that you can copy the filtered range.
OR, first try this ARRAY formula.
=IFERROR(INDEX(Sheet1!A$1:A$10;SMALL(IF(Sheet1!$C$1:$C$10>20;ROW(Sheet1!$A$1:$A$10));ROW(Sheet1!A1)));"")
Copy down and across.
Edit: For other users
In Greece, we use semi colons as separators. So you need to change all semi colons in my formula to comma!
Eyxaristw Foti Lew na to afhsw opws einai
Thank you all for the quick reply
Translate: Thanks Fotis, i"ll let it as it is...Eyxaristw Foti Lew na to afhsw opws einai
Welcome.
You know better than us
Sorry how can I attach a file?
Please take a look at this spreadsheet
This one is the corrextCopy of Book1566.xlsx
As i said, in A21 this ARRAY(control+shift+enter)-not just enter, formula.
Copy down and across.
=IFERROR(INDEX(Sheet1!A$1:A$16;SMALL(IF(Sheet1!$G$1:$G$16>20;ROW(Sheet1!A$1:A$16));ROW(Sheet1!A1)));"")
You have no value in column G >20, so you get an empty table!!!!!
Thanks for the reb*
If this means that my suggestion works for you, pls mark your thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
ecelaras 
Register To Reply
Bookmarks