Lookup ...... I think?!?

WERNER SLABBERT

Board Regular
Heloo all

i need a quick solution to a very anoying problem......
i have i long sheet full of details as follows:
a1 = name
b1 = department
c1 = school qualifications
d1 = diplomas
e1 = certificates
f1 = further........ and so on....

with about 800 people in this sheet at any one time i don't have the
patients to sit and search how many times applicat X has studied accounting.

now my question..... is there a function... ( not vb code )
that i could put into g1 that will search that row for the word accounting and return the number of times it occurs there?

any and all help appreciated greatly.
thanx WJS

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Hello,

look at COUNTIF

Colin Legg

MrExcel MVP
Perhaps this:
Code:
``=COUNTIF(G2:G800,"*accounting*")``

Change G2:G800 to the range you want to search.

Hope that helps...

Domski

Well-known Member
If you literally just want to search for the word "Accounting" then COUNTIF should do what you want, e.g.: =COUNTIF("A2:A100","*accounting*")

Dom

WERNER SLABBERT

Board Regular
If you literally just want to search for the word "Accounting" then COUNTIF should do what you want, e.g.: =COUNTIF("A2:A100","*accounting*")

Dom
ok so countif will do that but what do i add to the function to get it to return the number of times it appears in that row?

WERNER SLABBERT

Board Regular
ok so countif will do that but what do i add to the function to get it to return the number of times it appears in that row?

Replies
0
Views
460
Replies
2
Views
3K
Replies
0
Views
2K
Replies
8
Views
483
Replies
0
Views
430

1,190,911
Messages
5,983,524
Members
439,848
Latest member
timmyo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back