| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sort a worksheet data to show repetitve data and show
can anyone tell me how to sort data to show repetitve data and highlight it
in the array? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i sort a worksheet data to show repetitve data and show
Using conditional formatting CF.
Select A1 format conditional formatting, dropdown to "formula is"and write : =COUNTIF(A:A,A1)1 FORMAT and CHOOSE color ok. Copy-paste specialformat in all cells you'd like this condition to apply. Remember, as you did not give me range I used A column, but adjust as needed. -- Can''''t hear the Rain ? Then listen to it. "mrcheatherington" wrote: can anyone tell me how to sort data to show repetitve data and highlight it in the array? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show or hide outlined data option in a protected worksheet? | Excel Discussion (Misc queries) | |||
| show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
| Last data entry made time and Date show in each worksheet | Excel Worksheet Functions | |||
| Sort & Show Data | Excel Worksheet Functions | |||
| How can I show data under a Chart that I inserted in a worksheet? | Charts and Charting in Excel | |||
Linear Mode
