Search results

Hi, sorry for this late response, as I have been away. If you could refer to this link below: (https://docs.google.com/spreadsheet/ccc?key=0AlWgMhjadVZ4dFJYSWVCTDAwMEJHSzJLT0tWWEM2Vnc&usp=sharing) Then you'll know what I mean. The results doesnt look like its in days/weeks. Kindly advise...

Thanks Narayan, The above formula looks 'logically right', but somehow did not elicit the right results. And when drag it down the column, the results got even more bizarre. Any idea if we could rectify the formula ?

Hi Narayank991, thanks, but the results don't look right (with negatives). Just wondering why is there a '9999999' within the formula?

Here you go: https://docs.google.com/file/d/0B1WgMhjadVZ4WWVmQ2lXZjZDWlU/edit?usp=sharing

Where can I upload the file? Do I have to park it outside like Dropbox, etc?

Thanks, but you know how to write the full formula - taking into the consideration the unique IDs?

Hi,I have a database with 100,000(+) unique customer ID tied to their invoice dates (of purchasing)over a period of 3 years. I would like to understand the buying pattern of each customer by calculating the average time between their purchases (determined by their invoice dates. Sample as below...