Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Copying equations in excel?
Hi, i am trying to compare data in column A, basically to compare if a cell is equal to the value right below it (cells A1 to A10 are filled with values). So my equations starting at cell A15 is =A1=A2, A16 is =A3=A4, A17 is =A5=6, etc but if i were to fill/or drag it down, cell A18 isn't =A7=A8. Is there anyway to do this without VBA?
3 Answers
- ?Lv 79 years agoFavorite Answer
Just need to modify your formula a bit. The INDIRECT formula lets you turn text string formulas into cell references. The ROW() function returns the row number of the current cell.
=INDIRECT("A" & ((ROW() - 14) * 2 -1)) = INDIRECT("A" & ((ROW() - 14) * 2))
You could also have just made A15 = A1=A2, kept A16 blank, selected A15:A16, and drag the fill handle to get the needed formulas in every other row.
- JEFFREYLv 49 years ago
There is no possibility without macro, but you can give a try with this work around
As you mention type the first formula in A15.
Drag and drop cell a15 till a 23.
select cell a16, a18, a20 and a22 (hold ctrl bottun and click each of this cell mentioned)
Right click the selected cell and select delete
choose delete up when prompt
- Anonymous9 years ago
Right-click on A15, select copy, highlight cell A16 to A24, right-click the highlighted block and select paste. the formula will auto-adjust.
Source(s): Just tried it in OpenOffice.
