Off Belay forum


View latest messages in My Forums
This topic has been archived, and won't accept reply postings.

Topic - Excel Question - how to ignore blank cells - help!

Phil79 - on 07 Feb 2013
Ok, one for the Excel users on here, I'm an occasional user so hopefully I'll explain this ok.

I'm using the TREND function to find specific x values from a simple x y data set. So, for example I have two rows of data with potentially up to 20 entries (say A1:B20), but in some cases I might have only 10 entries in each row (say A1:B10) - is there an easy way to get excel to ignore the remaining empty cells (without having to change the array reference every time)?

At the moment it gives me a #VALUE! error, presumbly because some of the cells are empty and the formula wants a number rather than a blank.

The formula is =TREND(A1:A20,B1:B20,x)
... not showing 6 replies to this topic ...
Register as a New User or login to gain full access to the forums. Registration is quick and completely free.
If you are definitely logged on, press Ctrl+F5 keys to reload this page [read more]

Unregistered users can only read messages in the most recent topics.

This topic has been archived, and won't accept reply postings.

My Forums