Hi
Assuming I have a file with many rows or product codes and want to count the number of times each product code is duplicated and insert this value into a column in the data, I would use the COUNIF formula. Now if I want this to be modified to only count the visible rows when I apply filtering, can anyone tell me how to modify my formula?
Regards
Assuming I have a file with many rows or product codes and want to count the number of times each product code is duplicated and insert this value into a column in the data, I would use the COUNIF formula. Now if I want this to be modified to only count the visible rows when I apply filtering, can anyone tell me how to modify my formula?
Regards