THe solution I suggested did not consider the fact that you have outlined
the data, and it will work well if the data is in the format that the
original post contains, however, it will be helpful to me if you can send
across the file, so I can work on it.
regards,
Ajit
On Tue, Sep 23, 2008 at 6:
Hello Ajith,
Thanks for your help, But i didnt understand your solution. Let me put
my question in a detailed way.
My data looks like this.
Supplier Product Class Part No.
Rejection value
A Ltd Summary
A Ltd 123
A2525 25
A Ltd
There is surely a way to achieve that. Why do it unnecessarily? Let's follow
a simple approach. Arrange the list incorporating an additional column,
"Supplier", so the data looks like -
Supplier A Product A Class 1
Supplier A Product B Class 1
Supplier B Product C Cl
