| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting question
Nice !!!!!!!!
"Bernie Deitrick" wrote: Use another column, filled with a formula like this: =COUNTIF(A:A,A2) then sort you whole sheet based on that column, descending to get the dupes at the top, ascending to get the dupes at the bottom. HTH, Bernie MS Excel MVP " wrote in message ... I have column with that I am using cond form to check for dups. Is there a way to sort the column asceding or descending were the non-dups will to the top or bottom of the col not very familiar with the adv auto filter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Question | Excel Discussion (Misc queries) | |||
| Re my question on sorting | Excel Worksheet Functions | |||
| Sorting Question | Excel Worksheet Functions | |||
| Sorting question | New Users to Excel | |||
| sorting question | Excel Discussion (Misc queries) | |||
Threaded Mode
