Thread: [Solved] Fill Down from 2 Rows
View Single Post
 
Old 05-29-2015, 02:38 PM
jarhtmd jarhtmd is offline Windows 7 64bit Office 2007
Novice
 
Join Date: May 2015
Posts: 8
jarhtmd is on a distinguished road
Default 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?
Reply With Quote