Pergunte aqui

Perfil de Levity - atividade

2013-12-30 22:37:07 +0200 Medalha recebida  Pergunta famosa (fonte)
2013-12-30 22:37:07 +0200 Medalha recebida  Pergunta notável (fonte)
2013-12-30 22:37:07 +0200 Medalha recebida  Pergunta popular (fonte)
2013-03-31 18:49:14 +0200 Medalha recebida  Palpiteiro
2013-03-31 18:49:14 +0200 Resposta comentada Finding words and numbers in multiple columns

What about if I wanted to do ">1" ?

2013-03-31 18:45:18 +0200 Resposta comentada Finding words and numbers in multiple columns

Doh, I didn't think to try it without the quotation marks. Thanks for responding so quickly!

2013-03-31 08:28:54 +0200 Medalha recebida  Taxonomista
2013-03-31 08:28:54 +0200 Perguntou Finding words and numbers in multiple columns

About a year ago I asked this question with success. Now I'm trying to find when a word and number are in the same row but different columns, such as with "racecar" and "1". SUMPRODUCT doesn't work with numbers.

2013-03-31 08:21:32 +0200 Resposta comentada COUNTIF used finding words in multiple columns

Is there a way to do this with number AND letters? Such as "1" replacing "shoe".

2012-07-28 15:31:49 +0200 Medalha recebida  Pergunta famosa (fonte)
2012-07-24 19:17:54 +0200 Medalha recebida  Pergunta famosa (fonte)
2012-05-29 02:31:34 +0200 Medalha recebida  Pergunta notável (fonte)
2012-05-07 23:28:36 +0200 Medalha recebida  Pergunta notável (fonte)
2012-05-01 20:53:46 +0200 Medalha recebida  Pergunta popular (fonte)
2012-04-19 17:26:52 +0200 Medalha recebida  Pergunta popular (fonte)
2012-04-01 23:11:46 +0200 Resposta comentada COUNTIF used finding words in multiple columns

Perfect. Thanks!

2012-04-01 19:55:13 +0200 Perguntou COUNTIF used finding words in multiple columns

I'm basically trying to find the condition when "racecar" and "shoe" are both in the same row, but in two different columns. Most of my searching has brought me to similar questions for Open Office, but with solutions that don't appear to work.

I get Error 502 for this formula:

=COUNTIF((H2:H118,"racecar")*(I2:I118,"shoe"))

SUMPRODUCT has also been recommended, but I don't think that's what I'm looking for.

2012-03-27 07:25:12 +0200 Medalha recebida  Estudante (fonte)
2012-03-27 02:10:14 +0200 Medalha recebida  Acadêmico (fonte)
2012-03-27 02:10:07 +0200 Resposta comentada Finding word frequency in Calc

I see. I know what I'll be do now. Thanks. :)

2012-03-27 01:33:14 +0200 Resposta comentada Finding word frequency in Calc

I think I understand what you're saying, but I still feel uncertain. Do you need a second column or can it just be a second cell with IF and FIND? I did get FIND("shoe",G3) to work this time. Not sure what I did wrong before.

2012-03-27 01:22:10 +0200 Resposta comentada Finding word frequency in Calc

Was that supposed to remove all but the first word? It would be better to have all the words meshed together.

2012-03-27 00:55:50 +0200 Resposta comentada Finding word frequency in Calc

If that's the only way I can get it to work I guess I'll be removing spaces from each cell.

2012-03-27 00:13:28 +0200 Resposta comentada Finding word frequency in Calc

When I try =COUNTIF(G2:G118;"\s\h\o\e") no answer is given. All text are general expressions. Nothing happens with just =COUNTIF(G2:G118;"shoe") either.

2012-03-26 23:12:22 +0200 Resposta comentada Finding word frequency in Calc

To clarify, I have a column where each cell has two-to three words in it. Is there no way in Calc to search a column for how many times a word shows up? For example I want to look for "shoe" in cells G1 to G118. FIND("shoe",G3) doesn't work even though "shoe" is in G3.

2012-03-26 12:54:20 +0200 Perguntou Finding word frequency in Calc

Newbie here. I have a column of cells with text phrases in Calc I want to graph. First I want to show the frequency of appearance aka how often do "shoe", "toaster oven" and "race car" show up. I'd also like to make this information in percentages: what percentage of the cells have "shoe" in them.

There are more ideas I have of using the text phrases, but this would be a start.