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?

What are you trying to do, specifically? Can you attach a spreadsheet with some data and the expected result you are looking for.

Thanks, Mandy, for your reply.
I have 1,000's of digital images scattered in different locations on my computer.Many are duplicates.Most have unique names but because of editing some have different file sizes.Usually my filename "prefix" changed after editing, but not always.Most are grouped in similar folders with similar names.My ultimate goal is to eliminate the duplicates and store in yearly folders & subfolders.
Roughly, I plan to copy 2 "similar" folders into a work folder, with the matching filenames getting a (2) suffix.Then use DOS (yes, DOS) command DIR |clip & paste into a text file, which will then be imported into Excel.
I want to compare file sizes and filename "prefixes".I'll do that by comparing fields in Row (n-1) & Row (n).For conflicts, I will look at the images to make a final decision.Actually, while typing this it dawned on me I probably should use Row (n) & Row (n+1).Row (1), not having (n-1) presented a problem.
Anyway, in the attached sheet, I inserted a "dummy" Row2 (after headers).I was able to use the same formula for each row.I couldn't however do it all in a single cell for a given row.Therefore, I use 3 columns.Cols D & E will be hidden and "ok" is shown only for testing.
I still had the problem of filling the entire column with the formulae.See solution at http://answers.microsoft.com/en-us/o...5-e57a921c1985

It looks like my original problem disappeared.It would still be cleaner if formulae in Cols D,E.F were combined.

Attached Files

Compare PAIRS (SIZE & PREFIX#).xlsx (12.1 KB, 11 views)