Forum Discussion

ricardo2260's avatar
ricardo2260
Copper Contributor
Aug 23, 2024

please help give me the formula

I have tried using several formulas that I know, but they still don't work well, please help

I want to make sheet 2 a search sheet, while sheet 1 is a collection of existing data

for example, I want to see who the members of A are on 01-01-2025, and B,C,D etc.

Please help

 

 

1 Reply

  • mathetes's avatar
    mathetes
    Silver Contributor

    ricardo2260 

     

    It's not totally clear what you are wanting your "search" sheet to display, but let me refer you to the FILTER function. Here is a web page that explains it. Here's a YouTube video that explains it.

     

    If that doesn't work for you, perhaps you could come back with a more complete description of the need and why FILTER didn't work.

Resources