Hi forum
I am trying to show on a main dashboard worksheet the highest number in a worksheet column, problem is it will have either an A or an E in fort of the number.
For example the value i have tried using for column A is the standard =MAX(A6:A500) but it comes up with 0 due a letter in from of the number.
Any suggestions appreciated..
Thanks
JNEWMAN
seems like the simplest way is with a helper column where you use this formula to get the values into another column then max on that...
=--MID(A6,2,99) and drag down, then the max formula on that.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Re: Finding the highest number in a colum when it has a letter before it.
Simple it may be but it does the job my friend...
Many thanks
JNEWMAN
Try this array formula
Please Login or Register to view this content.
confirm with Shift + Ctrl + Enter
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Without helper column may be as below and array entered(Using control shift and enter)
=MAX(0+MID(A6:A500,2,99))
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
duplicated thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks