| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
database sorting
how do i sort my database so it only shows duplicate last names.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Excel Database via Access Main Database with a script | New Users to Excel | |||
| Database sorting | Excel Discussion (Misc queries) | |||
| Two problems sorting a database containing pictures | Excel Discussion (Misc queries) | |||
| Two problems sorting a database containing pictures | Excel Discussion (Misc queries) | |||
| Excel as a database and sorting information | Excel Discussion (Misc queries) | |||
Linear Mode
