Results 1 to 12 of 12

Dynamically Auto Filtering a Shared Excel Document In Teams With IFERROR and Index

Threaded View

sarawho Dynamically Auto Filtering a... 09-28-2021, 04:54 PM
sarawho Re: Dynamically Auto... 09-28-2021, 04:55 PM
sarawho Re: Dynamically Auto... 09-28-2021, 05:09 PM
Gregb11 Re: Dynamically Auto... 09-28-2021, 09:45 PM
sarawho Re: Dynamically Auto... 09-29-2021, 02:14 PM
JeteMc Re: Dynamically Auto... 09-29-2021, 06:21 PM
Gregb11 Re: Dynamically Auto... 09-29-2021, 09:40 PM
sarawho Re: Dynamically Auto... 09-30-2021, 10:51 AM
Gregb11 Re: Dynamically Auto... 09-30-2021, 11:06 AM
JeteMc Re: Dynamically Auto... 09-30-2021, 11:07 AM
sarawho Re: Dynamically Auto... 09-30-2021, 12:05 PM
AliGW Re: Dynamically Auto... 09-30-2021, 12:07 PM
  1. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,869

    Re: Dynamically Auto Filtering a Shared Excel Document In Teams With IFERROR and Index

    If I understand correctly then the attached file does what you want.
    1. The filter formulas in columns B:F are all similar to: =IF(A2="","",IF(INDEX(ResponseEdits!D$2:D$21,MATCH(A2,ResponseEdits!$C$2:$C$21,0))=$I$3,A2,""))
    2. The formula that consolidates the filtered ref's in column G is: =IFERROR(SMALL($F$2:$F$21,A2),"")
    Other formulas are unchanged from those in the file attached to post #5.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Minimize Excel processing time (Formula IFERROR & INDEX used)
    By Bhavesh780 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-21-2021, 10:51 AM
  2. [SOLVED] Code presents error on shared file in teams
    By Chris1976 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-30-2020, 09:15 PM
  3. Replies: 2
    Last Post: 03-03-2016, 02:40 AM
  4. Excel Formula: IFERROR, INDEX, SMALL, MATCH
    By Jenn12788 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-12-2014, 10:03 PM
  5. comparision between two excel sheet using VBA Code for Index/match/and/iferror formula
    By gaurangaero in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2012, 10:08 AM
  6. How to protect a shared excel document from deletion
    By SteveA in forum Excel General
    Replies: 2
    Last Post: 05-23-2005, 08:30 PM
  7. [SOLVED] Filtering a protected WS in a shared workbook - Excel 2000
    By Phuong Nguyen in forum Excel General
    Replies: 3
    Last Post: 02-18-2005, 07:06 PM

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