LinkBack URL
About LinkBacks
Hi,
I am trying to rank the smallest values in order and exclude the zeros. I want the formula for the second table so it can easily calculate without individually putting the data in if there are multiple rows.
Thanks.
here is a attached sheet.
Hi,
I am trying to rank the smallest values in order and exclude the zeros. I want the formula for the second table so it can easily calculate without individually putting the data in if there are multiple rows.
Thanks.
here is a attached sheet.
Please note that the formula in F18, copied down is an array formula.
Array Formulae are a little different from ordinary formulae in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.
is this materially different fom your other thread??
Don't type the curly brackets yourself - it won't work...
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
Yes this was different from the other material. Thanks for your help Glen! Appreciate the fast help. This worked perfectly
Once again... you're welcome.
I attach file another way by Advance Filter.
Plz refer highlighted.
Create criteria
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks