Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text match
i've exported a check register from business works software to excel. when i open the excel spreadsheet ....if a check was for more than one invoice.... it lists that check multiple times. how do i quickly get all the duplicate check #'s off the list? thanks for your help! pam
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
text match
One way, Pam, is to use DataFilterAdvanced Filter. For list range, type
in the entire range you want to show (as in $A$1:$F$25), or highlight it all using your mouse. For criteria range, type in the range of your check numbers, or highlight the range with your mouse. Make sure you have the same number of rows (in my example here, if the list range ends at F25, the criteria range needs to end at A25), and be sure to include the headers. Check the boxes for Unique Records Only, and Copy to Another Location. In Copy To:, type or select the top left cell of the empty space you want to paste your data into (it must be on the active sheet). HTH Ed "pam" wrote in message ... i've exported a check register from business works software to excel. when i open the excel spreadsheet ....if a check was for more than one invoice.... it lists that check multiple times. how do i quickly get all the duplicate check #'s off the list? thanks for your help! pam |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
text match
Pam
If you want to extract uniques to another workseet, see instructions at Debra Dalgleish's site. http://www.contextures.on.ca/xladvfi...html#ExtractWs Gord Dibben Excel MVP On Thu, 12 Feb 2004 12:57:22 -0700, "Ed" wrote: One way, Pam, is to use DataFilterAdvanced Filter. For list range, type in the entire range you want to show (as in $A$1:$F$25), or highlight it all using your mouse. For criteria range, type in the range of your check numbers, or highlight the range with your mouse. Make sure you have the same number of rows (in my example here, if the list range ends at F25, the criteria range needs to end at A25), and be sure to include the headers. Check the boxes for Unique Records Only, and Copy to Another Location. In Copy To:, type or select the top left cell of the empty space you want to paste your data into (it must be on the active sheet). HTH Ed "pam" wrote in message ... i've exported a check register from business works software to excel. when i open the excel spreadsheet ....if a check was for more than one invoice.... it lists that check multiple times. how do i quickly get all the duplicate check #'s off the list? thanks for your help! pam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match a text | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
How to match two different cells text, if the text is not in the . | Excel Worksheet Functions | |||
match cell text with text in formula | Excel Worksheet Functions | |||
text match? | Excel Programming |