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.