I have a formula (below) in a cell that displays the name of a high scorer from multible scorers and a vertical range of calculated numbers; =INDEX($D389:$D505,MATCH(MAX(G403:G505),G403:G505,0)).
When the vertical range has no entries the present formula defaults to the first name on the list of the team members in another vertical range. How can I get it to default as an ‘empty’ cell or a ‘hyphen’ in the cell... So a high scorers name only appears when points are entered.
Thank You, Craig
Try
=IF(COUNT($G$403:$G$505),INDEX($D389:$D505,MATCH(MAX(G403:G505),G403:G505,0)),"-")
Marcelo Branco
Thank you for responding, but it has failed and returns the same default. I have tried playing with you formula and still no solutions. If you have another idea I would be grateful.Originally Posted by mlcb
Maybe:
=IF(SUM(G403:G505)=0,"-",INDEX($D389:$D505,MATCH(MAX(G403:G505),G403:G505,0)))
If you can post an example of your work or something for me to play with, I'll gladly take a crack at it for you.
Last edited by daffodil11; 09-26-2013 at 05:14 PM.
Could you provide a small data sample and expected result?
There is something strange in your original formula
=INDEX($D389:$D505,MATCH(MAX(G403:G505),G403:G505,0))
Shouldn't it be?
=INDEX($D403:$D505,MATCH(MAX(G403:G505),G403:G505,0))
Why are you using D389:D505 if the MATCH function is looking for the position of the MAX in range G403:G505?
Could you, please, clarify?
Been away for a year now, but wanted you (daffodil11) to know that although your response was greatly appreciated it did not solve the problem, HOWEVER, in your response there was enough direction that I worked it out to be:
=IF(SUM(G223:G258)>0,INDEX($D209:$D243,MATCH(MAX(G223:G258),G223:G258,0))," ")
THANKS AGAIN
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks