Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting question
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting question
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting question
Hi,
If you are using 2007 and you've applied condtional formatting then you can sort by color. Highlight the column with the conditional formatting and choose Home, Sort & Filter, Custom Sort. From the Sort On drop down pick Cell Color, from the Order color choose the color of your conditional formatting, from the next drop down choose On Top or On Bottom. - This will result in all the conditionally formatted items being at the bottom or top but in no particular order. So one of the nice new features in 2007 is you can apply multiple sorts to the same column! Click Add Level and in the Sort On column leave Values, for the Order drop down leave Smallest to Largest or whatever is appropriate. - now all the duplicates will be at the top by color and within there color sorted low to high. -- If this helps, please click the Yes button Cheers, Shane Devenshire " wrote: 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 |
#4
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 |
Reply |
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) |