Sumaira Aslam
New Member
Hi,
I am preparing a sheet for Procurement Department. Here, I have data including Product Codes, Dates and Week Nos. along with Product Rates. So, earlier I was using SUMIFS Formula for making a Rate Table on weekly basis by leaving codes empty where I found repetition. Now I need that whole data for some other purpose too on the same sheet. So, I can't leave Codes Column empty.
Therefore, I need a formula that chooses Minimum Value upon repetition and ignore the rest but somehow extract weekly data.
The reason I cannot use If function because the data is too much and I cannot put 100 of conditions in one formula while we keep adding more data.
SUMIFS along with MIN function will be best. But if someone can tell me any other function that works best in this situation will be highly appreciated.
A Sample File is attached for reference.
Thanks....
I am preparing a sheet for Procurement Department. Here, I have data including Product Codes, Dates and Week Nos. along with Product Rates. So, earlier I was using SUMIFS Formula for making a Rate Table on weekly basis by leaving codes empty where I found repetition. Now I need that whole data for some other purpose too on the same sheet. So, I can't leave Codes Column empty.
Therefore, I need a formula that chooses Minimum Value upon repetition and ignore the rest but somehow extract weekly data.
The reason I cannot use If function because the data is too much and I cannot put 100 of conditions in one formula while we keep adding more data.
SUMIFS along with MIN function will be best. But if someone can tell me any other function that works best in this situation will be highly appreciated.
A Sample File is attached for reference.
Thanks....
Attachments
Last edited: