Replies

Thank you Hans and Steve! I also appreciate the explanation of what’s going on in the formula. That will help in the future.

I know I said to ignore the strikethrough cell formatting when a match is found, but can it be returned in cell B4 as well?

Thank you Rory and Tom. The Round function did the trick.

Thanks, Hans. Sometimes simple -is- better!

Thanks for your help, Hans.
This will greatly increase the efficiency of our work. The recommended solution was successful.

Thank you, Hans. That does the trick!

Second file

Thank you, Hans. I am using PowerPoint 2002 (Office XP). I’ll take a closer look at the link for additional suggestions.

Sarah

Thanks, Steve! There might be a Word Art option to meet my need.

Thank you, Hans. I will try that.
-Sarah

Looks good, Jeremy. I can work with that.
Now someone will have to explain how this is done so I can add levels in the future

Sarah

Thanks, Jerry. That is what I’m looking for but with two more levels. Here’s my attempt, but the base starts to flare out.

Sarah

Thanks, mbarron. That’s all it needed! The subject of this post is a little misleading since I had originally been checking for a in the result cell, but I wasn’t sure how to write that in the function. I switched to a result of zero to make it quantifiable. Was also curious to know if I could check noncontiguous cells so that my formula was =COUNTIF(B10,D10,F10,”>0″) but it didn’t like that

Thank you, Hans. That did the trick.
And security is now set to Medium!

Sarah

And thank you, maxflia10. Do either of the formulas perform more efficiently than the other? Or is it simply another way to accomplish the goal?

Thanks Macropod! That works. Now I’ll do a little research to figure out how it works. Pretty cool!