E
Ed Pfister
I have a spreadsheet that has been using the various database functions to perform calculations on data retrieved from a query. The database functions are used as the user can exclude data using the criterias used in these functions. Now a user has a need to take the absolute value of all the data going into some of these functions. I have tried to find a way to do this but have had no luck. The simpilest of these is the DAverage function so that is why I mentioned that in the title.
How would I go about taking the absolute value of all data in the range going into the daverage function? Current formula looks something like:
=DAVERAGE(NamedRange, COLUMN(AE$65535), BE$1:BF$2)
Can someone tell me how I would accomplish this? Thanks.
How would I go about taking the absolute value of all data in the range going into the daverage function? Current formula looks something like:
=DAVERAGE(NamedRange, COLUMN(AE$65535), BE$1:BF$2)
Can someone tell me how I would accomplish this? Thanks.