Results 1 to 3 of 3

If range contains text, based on a reference cell. Index/Match? (Microsoft Forms Data)

Threaded View

tkoziol If range contains text, based... 01-17-2023, 01:24 AM
restri Re: If range contains text,... 01-17-2023, 03:36 AM
HansDouwe Re: If range contains text,... 01-17-2023, 04:50 AM
  1. #1
    Registered User
    Join Date
    01-12-2020
    Location
    Chicago
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20378) 64-bit
    Posts
    19

    If range contains text, based on a reference cell. Index/Match? (Microsoft Forms Data)

    Hello Everyone! I have a Microsoft form set up where users can check multiple boxes. Does anyone know how I could view the results based on the user ID?

    Each question has changed a little over time but I have kept the left 4 characters the same to use as a question ID. Using that ID, I'm hoping to enter a user ID and be able to see the questions that were checked off and the ones that were not.

    Thank you!
    Attached Files Attached Files
    Last edited by tkoziol; 01-17-2023 at 01:49 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivoting Data from Microsoft forms
    By dominion in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-12-2022, 07:47 PM
  2. Named range based on text in column header rather than cell reference?
    By scampie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2021, 05:19 PM
  3. Replies: 8
    Last Post: 09-06-2016, 01:50 PM
  4. Data Cross Reference (validation) based on Text in a Cell
    By kwjoh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2015, 01:57 AM
  5. Replies: 2
    Last Post: 08-06-2012, 04:21 PM
  6. Error message on excel 2007 probably due to reference "Microsoft Forms 2.0"
    By aron in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2010, 11:58 AM
  7. [SOLVED] Reference Data Range based on cell contents
    By PCLIVE in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-27-2006, 11:10 AM

Tags for this Thread

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