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, 11:37 AM

jpreeshl

Windows 10 combine 2 columns into 1 without knowing the size

Office 2007

Novice

Join Date: Jan 2016

Posts: 8

My current formula already returns a blank in the row if a names doesn't show up.
Column A formulas {=IFERROR(INDEX(names, SMALL(IF("Y"=Alphabetical!$I$2:$I$185, ROW($E$3:$E$186)-MIN(ROW($E$3:$E$186))+1, ""), ROW(A31))),"")}

Column B formulas {=IFERROR(INDEX(names, SMALL(IF("YC"=Alphabetical!$I$2:$I$185, ROW($E$3:$E$186)-MIN(ROW($E$3:$E$186))+1, ""), ROW(E7))),"")}

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