Thanks so much. I tried min on my own, but did not include if. I have so much to learn.
I did change your formula just a bit...
=MIN(IF($J$2:$J$732=J2,$O$2:$O$732,""))>=0.95 (figured it was a typo)
Thanks again, I'm truly grateful!!!!
Yesterday I asked for help to show all projects on a contract that were 95% or more completed even in one of the projects did not fall within that range. I got a great solution from p45cal but now my boss wants something different.
I have a list of contract numbers (J2:J732), some of which are...
Thank you so much for your help. I'm really not as crazy as I seem. There have been some strange things happening with Excel since my agency moved to O365. I wonder if I accidently changed that and didn't realize it. You are a lifesaver!!! Thank you, thank you, thank you!!! :):):)
This is just weird! I closed and saved the file so I could send it and then when I opened it back up all the answers were correct. Dang I'm glad it's Friday!
I do not understand why this is not working for me. I copied and pasted your formula and used Ctrl+Shift+Enter and copied down.
I am curious what that answer is on row 28. This (I believe) is the first instance of a multi-project contract that have some over 95% and some under 95%.
I'll...
I've been playing with index and match and commented out my attempt (which also does not work).
As you can see the values in column O range from zero to over 100%.
Thank you for your help.
I have a list of contract numbers (J2:J732), some of which are duplicated because the contract contains multiple projects. In another column I have a list of percentages (O2:O732). These percentages reflect the amount of work that has been completed.
I need to show projects that are 95% or...