copying data

  • Thread starter Thread starter jc
  • Start date Start date
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
 
Hi
if I understood you correctly you want to count the occurences of the
word in brackets (e.g. arg, rmd).
Try the following formula in A7
=COUNTIF(F$5:L$177,MID(A6,FIND("(",A6)+1,FIND(")",A6)-FIND("(",A6)-1))
 
Create a lookup table like:
1 2
A ShortName Fullname
B arg Argos
C rmd Royal mail

then use Vlookup() to bring in the Fullname
HTH
 
Back
Top