Clean Up

[Mashtonsmith1]

Hello,

I need to clean up some invoice data where the following scenario is seen.

A1 NSP/19/11/239

A2 NSP/19/11/239.1 In this example the cell ending 239 has been superceded by the 239.1 entry. I need to find these cases and remove the 239 type rows - but ONLY when there is a .1 following the original invoice number. I can easily find .1 cases =RIGHT(A1,2) but that doesnt help me. The formulae with need to consider both cells. Invoice names and lengths differ but will always show a .1 if the original was amended. Many thanks

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[Mashtonsmith1]

I cant do either sorry.
I'm obviously not explaining myself properly.
My sheet has many thousands of rows.
In column A are invoice numbers. All are unique.
Some however are as per the example above where a change was made to the invoice so a small change is made to teh invoice name (=###.1).
Where this is the case I need to KEEP the instances where there is a ###.1 and loose the original invoices.
Hope this helps?

 

[mumps]

Can you post a sample with a little more data, may a dozen or so rows?