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.

If your asking if the displayof the formula result can be made to not appear, then wrap an =ISBLANK() function around your formulas, something like:=IF(ISBLANK(A1),"",myequations)

MIKE

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History