Forum Discussion
Need to return entire rows from based on two critieria
I have one dataset on a worksheet with around 20 columns and hundreds of rows. I need a formula that can return entire rows based on two criteria: name (first and surname) and date (on an "on or befo...
If I may recommend, send the file - workbook / worksheet (without sensitive data) with the problem. Explain your problem based on this file.
This would also be a blessing for all of us, as we can understand the problem much better and you can have a fast and good Solution proposal, a win-win situation for everyone.
Welcome to your Excel discussion space!
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Hi NikolinoDE thank you for your response. I have added a Sample Data file to the original post.
Here's an approach with pivot.
I'm not sure if this fits into your plan.
If not, please let me know.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)