J
jc
I have many cells with this type of info in each cell as
follows.
a1 a2 a3
arg rmd ikea
I then use =COUNTIF(F$5:L$177,"arg")to count each
occurance of "arg" or "rmd". this then gives me totals for
each customer usage.
My problem is "arg" or similar are acronyms for larger
words. how would it be possible once counted to
automatically count and enter the sums in the right
columns, as follows
a6 a7
argos(arg) 24(sum of countif)
royal mail(rmd) 66 "
How I do it at the moment is to drag down a7 and manually
change each 3 letter acronym and manually type the names
of the companies corresponding to the acronym.
any help would be appreciated
jc
follows.
a1 a2 a3
arg rmd ikea
I then use =COUNTIF(F$5:L$177,"arg")to count each
occurance of "arg" or "rmd". this then gives me totals for
each customer usage.
My problem is "arg" or similar are acronyms for larger
words. how would it be possible once counted to
automatically count and enter the sums in the right
columns, as follows
a6 a7
argos(arg) 24(sum of countif)
royal mail(rmd) 66 "
How I do it at the moment is to drag down a7 and manually
change each 3 letter acronym and manually type the names
of the companies corresponding to the acronym.
any help would be appreciated
jc