This should be a simple problem but I seem unable to sort it:
I have a list of numerical and word product codes in B44:B60, e.g HJK/5566712/19
A macro button on each row can copy the data from B44 over to H44 when sent to another department.
Hitting the button again undoes the...
hi how can i use the countifs formula to count all the information from a tabel that is not #N/A and also meets another criteria
in the case below i would need to know what is the total number of information from column col1 that is "X" and all the information in column col 2 that is NOT #N/A...