combine 2 columns into 1 without knowing the size

		Microsoft Office Forums > Microsoft Excel > Excel
combine 2 columns into 1 without knowing the size

FAQ

Thread Tools

Display Modes

05-09-2017, 12:14 PM

NBVC

Windows 7 64bit combine 2 columns into 1 without knowing the size

Office 2007

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Try array formula:

=IFERROR(INDEX(Names!$K$2:$K$185, SMALL(IF(("Y"=Names!$I$2:$I$185)+("YS"=Names!$I$2: $I$185), ROW($E$3:$E$186)-MIN(ROW($E$3:$E$186))+1, ""), ROW(A1))),"")

You'll have to replace the Names! references to your actual data references.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
The best practice to print 20,000 rows of 6-columns each in pdf landscape A3 page size while to repe	Majdoleen	Excel	0	04-25-2017 01:02 PM
Font size showing different (some superscripted??) but tools show its the same size?	mikkygee	PowerPoint	4	12-14-2015 11:21 PM
An array of words from a document knowing the font style	Kreol2013	Word VBA	0	07-08-2013 01:29 AM
how change size font to inches size	kkepo	Word	4	08-28-2012 08:53 PM
Cursor size varies with font size	r_lewis@fuse.net	Word	0	07-20-2011 06:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:37 PM.