Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing slightly differing columns
mHi,
I need to compare two columns of account numbers that come from diferent sources. One column has the account number correctly displayed, the other has extra zeros added in front of the origial account number - some numbers have one zero , some two and some numbers in this column are correct. This means that I cannot just remove the first couple of numbers without the risk of damaging the correct numbers. I would like to be able to compare perhaps the last three or four positions of both columns and/or be able to crop off zeros at the beginning of the numbers. How do I do this? -- Kind regards, Rochelle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slightly OT (Maybe) printing problem | Excel Worksheet Functions | |||
Printout slightly smaller than preview | Excel Discussion (Misc queries) | |||
comparing two columns | Excel Discussion (Misc queries) | |||
Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
excel charting formulas - sum of 2 columns with differing data | Charts and Charting in Excel |