Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
I have a data in below mentioned format.
I just want to to display on first row of each group.
First row of each group should be the row having least Mfg_Date of the group.
Grouping is based on Product ID.
Kindly suggest.
Product ID | Name | Batch # | Mfg Date | Qty |
1 | ABC | 123 | 1-Jan-14 | 232 |
1 | ABC | 456 | 10-Jan-14 | 433 |
1 | ABC | 234 | 15-Jan-14 | 54 |
2 | XYZ | 34 | 2-Jan-14 | 76 |
2 | XYZ | 432 | 5-Jan-14 | 54 |
2 | XYZ | 4354 | 31-Jan-14 | 545 |
2 | XYZ | 4534 | 1-Feb-14 | 544 |
3 | QWE | 4234 | 10-Jan-14 | 454 |
3 | QWE | 6456 | 25-Jan-14 | 657 |
4 | ASD | 867 | 11-Jan-14 | 54 |
4 | ASD | 54 | 12-Jan-14 | 5453 |
4 | ASD | 534 | 25-Jan-14 | 342 |
4 | ASD | 654 | 29-Jan-14 | 323 |
4 | ASD | 6456 | 2-Feb-14 | 342 |
5 | ZXC | 5345 | 5-Jan-14 | 534 |
5 | ZXC | 4234 | 10-Jan-14 | 4534 |
5 | ZXC | 432 | 15-Jan-14 | 534 |
5 | ZXC | 5454 | 16-Jan-14 | 2342 |
5 | ZXC | 6565 | 25-Jan-14 | 56 |
5 | ZXC | 87686 | 2-Feb-14 | 676 |
Thanks & Regards
Aqeel Nawaz
Try using rank function and restrict the data using if condition.
PFA of the file
Thanks
Thanks
But I also need Batch # of the first row.