Solved

Comparing multiple columns for multiple values - Excel

Posted on 2012-04-02
1
299 Views
Last Modified: 2012-04-02
I can use IF(or(......   to compare a column for multiple values.  Is there a way to compare multiple columns for multiple values.

Example:
If column_ A or column_b or column _c or column_d is equal to ('60', '61', '72','75','88', '95')
Then column_E =1
0
Comment
Question by:morinia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 47

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 37797620
If CheckValue(column_A) or CheckValue(ccolumn_B) or CheckValue(column_C) Then
    column_E = 1


Public Function CheckValue(intValue As Integer) As Boolean
   
    Select Case intValue
        Case 60, 61, 72, 75, 88, 95
            CheckValue = True
    End Select
   
End Function

You'll need to make sure column_A, etc actually refers to the value in the range.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question