hi again, how we can have such a formula which work like:if A1>3 ,extract the values of B1:B18 to The F1:F18 column?thanks
hi again, how we can have such a formula which work like:if A1>3 ,extract the values of B1:B18 to The F1:F18 column?thanks
Last edited by Glenn Kennedy; 09-08-2019 at 01:10 PM.
Your thread title was weak. It should really resemble the words you would use in a Google search. I have changed it for you, on this occasion. n future, your thread may be locked until YOU make the required changes.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
ok , bro ,thanks
Change A1 to 3 and use:
=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($B$1:$B$18)/($B$1:$B$18>$A$1),ROWS(F$1:F1))),"")
sorry, where is the 1,2,3 at F1:F18,they are not extracted ,if A>=3,copy values to f1:f3,if A1<=3 dont copy
and can we use another formula ,more simplier.
Last edited by sakis777; 09-08-2019 at 01:24 PM.
Please explain again. You said you wanted ONLY those values > 3 extracted. That is what the formula does.
If that is NOT what you want, amend your attachment to show your expected results and stop us having to guess.
Dear Glenn, a formula at f1:f18 which copies the data of a1:a18 only if A1>=3. if A1<=3 not to copy the data of a1:a18 so f1:f18 will be empty
F1=IF(B1>=RIGHT($A$1,1)+0,B1,"")
copy down
If Caracall a is not right... read what I said at Post 6 and act on it. Post a sheet with expected results.
no,simply,is if a1>3 copy all values of B1:B18 and paste them at F1:F18
Last edited by sakis777; 09-08-2019 at 02:07 PM.
there no expexted results,is just what i said,please help me Glenn
How about in F1 & copied down
=IF($A$1>3,B1,"")
then input a number into A1
that formula does not do anything,i try
Did you put a number into A1?
Or do you mean if A1 equals ">3" rather than A1 is greater than 3?
maybe kind of Vlookup formula if a1>3 or coutif ?
i put a number 3, ok you are right i put 4 and is working
can we use a range B1:B18 insted of B ?
I don't understand.
ok ,its fine ,thank you
It's very simple. Put what you WANT to see in column F in colums F YOURSELF. Just enter your expected answers and repost.
Sakis, I have no idea who you are talking to in ANY of your recent posts. SAY who you are talking to... otherwise this is becoming a total mess.
Did you look at the file I posted? In what way was it wrong????
Last edited by Glenn Kennedy; 09-08-2019 at 02:43 PM.
Glenn
I think the op wanted all the contents of col B in col F, if A1>3, rather than just values from col B that were >3
yes , is solved . thanks
delete post
Last edited by CARACALLA; 09-08-2019 at 02:46 PM.
=IF($A$1>3,B1,""), is doing the job..its fine.thanks
Yeah, the op wasn't very clear on that.
you are right,thanks Glenn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks