LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 142
Default Compare two file/colunms, hide row not does not equal list.

Excel 2000 -have two files. File "A" has 1 through 4155 records (rows with
three columns) in numerical order. File "B", has a list of almost 200
rows/numbers (one column) from file "A". How can I hide the rows in file "A",
not are listed in file "B"?

Thanks, Jerry
 
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
compare two text and if equal copy adjacent data Prashanthom Excel Worksheet Functions 1 December 29th 06 03:03 AM
Comparison of data in two separate colunms thaenn Excel Discussion (Misc queries) 7 October 20th 06 06:37 PM
Compare two dates and if they are equal PeterArvidsson Excel Discussion (Misc queries) 1 April 21st 06 02:40 AM
Pivot report - Hide Sums equal to zero Anette Excel Discussion (Misc queries) 2 February 21st 06 08:55 AM
How to set SAVE AS file name to equal A1 contents when rename file E Excel Discussion (Misc queries) 0 October 19th 05 08:36 PM


All times are GMT +1. The time now is 06:29 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"