Selective increase of numbers when pasting

  • Thread starter Thread starter ayl322
  • Start date Start date
A

ayl322

Hi,
if i have a formula with multiple cell numbers (ex: IF(A1=B1, A1) ) an
i try to copy this formula to multiple cells by dragging from that cel
down, it automatically adds +1 to each number.
so the next ones would read IF(A2=B2, A2), IF (A3=B3, A3), and so on.

How do i make it so only some of the numbers are increased? if i wan
each A cell to compare to B1, i don't want B1 increased, but i want th
A cells increased.

my actual formula is a lot longer, i just picked a simple formula as a
example, but same idea.

Thanks
 
Take a look at "The difference between absolute and relative references"
in XL Help:


=IF(A1=B$1, A1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get cell coordinates? 3
Very strange behaviour of VLOOKUP in Excel 2010 4
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
find oldest date with a condition 4
Data Validation and drop-down list using IF, AND and what else? 8
Countif function giving incorrect answer 5
Copy Data from One sheet to Different Sheets 1
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3

Back
Top