Concatenating in an Array formula

		Microsoft Office Forums > Microsoft Excel > Excel
Concatenating in an Array formula

FAQ

Thread Tools

Display Modes

02-21-2019, 09:08 AM

xor

Windows 10 Concatenating in an Array formula

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:24 AM.