Deleting multiple rows through a formula?

[Guest]

So does anyone know a formula that will allow me to delete multiple rows of
re-occuring data in a spreadsheet.
For example, I have a spreadsheet of 10,000 lines, with multiple mobile
numbers on it. I need to only have one of each mobile number and delete the
remaining rows where the mobile has been repeated?

 

[onedaywhen]

does anyone know a formula that will allow me to delete multiple rows of
re-occuring data in a spreadsheet.

Do you need to *delete* the rows? Could you instead use a suitable
query to eliminate the duplicates (SELECT DISTINCT, possibly)?

If you are referring to an Excel workbook, Jet's DELETE SQL DML is not
supported, although you could workaround this by using
SELECT..INTO..FROM to create a new Excel table with the desired results
and optionally DROP TABLE on the original.

It may be easier to open the spreadsheet in its native app and delete
the rows from there e.g. Excel has an AutoFilter which makes this kind
procedure very easy.

Jamie.

--