Search results

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!

Thank you so much.

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.

This marked all records as false.

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...