Hi, Could you assist me with the formula to count number of occurrences of the values in a column?
For example, I have a customer_id column in a table which has values such as 1, 2, 1, 5, 4, 1, 4, 3 etc. Basically one customer id could appear multiple times in the customer_id column.
I need to do apply Background colors on the cells using expressions based on single or multiple occurrences of customer IDs in this column. For example I would like to represent respective cells for customer IDs 1 & 4 (that appears more than once) with Red color and cell with customer IDs 2, 3 & 5 (that appears only one time) with blue color in the column
Any suggestions regarding an expression / formula is appreciated.