Hello, I need help with a formula for looking up a range of numbers in different cells and giving me the highest number within that range.
IE:
My range is 25-29
I'm looking up in cells s10:at10
Now I want the highest number within my range from those cells.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Formula:
Please Login or Register to view this content.
Last edited by JohnTopley; 05-04-2024 at 05:31 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
This works in Excel. You could try it in Google Sheets:Formula:Please Login or Register to view this content.
See: https://support.google.com/docs/answer/7013817?hl=en
Last edited by TMS; 05-04-2024 at 05:22 AM. Reason: Add reference
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Neater: =LET(rng,S10:AT10,MAXIFS(rng,rng,">=25",rng,"<=29"))
See: https://support.google.com/docs/answer/13190535?hl=en
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks