by k0st4din » Mon Dec 19, 2011 9:42 am
Hi
I do not know exactly what you can not understand, so I repeat again, with a little more clarification. The table which I'll attach the applicable H2 (MAX) -> me to get the highest value from column B in H3 use Lookup to return my name in column C, but this happens only if (C) - I is sorted in ascending order, IF Shuffle - I know very well not happen. I'm looking for this formula that when mixed points in column C, somehow my name appear responsible for the highest score. And then search again with a formula to deliver me into a cell (no matter which), the full list of these names from column B that are smaller than 75 (B) and less than 3 (F). Subject headings: 1000 number (A1: E1000). I apologize if you still can not understand me, but I hope this time is specific and precise.
You do not have the required permissions to view the files attached to this post.
So ...
1. *Consider well what is your wish.
2. *Make a sample table
3. *Describe in detail what you want to happen is to be understood, not only by yourself.
4. And if you help someone else who needs help.