Hey,
I am trying to write a standard deviation formula that would exclude zeros when a string of 5 consecutive zeros occurs. For example, a customer who orders 500 every 6 weeks over the course of a year should have a STD of 0. Not getting that. I looking at order history and trying to incorporate all customers who order weekly, monthly, and quarterly in one formula.
Does anyone have any ideas? Would prefer not to use any macros.
Thanks.
With no idea how your information is laid out, it's kinda hard to take a stab at that. Would you be able to load a sample of your worksheet?
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Sorry about the delay. I having some issues with my account.
I attached a data sample. The zeros in red are the ones I would like to exclude from the formula. I was messing around with a match formula but didn't amount to any type of significance as of yet.
I have considered removing the zeros, but that would require numerous updates across a lot of data and would only help me out with a small percentage of the problem. I'm hoping there is a better way.
Again, any ideas or suggestions are appreciated.
Last edited by Grock258; 02-26-2009 at 09:29 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks