Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data like this
sCustomerId | bin | Total Weight | Date |
100004 | BLACK | 0 | 16/01/2019 |
100004 | BLACK | 1 | 16/01/2019 |
100004 | GREEN | 0 | 16/01/2019 |
100020 | BLACK | 14.5 | 14/01/2019 |
100020 | BLACK | 0 | 14/01/2019 |
100030 | GREEN | 6.5 | 21/01/2019 |
100038 | BLACK | 31.5 | 15/01/2019 |
100038 | GREEN | 9.5 | 22/01/2019 |
100040 | BLACK | 0 | 16/01/2019 |
100040 | GREEN | 21.5 | 23/01/2019 |
100050 | BLACK | 37.5 | 18/01/2019 |
100050 | GREEN | 18 | 25/01/2019 |
100051 | GREEN | 8.5 | 24/01/2019 |
100052 | BLACK | 37 | 15/01/2019 |
I need the formula to filter.
Requrement is for each day if the customerid's each bin is 0 i need that record if not i have to delete that record.if it dont havce other then zero i have to save that record in to excel. can any one hepl in this.
Example: for custid 100004 bin is black and weaight is 0 for the day 16 for first record and second record i have same date and same bin and some weaight so i have to delete that 2 records.
other example:100004 has green bin in the same day with 0 weight and there is no othere record for that same day and same bin.so i have to save that record.
for each day each bin each customer id with 0 weights
expected out put:
sCustomerId | bin | Total Weight | Date |
100004 | GREEN | 0 | 16/01/2019 |
Can you please help me out.
Thanks and regards,
Vinod.