Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
scanning for numbers and displying the number next to it.
Both columns consist of hundreds of numbers. What i need to do. I need to
scan Column 'A' for a certain number, once that number is found, it puts the number directly next to the number (the number in Column 'B') into Column 'C'. Let me give an exact example. I want to scan Column 'A' for the number '2' once a '2' is found it places the number directly next to the number 2 in Column 'C'. A summary, scan Column 'A' for a specific number, once that number is found it takes the number in Column 'B' (which is next to the two in 'A') and places the number found in Column 'B' into Column 'C'. I hope this is possible. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
scanning for numbers and displying the number next to it.
first a number does not mean anything text and values is
how you need to think What I think you want is to popluate the cell lets 1234 street, has a city of Dallas and st of TX are wanting to type 1234 St into column and then the st and zip appear in col b and c wright me back "Mike" wrote: Both columns consist of hundreds of numbers. What i need to do. I need to scan Column 'A' for a certain number, once that number is found, it puts the number directly next to the number (the number in Column 'B') into Column 'C'. Let me give an exact example. I want to scan Column 'A' for the number '2' once a '2' is found it places the number directly next to the number 2 in Column 'C'. A summary, scan Column 'A' for a specific number, once that number is found it takes the number in Column 'B' (which is next to the two in 'A') and places the number found in Column 'B' into Column 'C'. I hope this is possible. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scanning | Excel Worksheet Functions | |||
Scanning a barcode | Excel Discussion (Misc queries) | |||
Bar Code Scanning | Excel Discussion (Misc queries) | |||
Scanning down a column | Excel Discussion (Misc queries) | |||
scanning a table? | Excel Worksheet Functions |