Figuring out a pattern
Hopefully i can describe this situation and it make since. I have a list of several items in column A. in columns B,C,D,E....... are previous months total invoice amounts. If that item was not ordered in one of the given months the cell is blank. what i am looking to do is to write a formula to look across the line and find a pattern. it would tell me that the item gets ordered every 3 months or every month or whatever the situation is. how would i go about this? Any help is much appreciated.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1