The formula is generally the amount rejected/the amount shipped*1000000, with
an if then statement preceding that says IF(amount shipped=0,0. My data is
organized in columns with headers of the months april to december with the
amount shipped and rejected for each company under each month. So in total
theres nine months, but i need to build the formula to function even if more
months are added. I know its hard to explain, but im not very familiar with
this forum and i dont know how to post an attchment of the file for you to
take a look at.

"Bill Kuunders" wrote:

you'll need to send more data

or send me a copy of the file direct
--
Greetings from New Zealand

"Rachel" wrote in message
...
I need to generate a 6 month rolling PPM formula and I have no idea where
to
start. It needs to automatically select the last six months of data and
calculate it into PPM accurately. any help would be greatly appreciated.