I get a group of numbers every day which i sort in a column in descending order. i have another 3 cells where i get 3 values which are linked from another cell which change every day.
i want to extract numbers in the sorted list from value 1 to value 2 and paste it in one column and extract another list from value 2 to value 3 and post it in another column.
Without too many details, I can assume that is something like this: https://www.get-digital-help.com/ext...this-and-that/
Click the * to say thanks.
yes it is exactly like this, this is what i wanted. now i know how to do it. but i dont think i have the skill set to actually achieve it. thanks anyway.
I would like to let you know that i have achieved my desired result. thank you so much for your help. saw the youtube video and the job is done now.
i needed to sort the K column between upper circuit to close and close to lower circuit.
Capture.JPG
new problem now, is there anyway i can get all the num! error cells to automatically read zero as an output if there is no value attached to it.
Try wrapping the formula in an IFERROR trap:
=IFERROR(yourformula,0)
This may not work if you are still using Excel 2007.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Used the equal to cell reference and iferror function.
using 2007, my formula was an array formula =SMALL(IF(($D$14<$K$1:$K$27)*($D$15>=$K$1:$K$27),MATCH(ROW($K$1:$K$27),ROW($K$1:$K$27)),""),ROWS($A$1:A1))
where can i insert the iferror in this?
=iferror(small(if(($d$14<$k$1:$k$27)*($d$15>=$k$1:$k$27),match(row($k$1:$k$27),row($k$1:$k$27)),""),0)
thank you so much, its done now
Attachment 645927
No worries.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks