Results 1 to 4 of 4

Formula to compare 2 columns for a given number in another column

Threaded View

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    charlotte, nc
    MS-Off Ver
    Excel 2013
    Posts
    11

    Formula to compare 2 columns for a given number in another column

    Hi guys,

    So I have a sample spreadsheet attached. Keep in mind this spreadsheet will be long so the formula can't be hard coded data. What I am looking for is this:

    You have the following:

    Column B - SSN
    Column G - Length of Acct #
    Column H - Last 2 digits of Acct #

    IF for a given SSN in Column B (the normal spreadsheet will have MANY SSNs so formula needs to be dynamic), the person has a 01 in Column H and a 16 in Column B then I want the text "Review" in column E on the first row for that SSN.

    In the full spreadsheet, some SSNs may have 3 rows of data and some may have 15 so the formula needs to be able to look through each row for a given SSN, then look to see if 01 and 16 are both present and then put "Review" in Column E.

    Thanks for the help!
    Attached Files Attached Files
    Last edited by igotgame; 10-07-2021 at 01:39 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 16
    Last Post: 08-29-2021, 01:20 PM
  2. 2 Columns - Compare columns and give a percentage of number of matches
    By Dave1969 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-24-2020, 06:55 AM
  3. [SOLVED] Lookup formula to find last number in a column and compare to the cell above.
    By A440 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-23-2019, 07:32 AM
  4. Replies: 11
    Last Post: 01-19-2018, 05:43 AM
  5. Replies: 6
    Last Post: 09-21-2016, 04:21 PM
  6. [SOLVED] Compare columns, replace matching number with reference number and fill down random amount
    By datadigger in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-04-2012, 10:53 PM
  7. compare columns and count number of matching columns
    By san000 in forum Excel General
    Replies: 1
    Last Post: 07-15-2009, 10:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1