Forum Discussion
conor1797
Jun 28, 2021Copper Contributor
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...
conor1797
Jun 28, 2021Copper Contributor
Hi NikolinoDE thank you for your response. I have added a Sample Data file to the original post.
NikolinoDE
Jun 28, 2021Platinum Contributor
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)