Microsoft Office Forums - View Single Post - Complex calculation from multiple sheets to master sheet

Thread: Complex calculation from multiple sheets to master sheet

View Single Post

Old

01-05-2016, 01:19 PM

inreality01 inreality01 is offline

inreality01 is offline

inreality01 uses Windows 7 64bit

Windows 7 64bit inreality01 uses Office 2013

inreality01 uses Office 2013

Office 2013

Advanced Beginner

The original poster

Join Date: Dec 2015

Posts: 34

inreality01 is on a distinguished road

Default

I may have found an answer to combining 2 columns. Looks like I need to tweak the following because I have column headers so I need to get this command to start at row 2. It almost works as is.

=IF(ROW()<=COUNTA(A:A), INDEX(A:A,ROW()), IF(ROW()>COUNTA(A:B), "", INDEX(B:B,ROW()-COUNTA(A:A))))

Reply With Quote