Hi guys,
Yesterday I was struggling with my excel worksheet and one of you gave me a great idea (using a pivot chart).
Thing is that my knowledge is more than basic. To be quick my worksheet containts 40000 entries of different customers (each customer has a unique ID) but it could happen that the same customer is twice in the list. I used a macro to highlighted in red the unique ID's cell when there is a duplication.
But I am not able to create a pivot chart who do not consider duplicates cells. So what I was thinking, is to add a new column with a 1 or a 0 when the cell is red and then use this column in the pivot chart.....anyway
Does anyone know which formula I could use to say if the cell background is red = 0 if not = 1
Thanks a lot for your help
Yesterday I was struggling with my excel worksheet and one of you gave me a great idea (using a pivot chart).
Thing is that my knowledge is more than basic. To be quick my worksheet containts 40000 entries of different customers (each customer has a unique ID) but it could happen that the same customer is twice in the list. I used a macro to highlighted in red the unique ID's cell when there is a duplication.
But I am not able to create a pivot chart who do not consider duplicates cells. So what I was thinking, is to add a new column with a 1 or a 0 when the cell is red and then use this column in the pivot chart.....anyway
Does anyone know which formula I could use to say if the cell background is red = 0 if not = 1
Thanks a lot for your help