LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Check if the value of one cell can be found in a number of other c

I am trying to compare a register of members with member-IDs to a list of
members who would like to close their membership but I haven't found a good
way to compare the value of one cell with the value of several cells (a
column) thereby checking if any value from cell A1 can be found in any of
cells B1 to B100 and the same for A2, A3 and so fourth.

Any suggestions?
 
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
Extract number from cell when specific format is found paul c Excel Worksheet Functions 6 August 2nd 09 03:45 AM
How to get number of filtered records found displayed in a cell? Jessica New Forest Excel Worksheet Functions 4 March 25th 09 11:57 AM
Count the number of Commas found in cell A2 B~O~B Excel Worksheet Functions 3 April 2nd 08 05:27 PM
Check if cell value is found in a seperate range of values wilby31[_2_] Excel Programming 1 October 15th 05 12:28 AM
Check if a value is found twice in a range François Excel Programming 3 May 13th 05 12:52 PM


All times are GMT +1. The time now is 12:31 PM.

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"