Forum Discussion
Solved
Use colour to enter a logical value
Hi. I need to put a value into a cell to show we have a repeat caller. I've used the conditional formatting for duplicate numbers (the last part only, so not an exact science), so these have been c...
Jane_at_Stamma Transform your table to a structured Excel table and use a formula like in the "repeat" column to count the number of occurrences of the current caller ID up to the current row. If 1, then this is first time caller. Anything higher than 1, then it's a repeat caller.
By the way, I changed the conditional formatting rules a bit. See attached.
Riny_van_Eekelen give me a while whilst I work out how to structure my table and work out what you did re the formatting...
Jane_at_Stamma Added a less structured, more old-style, for your reference. Might be easier to understand what I did. See attached.
- OK, pasted in the first formula, using my table name, and it autofilled the column like magic. THANK YOU 🙂