Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default Compare several cells in row & output value for match

Hi all,

I would please need some support for the following macro: the value of
column Z in a row should be compared with the values in columns N to S in the
same row (the values to compare are dates). The output of the comparison
should be input in column T of the same row. Mismatch value = 0, match value
= 1.

Many thanks for any support!
Reply
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 cells and copy columns after match Kcope8302 Excel Worksheet Functions 2 August 5th 09 05:37 PM
Compare 2 Columns, then output a list JohnHB Excel Programming 3 May 31st 07 09:46 PM
Compare cells and concatenate on match [email protected] Excel Programming 2 January 18th 07 06:42 PM
Open two worksheets, then match and compare cells Bob[_15_] Excel Programming 0 August 8th 06 10:21 PM
how to compare two columns and get a output from it [email protected] Excel Worksheet Functions 3 July 5th 06 08:19 AM


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