Hi everybody,
I looked through the posts but I can not find something close to what I intend to do:
count how many different colours are present in specific areas : if nothing is present then will be returned the letter 'n' if are present some values but no colours then will be returned one zero, if coloured cells are present only the total number of colour found will be returned ( no duplicate ) see the attached screenshot were i have manually analized areas P132:R153 , S132:U153, V132:X153, Y132:AA153.....and returned values in row 159
if anyone has something that can be useful for the purpose I would be very grateful
riccardo
Reply With Quote