Hello Jorge,
Try using this formula in C4 copied across and down
=(LEN($A4&$B4)-LEN(SUBSTITUTE($A4&$B4,"-"&C$2,"")))/(1+LEN(C$2))
custom format as 0;; if you don't want zeroes to display
Hello Jorge,
Try using this formula in C4 copied across and down
=(LEN($A4&$B4)-LEN(SUBSTITUTE($A4&$B4,"-"&C$2,"")))/(1+LEN(C$2))
custom format as 0;; if you don't want zeroes to display
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks