+ Reply to Thread
Results 1 to 2 of 2

Trying to return text based on criteria if all the text is the same

  1. #1
    Registered User
    Join Date
    05-17-2019
    Location
    Bettendorf IA
    MS-Off Ver
    Excel 2016
    Posts
    1

    Trying to return text based on criteria if all the text is the same

    I need to show the Plant on a summary from a list of daily entries. The summary includes a sum of Ticket quantities and an average of Batched quantities based on a report number and design number. In addition I want to show the plant name if all the plant names are the same. If they are not the same then I want to show "Unmatched".

    What I can't figure out is how to have the plant names compared and if they are the same, show the plant name. Attached is an example of my data. I've highlighted what the results should be in the summary area.

    I'd like to stick to a formula, but am not adverse to using VBA if necessary.

    Thanks for any help.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Trying to return text based on criteria if all the text is the same

    The following formula in M6 then copied to your other highlighted cells matches your expected results.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    EDIT >>>>> This is an array formula and must be committed with CTRL-SHIFT-ENTER

    Maybe someone will come up with a more compact formula!

    The attached update of your workbook includes the above changes.
    Attached Files Attached Files
    Last edited by GeoffW283; 05-17-2019 at 09:53 PM.

+ 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] Formula to return text based on two criteria
    By KClem in forum Excel General
    Replies: 6
    Last Post: 10-16-2017, 02:16 PM
  2. Replies: 3
    Last Post: 12-03-2014, 05:43 PM
  3. [SOLVED] Return Text based on criteria
    By shido in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-04-2013, 07:19 PM
  4. [SOLVED] Return Text based on criteria
    By shido in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-04-2013, 04:08 PM
  5. Replies: 1
    Last Post: 01-20-2012, 09:44 AM
  6. Return a Text Value based on criteria
    By SeanKosmann in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2010, 04:08 PM
  7. Return text based on criteria
    By PearlJam in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-02-2009, 08:58 AM

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