Automatically populate rows in Excel

Excel Excel 2007 home and student
April 24, 2011 at 02:57:21
Specs: Windows Vista
I am using Excel to analyse a large number of datasets. Each dataset can have anywhere between 100 and 10000 entries each of which has between 5 and 20 different data fields. I perform the same analsyis on the data by inserting it into the worksheet with each data field in a standard column. I then copy a standard set of processing equations down for each row that has raw data entered. The processing can include equations in as many as 100 columns to the right of the raw data, each of which has a standard equation in it.

As an example, imagine I have inserted 26 different values in columns A:Z for 100 different cars in rows 1:100. I then have standard equations to process that data in columns AA:DZ. My question is, can you automatically copy those equations down so that they only appear in the rows where data has been entered in e.g. column A? And of course, if you can, how?

Thanks in advance.

See More: Automatically populate rows in Excel

Report •

April 24, 2011 at 10:06:03
If your asking if the display of the formula result can be made to not appear, then wrap an =ISBLANK() function around your formulas, something like:



Report •
Related Solutions

Ask Question