| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find closest match and copy
Sheet2 has more than half a million of rows. (Excel 2007)
Ok, with that many rows you need a programmed solution. It could be done with formulas but would take forever to calculate. Maybe repost in the Programming group. -- Biff Microsoft Excel MVP "saman110 via OfficeKB.com" <u35670@uwe wrote in message news:77802c06da41e@uwe... Hello Valko, Sheet2 has more than half a million of rows. (Excel 2007) Zip codes don't have leading 0s. They are entered as Numbers. (I can change them if neccessary) T. Valko wrote: How many rows of data do you have in Sheet2, more than 5000? Are the zip codes standard U.S. 5 digit zip codes? Do any of the zip codes start with leading 0s? If so, are the zip codes entered as TEXT strings or are they entered as NUBERS with a custom number format to allow the leading 0s? Hello, [quoted text clipped - 10 lines] thank you. -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! Find Closest Coordinate Match | Excel Discussion (Misc queries) | |||
| closest match | Excel Worksheet Functions | |||
| Find the closest match to a reference number in a row of unsorted | Excel Worksheet Functions | |||
| find closest match to a reference number in a row of numbers | Excel Discussion (Misc queries) | |||
| Closest number match help ... | Excel Worksheet Functions | |||
Threaded Mode
