Forum Discussion

Copper Contributor

Nov 10, 2022

Condition for repeated Data appearence

Hello everyone, I am seeking your help with this query. I was searching for a way to condition formatting a cell that contains data or even a way of writing down a macro to make a pop-up message or...

BI & Data Analysis

excel

Formulas and Functions

Macros and VBA

EzzEldean

Copper Contributor

Nov 10, 2022

Kindly note that it's similar to an If statement as I am trying to say to Excel that " count what appears in cell A5021 to see how many times it appears and If you see data in Cell A5021 and was selected/appeared 3 times or more through the day or the next 3 days starting from the day we are currently at, then Highlight the cell or show me a message as a reminder saying that this data that was selected or seen multiple times is repeated."

Example

=If( logical test is to count if the "QNB0003 or any selected data from the filter" ( for example ) appears 3 times or more, value if true then highlight the cell or show me a message to tell me it's repeated, value not true ignore till the data is selected or appears 3 times at least or more to be repeated.)