How do i get a formula for word recognition in cells

[Guest]

I am trying to create a worsheet that is linked to another(I know how to
link) but I am having difficulties as I can only link to set cells. i am
looking for a formula that will recognise the word and send it to the
specific spreed sheet.For example I have 435 items in one column but instead
of putting the items in selected cells I want the formula to pick up on the
word (THAT HAS BEEN RANDOMLY LISTED IN THE COLUMN) and sends it to the
specified sheet? I hope that does not sound confusing and someone can help
me.Thank you

 

[David McRitchie]

Hi Kenya,
A formula cannot change the value of another cell. All that a
formula can do is return a value.

So you will have to redefine your requirements. From what you wrote
I can't guess at what you are looking for. You could copy the sheet
(possibly in a macro) and sort the words on that sheet. If you know
what the words are you could use COUNTIF to get a count of the
number of occurrences.

Usually you have to think in terms of receiving a value instead of
sending a value. But from what I see of your question it doesn't
look like you can turn it around though that could just be because
there is no information on what you really want to do.

 

[Guest]

Like David says, formulas dont send, it takes a macro to do that.......but
even at that, the macro must have some reference of "what" to send, and
"where" to send it........you can't just send any word to some unknown
place....what with all the various spellings and mis-spellings of the same
words........start with your list of words, and where they should
go........define the things you wish to happen a little better and then
perhaps someone can write you a macro that will interrogate each word on your
database and compare it to your special list and determine if it's there,
where it should be copied to.....

hth
Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thank you foryour help but I am still lost. Mainly because i have no idea
about macro's.Basically what i am trying to do is to make up a spreedsheet
where i can use it for stock control and when you have over 2500 single items
to catogories it becomes difficult to put it in a set cell and also difficult
to use data linking?I have got spreed sheets linked to the purchase list but
when you have 2500 seperate items it becomes slightly painful to source the
cell even when they are set in catogories.How would i go about using the
COUNTIF FORMULA in this case?

 

[Guest]

The syntax for the COUNTIF function is pretty straight forward.....

COUNTIF(range,criteria), with RANGE being the cells you wish to interrogate,
and CRITERIA being what you want the formula to look for and count.........

As for how to apply it in your situation, I have no idea, as I'm not sure
what you are wanting to count.......your first post did not mention counting
at all, only how to "send" words to specific sheets, ......I'm afraid you
will have to be more specific as to what you are trying to do, with actual
Cell Addresses and values and what you expect to have happen.......we want to
help, but need more info......

Vaya con Dios,
Chuck, CABGx3

 

[David McRitchie]

Obviously if the only answers you are getting is what do you want
to do, you are not making it clear what you want to do.

How about starting with what you want to do, rather than asking how
to implement something that was only a guess at something that
might help but not really knowing what you are looking for. it was
only a wild guess that you might want to count specific occurrences
of known words on another sheet...

You will have to figure out how you would do this manually and be able
to put that in writing before you ask for someone to help you.

You will have to be able to define the process clearly so that you
have already considered such questions as we might have to ask
if you don't specify clearly what you want to do and how to do it.

Consider the news reporting, English class, scientific investigation
type of thing. Who, when, why, where, how, and how much?

Start with an example of your data, say 10 cells, and figure out
what you have to do manually to describe the problem, and solve
your problem. what you want, and if still not obvious how you would
know when you have successfully completed the task.

 

[Guest]

Thank you, thank you and thank you. I have got it with the help from the both
of you.And SUMIF! Fabulous. i am self taught in Excel and reached this
stumbeling block and now it's resolved. One more question for you? In a colum
of invoices how do i find out which figure is missing numerically. i know how
to get a warning for a duplicated invoice but am now stuck on finding out
which numbers are missing.