|
|
#4
02-21-2019, 09:08 AM
|
|||
|
|||
Is (24%) just something you enter and not the result of another formula? If Yes, try:
="After-Tax Balance " & TEXT(INDEX(AH:AH,MAX(IF(AH5:AH200="",FALSE,ROW(AH5 :AH200)))), "$#,##0")&" (24%)" Array-entering not necessary. (By the way - never use full column references in array formulas, that's really bad practice). 
|
| Tags |
| array, concatenate |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Array formula value not available error for one result | emarkona | Excel | 1 | 03-08-2018 03:00 PM |
| Array Formula | Macacidic | Excel | 2 | 09-12-2017 08:19 AM |
 Excel simplify formula - array of sequential numbers
|
Wries | Excel Programming | 1 | 05-12-2014 08:32 AM |
|
Convert String Array to Integer Array from a User Input?
|
tinfanide | Excel Programming | 4 | 12-26-2012 08:56 PM |
|
Complex array formula
|
andrei | Excel | 9 | 02-03-2012 03:40 AM |
Windows 10 
Office 2016
Threaded Mode