|
|
#2
03-08-2018, 03:00 PM
|
||||
|
||||
You have trailing spaces after the word "Moderate" in column N and after MD/DO in column P.
Also, you should not use full column ranges in Array formula as they are processor expensive. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to change the formula to get this result ....
|
LearnerExcel | Excel Programming | 2 | 02-11-2018 08:26 PM |
| IF Formula not returns result - Help | Haha88 | Excel | 6 | 02-11-2018 02:07 PM |
| Array Formula | Macacidic | Excel | 2 | 09-12-2017 08:19 AM |
|
formula, 2 criteria, one result
|
cjdstephenson | Excel | 4 | 06-02-2015 09:17 PM |
|
Complex array formula
|
andrei | Excel | 9 | 02-03-2012 03:40 AM |
Windows 10 
Office 2013
Threaded Mode