Filter the specific data and find the difference

[sindhuja]

Hi All,

Here is my requirement..

Actually i copy the raw data(.txt file) and paste in a sheet named sample.xls. then i align the date using text to columns and delete the non numeric rows. i have many rows of data, out of which i have to check only for the "vap" and "sap" in the column Vcode. I have filtered the vap and sap using the custom filter.

After filtering the required date i have to check for each value in the Bcode column. if i have 10 values i have to check all the 10 values.

For each Bcode there should be either vap or sap. There should not be both vap and sap for a single Bcode. If i find both of them for a particular Bcode then make a note of Bcode, Fcode, Ccode and the total of Acode in the sheet "Difference". Also select only value starting with vap in vcode find the total and make a note in difference sheet.

This is my query and i should note the values only when there is both vap and sap for a particular Bcode...

Hope i made it clear... Any help on this will be highly appreciated.

Also attached the sample sheet with the workings....

Bcode value say 557 is stated an example entry in attached file.

-Sindhuja

[sindhuja]

Any help on this please...?

[sindhuja]

can anyone help me out in this please...

[sindhuja]

Am really struck with my requirement...
Is there anyone to help me...

-Sindhuja

[mdmackillop]

Because you have 16,000 rows with the same date, it makes a solution to the sample problematical. However, filtering for unique Bcodes and applying sumproduct identifies the potential duplicates, which you can then process further

[sindhuja]

Am not sure how to proceed further..
Any guidance to my requirement...?

-Sindhuja

[mdmackillop]

Make your sample provide a more realistic output. What is the point in filtering 16k dates which are all the same?

[sindhuja]

Hi,

I have attached my sample with few datas..
Hope this will be helpful now..

-Sindhuja

[sindhuja]

Here is the sample attachment...