How to delete rows depending on cell content

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

Please don't upload pictures they are rarely much use and not many of us are prepared to recreate your workbook from a picture.

In general though use a helper column to count the number of values, and filter the list for values > 1 in the helper column.

A regular formula will not delete rows for you, but a formula/function will be able to show you which rows to delete (manually)

	E	F
2	1	FALSE
3	2	FALSE
4	3	FALSE
5	1	TRUE
6	2	TRUE
7	3	TRUE
8	1	TRUE
9	2	TRUE
10	3	TRUE

F2=COUNTIF($E$2:E2,E2)>1 copied down.

then apply filters, unckeck FALSE and delete what remains - then remove filters