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

 

 

Excel for web

1 Reply

Sort By
  • mathetes's avatar
    mathetes
    Silver Contributor
    Aug 23, 2024

    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