LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Crosscheck values against the list of values.

Hi All,

I am new here and I need your help. Well, I have column called hotel_code
and it has some values, now I need to crossckeck these values against the
list of values and popup a massase, if any of the values are not available in
the column. For Example

Hotel_code

DELTR
BOMHI
BBITR

Now, my requirement to crosscheck these values against the list
(DELTR,BOMHI,BBITR,COKTR, MAATR). Now in the column hotel_code, it does not
list COKTR and MAATR. Now, I want a popup massage which would able to
indicates, these values (COKTR and BBITR) is missing.

hare krishna
Alok

--
none
none
none
none
 
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
Identify & List unique values from a list using functions/formulas momtoaj Excel Worksheet Functions 3 May 31st 07 06:18 PM
create a list of single values from multiple values Jordan Excel Worksheet Functions 3 November 3rd 05 11:25 PM
How do you sum just values that are bold in a list of values? Dominic Excel Worksheet Functions 3 September 9th 05 06:37 AM
Count unique values and create list based on these values vipa2000 Excel Worksheet Functions 7 August 5th 05 01:17 AM
create list of unique values from a column with repeated values? Chad Schaben Excel Worksheet Functions 1 July 8th 05 10:25 PM


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