ExcelBanter - database sorting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - database sorting (https://www.excelbanter.com/excel-discussion-misc-queries/217754-database-sorting.html)

rdny2

database sorting

how do i sort my database so it only shows duplicate last names.

Sandy

database sorting

Try a helper column
Assuming Surnames in C2:C1000 enter the following in the next blank column
=COUNTIF($C$2:$C$1000,C2) and copy down
AutoFilter this column on 1.
Sandy

"rdny2" wrote in message
...
how do i sort my database so it only shows duplicate last names.

Fred Smith[_4_]

database sorting

Read the answers in your previous post.

Regards,
Fred.

"rdny2" wrote in message
...
how do i sort my database so it only shows duplicate last names.

All times are GMT +1. The time now is 04:48 AM.