Hi,
I was wondering if it is possible to adapt the following formula so it skips cells that are blank within the range.
Currently there is only one value which is a grade achieved by a student (C) , And over the next months a new grade will be put in, so excel is just returning VALUE.
Please Login or Register to view this content.
I have placed the IFERROR in this formula so is there is no values at all the cell shows blank.
Something like this perhaps would be acceptable, array formula:
=CHAR(MIN(CODE(IF(Q11:Q14>"",Q11:Q14,"|"))))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you very much this seemed to have worked!!
Would there be anything that may cause this not to work?
Thank you very much this seemed to have worked!!
Would there be anything that may cause this not to work?
See your other thread.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Is there a way to make this formula show no value if all cells are blank?Originally Posted by JBeaucaire
See your other thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks