Thread: [Solved] Concatenating in an Array formula
View Single Post
 
Old 02-21-2019, 09:08 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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).
Reply With Quote