Hello,
I am working on a project that requires me to list all of the values corresponding to a specific name after meeting a criteria. I am not very good at explaining this, but if you look at the "Example" tab in the attached file, you will understand. I have created a dummy set of data on the "Data" tab, if someone could show me an example of how I would do this for thousands of data points, that would be great.
Thank you for your time and help.
Ronak
Enter array formula in H3 and drag formula across to S3 and down
***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Here you go...
This is an Array formula (Ctrl+Shift+Enter), kindly refer the attached excel for further explnation:
Formula:Please Login or Register to view this content.
Last edited by than_gold; 07-06-2018 at 09:05 AM.
Regards,
Thangavel D
Appreciate the help? CLICK *
Thank you, this is exactly what I was looking for, but could not figure out how to work the array formula. Greatly appreciate your help!
AlKey,
Do you mind explaining to me what the IF statement is doing in this formula. I'm having a hard time figuring out how you are utilizing it. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks