+ Reply to Thread
Results 1 to 2 of 2

If equal to

  1. #1
    Forum Contributor
    Join Date
    09-21-2020
    Location
    israel
    MS-Off Ver
    2017
    Posts
    113

    If equal to

    Hello friends,
    I have a file with a number of different statuses
    I want to create another column that will merge the different statuses under one category
    for example:
    If X or Y is listed in the column, write a sale in the additional column
    Thanks
    Attached Files Attached Files
    Last edited by oriazria; 06-29-2022 at 02:53 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: If equal to

    Help!! Hebrew... and right to left!!!

    Since you didn't provide us with expected answers... this is but a guess:

    =IF(ISNUMBER(MATCH(D2,$K$5:$K$10,0)),"לא נמכר","")
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Date Greater Than equal to and Less than equal to (Month and year)
    By senthile in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-17-2021, 01:31 PM
  2. Replies: 3
    Last Post: 05-23-2019, 01:12 AM
  3. Replies: 2
    Last Post: 06-10-2017, 04:58 PM
  4. [SOLVED] Populate count & sum based on equal to & not equal to factors
    By jscalem in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-20-2015, 01:20 PM
  5. [SOLVED] COUNTIFS function w/greater than or equal to, and less than or equal to time values
    By AliciaRenee in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2014, 03:57 PM
  6. Scoresheet with Equal Ranks - need to identify equal placings separately
    By Caroleh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 02:59 AM
  7. lower and upper case equal on spreadsheet but not equal in VB
    By don in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2005, 09:06 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