Sum Product not good enough
I have a spread sheet that calculates the Number of times an order is raised
by Supplier, the qyt's returned are quantity of orders raised with the last 12 months, within last 6 months and within last 3 months. The data is taken from a seperate work sheet that tracks the Supplier name (Column A) and Date of order (Column E) amongst other detail not relevent to this formula. I am using sum product but have exceeded 1000 orders therfore the formula has stopped working. How else can i do this. Sum Product seem to run very slow anyway |
Sum Product not good enough
What do you mean has stopped working? It is slow, gives a wrong result,
throws an error. Show us the formula. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "uklout" <uklout @discussions.microsoft.com wrote in message ... I have a spread sheet that calculates the Number of times an order is raised by Supplier, the qyt's returned are quantity of orders raised with the last 12 months, within last 6 months and within last 3 months. The data is taken from a seperate work sheet that tracks the Supplier name (Column A) and Date of order (Column E) amongst other detail not relevent to this formula. I am using sum product but have exceeded 1000 orders therfore the formula has stopped working. How else can i do this. Sum Product seem to run very slow anyway |
All times are GMT +1. The time now is 04:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com