It looked like I could make this work, but it appears that the function i'm using to put together the string of numbers (4.5, 6, 8.7, 9.2, 10.5, 23, etc...) isn't returning the values as numbers so your function won't work. Ideally I'd like a formula where I could call a number position IE. 1, 2, 3.. Highest, Second Highest, Third Highest and just return that single value to a cell.
I'll attach a portion of the spreadsheet so you can see exactly what I'm doing. This is for a fantasy football league and I'm trying to create a formula in excel to determine a person's optimal lineup in a given week (highest possible score using bench players in place of a starter who didn't do as well).
I'm using a web query to download the data directly from ESPN, but I'm not really experienced with that. This is probably a topic for another post though. I'm sure there are ways I could streamline how i'm doing that as well....
Anyway, I'm currently using 2 functions in the sheet.
You can see on the 2nd sheet what I'd like the results to be. I need to search the array for the highest QB score, the 2 highest RB scores, the 2 highest WR scores, the highest total for the flex slot (3rd RB or 3rd WR, whichever is higher), the 2 highest DP's, and the highest K, TE and D/ST.
Typically there will be more variety than just WR and RB on the bench. In Column C you'll notice that I used GetElement to pull the player's position from their name line. I used an IF statement because defensive players are listed by their actual position but I need their value returned as DP.
I probably should have disclosed all of this from the start. Thank you very much for your work on this so far. Any additional help you could provide would be very much appreciated.