Modify formula so that it works with alphanumeric data

Hi,

I have the following formula in cell Q3, which works fine with numerical data:

Please Login or Register  to view this content.

The challenge I have is to make this formula work for alphanumeric data (numerical data, numbers stored as text and text strings).

I have attached a workbook that shows the three variations of data in Table 1, Table 2 and Table 3, along with the expected results in Table 4, Table 5 and Table 6, respectively. Empty grey cells may be blank or contain invisible single quotes (').

I need the single formula to work with all three data types.

Best regards,
Marbleking

Splendid! Thank you so much, Bo_Ry!

Regards,
Marbleking