LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
fl fl is offline
external usenet poster
 
Posts: 10
Default how to extract from this column

I want to extract everything not equal to "GOOD" from this list and
place the results on another column next to it with no blank rows.
Thanks.

Column A Column B
======= ======
GOOD 456
GOOD 123
GOOD 2599
456 2489
GOOD 549
GOOD
123
GOOD
GOOD
2589
GOOD
GOOD
GOOD
GOOD
2489
549
GOOD
GOOD
GOOD
GOOD


 
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
How to extract data from a column sakaraat Excel Discussion (Misc queries) 1 July 18th 08 04:46 PM
How do I extract the numerical value of '325.00' to next column Pathung Excel Worksheet Functions 3 January 31st 08 10:34 PM
Extract data in put in a new column Michael Excel Worksheet Functions 5 February 18th 07 12:10 PM
Evaluate a column and extract last value Virg Excel Worksheet Functions 3 November 5th 06 09:03 PM
extract column or row reference BRPtacek Excel Discussion (Misc queries) 3 August 23rd 05 11:29 PM


All times are GMT +1. The time now is 02:11 AM.

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

About Us

"It's about Microsoft Excel"