Concatenating in an Array formula

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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:23 PM.