LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Finding Info from Column A and Removing it from Column B

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding Info from sheet 1 and removing only those rows from sheet Johnny B[_2_] Excel Discussion (Misc queries) 1 March 28th 07 02:29 PM
Finding info of one column and removing it from another Johnny B[_2_] Excel Discussion (Misc queries) 9 March 19th 07 09:19 PM
Finding/Removing Duplicate Numbers In A Column ? Robert11 New Users to Excel 3 November 26th 06 10:48 PM
Finding the closest number in column A and take the value in column B reefguy Excel Worksheet Functions 3 May 5th 06 07:25 PM
Link info in one cell to info in several cells in another column (like a database) hansdiddy Excel Discussion (Misc queries) 1 February 22nd 06 02:27 AM


All times are GMT +1. The time now is 09:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"