Fill Down from 2 Rows

		Microsoft Office Forums > Microsoft Excel > Excel
Fill Down from 2 Rows

FAQ

Thread Tools

Display Modes

05-29-2015, 02:38 PM

jarhtmd

Windows 7 64bit Fill Down from 2 Rows

Office 2007

Novice

Join Date: May 2015

Posts: 8

Fill Down from 2 Rows

I want to compare A1 & B1 to A2 & B2.
I want to compare A3 & B3 to A4 & B4.
I want to compare A5 & B5 to A6 & B6, etc, etc, etc.

In other words, I want to compare all even # rows to the above row.

D1 is empty
D2 contains a formula

How do I copy D1 & D2 and fill down? Or is there a way to have a formula in rows 2 thru n?

Tags

fill

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete blank rows between the two rows that contain data	beginner	Excel Programming	5	12-26-2014 12:29 AM
Delete All empty Rows - Print - Undo all Rows deleted	Bathroth	Word VBA	1	10-01-2014 01:40 PM
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM
Nested if field that contains a fill-in field is not prompting for fill-in info	Nccadm	Mail Merge	2	04-02-2013 03:15 AM
merging rows and creating sub-rows	gib65	Excel	2	12-09-2011 02:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:42 AM.