Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help matching...
Hi,
Sorry, I inadvertantly posted this in the non-function Excel group, then soon realized I had used the wrong group. Pardon the double-posting, but I really could use some expertise in resolving this problem.... I have a spreadsheet where I have 3 columns of numbers in A, B, and C, (skipping column D for clarity sake). In column A there are subgroups of numbers in tenth increments until they get to the next subgroup. However, if you truncate the column A numbers you would have 3 rows starting with 1, 2 rows starting with 2, 5 rows starting with 3, 3 rows starting with 4 and 1 row starting with 5. The numbers in column B that are adjacent to the truncated numbers in column A, mean that there are numbers 41, 252, 305, 422 and 441 that correspond to the truncated number 3 in column A. Somehow, I need to get the numbers in column C to match up to the closest number in column B, yet still correlate to the truncated numbers in column A. Column E is being shown to give an idea as to what I need to replace column C with. When I'm done, I will end up having to work the reverse scenerio with columns B and C, because there may also be gaps in column B. Any help would be greatly appreciated. Notice how E6, E8 and E10 are now in cells that are closest to matching the numbers in B6, B8 and B10 and they are all corresponding to the truncated number's 3 in column A... TIA, Steve A B C D E row 1 1.1 76 71 71 row 2 1.2 124 117 117 row 3 1.3 156 159 159 row 4 2.1 12 5 5 row 5 2.2 54 59 59 row 6 3.1 41 45 45 row 7 3.2 252 310 row 8 3.3 305 438 310 row 9 3.4 422 row 10 3.5 441 438 row 11 4.1 33 35 35 row 12 4.2 107 111 111 row 13 4.3 180 175 175 row 14 5.1 227 230 230 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return all matching values | Excel Worksheet Functions | |||
Otto M. - Data Matching | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Count matching cells | Excel Worksheet Functions | |||
Matching cells | Excel Discussion (Misc queries) |