?
Solved

Comparing multiple columns for multiple values - Excel

Posted on 2012-04-02
1
Medium Priority
?
309 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 49

Accepted Solution

by:
Martin Liss earned 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Viewers will learn how the fundamental information of how to create a table.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

770 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