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

Mark Forums Read

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 »

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

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 08:42 PM.