Sorting" #VALUE!

[yekut1102]

Hi All,

I have a workbook linked to database and I've set up macro module (a very simply one--ctrl+alt+shift+F9--to update the cells to the latest information), from there I must find the highest value so I used the =Max function, but instead of giving me the highest real value it simply gives me "#VALUE!" for the yet to be determined values.

How can I find the max value that is a real number and not #VALUE!?

Thank you guys in advance! I really appreciate the help as I become more familiar with the command structure!


All the Best,

Dan

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=577161

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).