Concatenating in an Array formula

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

FAQ

Thread Tools

Display Modes

02-25-2019, 05:46 AM

xor

Windows 10 Concatenating in an Array formula

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

Yes you are right about array formula.

="After-Tax Balance " & TEXT(INDEX($AH$5:$AH$200,MAX(IF($AH$5:$AH$200="",F ALSE,ROW($AH$5 :$AH$200)))), "$#,##0")&" (24%)"

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 01:25 PM.