LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Comparing value in multiple columns

Hello,
What is the best way to see if there are any differences in the values for
numerous colunms, excluding any blank cells? There are 24 columns, including
columns with blank values. Couldn't get if statement to work... Example:
IBLITM CA03 CA01 CA02 CA04
000000103 31 31 31 31
000000309 31 31 31 31
000000701 31 31 31 31
000000804 31 31 31 31
000001104 31 31 31 31

 
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
Comparing multiple columns in two sheets [email protected] Excel Worksheet Functions 1 March 30th 07 07:12 PM
Comparing two columns of information with 2 new columns of informa cbuck Excel Discussion (Misc queries) 1 January 16th 07 09:49 PM
comparing multiple columns teejay Excel Worksheet Functions 3 August 2nd 06 03:24 PM
comparing multiple columns teejay Excel Worksheet Functions 0 August 2nd 06 02:01 PM
Comparing multiple columns daarun New Users to Excel 3 December 23rd 05 01:17 PM


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