I've come across a strange situation where I've to delete a record if there is any other record having the matching key variables. Any help would be highly appreciated. My requirement is to drop both these records from further processing. My sample data looks like below where the fields Vendor, Job and Grade are the key variables.     Vendor Job Grade Payment 1 ABC Boxes 01 $3,500.00 2 XYZ Tape 01 $2,000.00 3 LMN Straps 02 $1,500.00 4 ABC Pins 02 $1,200.00 5 LMN Straps 02 $0.00 6 ABC Boxes 01 $3,500.00 7 LMN Straps 02 $0.00 8 ABC Boxes 01 $0.00     A record has to be dropped from further processing if there is another record anywhere in the table having the amount field(Payment) a value $0.   Considering this the record #1 for vendor ABC having Payment $3500 should be deleted because there is another record #8 where Payment is $0, but #6 having Payment $3500 should be processed because #8 is no more available as it is already matched(/deleted along) with #1. Similarly #5 for vendor LMN should also be dropped as there is a matching record at #7 having payment $0.   ... View more

Hi All, Sorry that I always trouble myself in interacting with Excel and come to back to you guys. Here I've another issue and dont know if it is possible to resolve. I've a regular report sharing to various clients which has got about few numeric variables(values with amounts, so needed to be numeric) and for some reasons I had to generate this as XML file rather than Excel(because excel cant serve my pupose to load data into multible tabs with needed formats like WRAP the grouped observations). So here I've a certain requirement where we got to block with showing up of amounts for specific observations(records) and thereby my clients are requesting me to put a text like 'BLOCKED' on such numeric fields:smileyshocked:. I never knew that we programmers do need to think to this extent while developing technologies . ...might be we need to think about another new datatype.. Opportunity!!  I doubt if it is really possible but anyways if someone has some ideas pls do share to help me. Also, it will be greatly appreciated if you suggest me the best way to convert XML files back into Excel files without disturbing the formats like Word WRAP, MERGE, etc.. ... View more