Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
wildcard
Two of my worksheets (there are 10 total worksheets)in my workbook titled
"All Records" are titled "Confirm No Match" and the other titled "Payments No Match". Each of these tables have columns titlted, "Name" and "Amount". I would like to copy any duplicate records in the two worksheets with the same "Amount" field and "Name" fields and copy them two a worksheet titled "Name Wildcard". Because many of the names are misspelled, I was wondering how I could use a single wildcard character. For example if the name was in the Confirm No Match as "Ouimay" and in the Payment No Match as "Ouimey" and both dollar amounts were $100.00, the row would be copied to the Name Wildcard worksheet. I looked at the other posts and in help and it seem that one has to specify the location of the wildcard, I just want it to be any character or even better if we could specify to match the name with 2 wildcards for more hits, is that even possible. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to CF using a wildcard | Excel Discussion (Misc queries) | |||
Using the wildcard with IF | New Users to Excel | |||
If and wildcard | Excel Discussion (Misc queries) | |||
Wildcard | Excel Programming | |||
Wildcard | Excel Programming |