Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hey guys, i was wondering if there was a way to find information from "Column
A" and remove it from "Column B" For Example | Column A | Column B | | 1 | 1 | | 3 | 2 | | 5 | 3 | | 6 | 4 | | 8 | 5 | | 9 | 6 | into | 1 | | | 3 | 2 | | 5 | | | 6 | 4 | | 8 | | | 9 | | or somehow use a Column C to Identify the rows that repeat column A info in Column B. For example:? | 1 | 1 | 1 | | 3 | 2 | | | 5 | 3 | 3 | | 6 | 4 | | | 8 | 5 | 5 | | 9 | 6 | 6 | THANKS! johnny b |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding Info from sheet 1 and removing only those rows from sheet | Excel Discussion (Misc queries) | |||
Finding info of one column and removing it from another | Excel Discussion (Misc queries) | |||
Finding/Removing Duplicate Numbers In A Column ? | New Users to Excel | |||
Finding the closest number in column A and take the value in column B | Excel Worksheet Functions | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) |