Is there a formula I can use to find the word "Missing" in a specific sheet. This specific sheet contains formulas that contain the word "Missing" if an error is found.
Is there a formula I can use to find the word "Missing" in a specific sheet. This specific sheet contains formulas that contain the word "Missing" if an error is found.
Your title says:
and then you say:Find the Word "Missing" - Not In a Formula
and you've posted in the VBA section.Is there a formula I can use to find the word "Missing" in a specific sheet.
Do you mean code?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
sorry that was not intentional. It would be a formula, I just want it to return if there is a match for this word. Display the count of this word. The sheet it would be referencing to has a lot of formula with an IFERROR statement that displays the word "Missing" if it did not find a match. I would like to count the number of "Missing" words from this sheet but do not look inside the formula. Just what it displays. Not sure if that makes sense.
You can use COUNTIFS for that as it looks at the displayed value of the cell not the formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks