sindhuja
08-21-2008, 04:45 PM
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
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