Click to view latest messages in all forums
| | | | This topic has been archived, and won't accept reply postings. |
 Topic - Excel Question - how to ignore blank cells - help!
|
|---|
 by - 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. |
[top of page] - [forums latest]
|
