Results 1 to 4 of 4

Combine results of IF statement?

Threaded View

  1. #1
    Registered User
    Join Date
    03-13-2018
    Location
    Sequim, WA
    MS-Off Ver
    2016 365
    Posts
    5

    Exclamation Combine results of IF statement?

    Hello,

    I am trying to create a formula on my table to combine the names of the volunteers that are on the same shift each day. I am not sure if i use the IF statement or need to use a lookup?

    Here is an example:
    If "Date","Location","Start Time","Stop Time" are the same then give all volunteers names with the same criteria. Answer I am looking for outlined in RED.

    Thanks for your help!

    Nick
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by vxhatch; 03-13-2018 at 03:55 AM. Reason: Added Dummy Book

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 19
    Last Post: 01-29-2015, 05:33 PM
  2. Combine Value of 5 Cells and List Results
    By Andrew.Trevayne in forum Excel General
    Replies: 3
    Last Post: 06-29-2011, 08:30 AM
  3. Formula to combine 2 results
    By ssdsibes in forum Excel General
    Replies: 6
    Last Post: 11-17-2010, 06:49 PM
  4. Combine Coinciding Results.
    By zealot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2009, 07:51 PM
  5. If statement with negative numbers = stumped analyst
    By lukep10 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2008, 09:30 AM
  6. combine B results for multiple matches in A?
    By toms4n in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-29-2006, 04:49 PM
  7. Replies: 2
    Last Post: 06-26-2006, 12:25 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