LinkBack URL
About LinkBacks
Hi,
How do you get 22 occurrences of the 000001 pattern. I can only see 13
Wouldn't it be simpler to concatenate B3:G3 into say A3, copy it down. Do the same with L4:Q4 in say K4, then in R4 use
Formula:
=COUNTIF(A:A,K4)
Hi,
How do you get 22 occurrences of the 000001 pattern. I can only see 13
Wouldn't it be simpler to concatenate B3:G3 into say A3, copy it down. Do the same with L4:Q4 in say K4, then in R4 use
Formula:=COUNTIF(A:A,K4)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks