Repeated formula

  • Thread starter Thread starter JA
  • Start date Start date
J

JA

Hi, I am so inexperienced with Excel that I don't even know what words to
use to describe this!

I want to import 2 columns of numbers into excel, and have the next 2
columns have formulas in them that are based on the numbers in the first 2
columns.

The amount of numbers imported varies each day.

My question is - how do I make the formulas be there, no matter how many or
few numbers are imported? I know how to grab the corner of the formula cell
and drag it all the way down, but I would like to not have to do that each
time.

Thanks! I hope this makes sense!

J~
 
You copy the formulas to a number of rows that you know for certain will
cover the number of rows of data you import.

If you know for certain that the number of rows imported can vary from say,
10 to 100, and will never be more than 100, then you copy the formula to 100
rows.

If you don't want the formulas to calculate any empty rows then you write
the formula to check to see if there is in fact data in the cells being
calculated.

...........A
1........5
2........3
3........7
4..........
5..........

=IF(A1="","",your_formula_here)

That "says" if cell A1 is blank or empty leave this formula cell blank,
otherwise process your formula.
 
OK, I just found in the help files that I can double-click the fill corner
of the first cell, and the formula will copy all the way down the column.
But, is there a way to do this automatically when the numbers are imported?

I will have to have 5 different sheets since there will be 5 different
formula combinations, and do them everyday.
 
Back
Top