Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can MS EXCEL remove duplicates and separate by color coded items ?
Can MS EXCEL remove duplicates and separate by color coded items ?
I am NOT technical and have just started using MS EXCEL. Can anyone PLEASE HELP me: 1. How can I automatically remove duplicates using EXCEL ? ie the same info input more than once on different lines. Can EXCEL do this ? 2, I have color coded the text in the certain lines in terms of priority. can Excel rearrange the data by color ? If yes, How do I do it ? I think I have EXCEL '97 Thanks for your help in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can MS EXCEL remove duplicates and separate by color coded items ?
I would use autofilter to remove the duplicates.
First add a helper column to identify the duplicates. Let's assume that the data is in A1:A100. In B1, add the following formula =COUNTIF(A1:A$100,A1) Type this exactly as shown, with the $ as I have provided. Then copy down all appropriate rows. Next, goto DataAutofilter and choose Custom, and select Greater than with a value of 1 and OK. This will then only show those duplicate rows. Select them and delete them, the hidden rows will be okay, and will be visible when you turn Autofilter off. As for sorting, this again is done by creating a helper column to get the ColorIndex and sort on that column. It needs VBA, and is described on Chip Pearson's site at http://cpearson.com/excel/sortbycolor.htm -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "nilu kazi" wrote in message om... Can MS EXCEL remove duplicates and separate by color coded items ? I am NOT technical and have just started using MS EXCEL. Can anyone PLEASE HELP me: 1. How can I automatically remove duplicates using EXCEL ? ie the same info input more than once on different lines. Can EXCEL do this ? 2, I have color coded the text in the certain lines in terms of priority. can Excel rearrange the data by color ? If yes, How do I do it ? I think I have EXCEL '97 Thanks for your help in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Duplicates; How can I get a list of items removed? | Excel Discussion (Misc queries) | |||
color coded cells and conditional format in excel 2003 | Setting up and Configuration of Excel | |||
Excel 2003-color coded reference cells has stoppped on a spreadsh | Excel Worksheet Functions | |||
Software to create color coded maps from excel? | Excel Worksheet Functions | |||
Can you sort excel data by color coded cells? | Excel Discussion (Misc queries) |