•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I need to convert a MAX function so that it gives me the name of the number instead of the number itself
I'm working on a little project involving Pokemon and because i have so much info, i'm trying to create a new line that organizes what the strongest stat for each given pokemon is so i can use this info for other stuff.
I know a simple MAX(FirstCell:LastCell) function can get me the highest stat itself, but i need to then figure out if it's the Attack or Defense or whatever, and then instead of giving me the number, give me the name of the stat. So like in the example i shared above, it sees that Sceptile's speed is it's highest stat, so instead of saying 120 over on Contest-1, it says Speed
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#Pokemon
#MAX function
#strongest stat
#Speed
#Attack
#Defense
#info organization
#Excel
#highest stat
#Sceptile
#stat name
#Contest
#data management
#data analysis