Help required

vinod22kv — Sat, 16 Nov 2024 06:43:57 GMT

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.

topic Help required in App Development

Help required