Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem in finding words into cells of a column
My formula can find only the word cremona into from cell D2 to cell
D100. can you help me please ? --------------CUTHERE---------------- =IF(FIND("cremona";D2)0;"Cremona";IF(FIND("spatoc co";D2)0;"spatocco";IF(FIND("magliano";D2)0;"mag liano";IF(FIND("desenzano";D2)0;"desenzano";IF(FI ND("aosta";D2)0;"aosta";IF(FIND("ascoli";D2)0;"a scoli";IF(FIND("amandola";D2)0;"amandola";""))))) )) --------------CUTHERE---------------- thank you very much Claudio |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem in finding words into cells of a column
Are you trying to count the number of times cremona etc appears, or to put the word cremona in another cell, or to highlight the cell? Is your data single town names , or town names inside a set of other words? -- bob777 ------------------------------------------------------------------------ bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504 View this thread: http://www.excelforum.com/showthread...hreadid=504864 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem in finding words into cells of a column
Perhaps try replacing FIND with SEARCH in your formula.
FIND is case-sensitive while SEARCH is not Another way to try .. Let's say the names: Cremona, Spatacco, etc are listed down in X1:X20 Then we could put in say, E2's formula bar and array-enter the formula (i.e. press CTRL+SHIFT+ENTER): =IF(D2="","",INDEX($K$1:$K$20,MATCH(1,ISNUMBER(SEA RCH($K$1:$K$20,D2))*($K$1: $K$20<""),0))) and copy E2 down as far as required This may accomplish the same results in a slightly neater way (if I've read your intent correctly) Note: You'd need to change the commas in the formula to semicolons ";" to suit your Excel language -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Claudio P." wrote in message oups.com... My formula can find only the word cremona into from cell D2 to cell D100. can you help me please ? --------------CUTHERE---------------- =IF(FIND("cremona";D2)0;"Cremona";IF(FIND("spatoc co";D2)0;"spatocco";IF(FI ND("magliano";D2)0;"magliano";IF(FIND("desenzano" ;D2)0;"desenzano";IF(FIND ("aosta";D2)0;"aosta";IF(FIND("ascoli";D2)0;"asc oli";IF(FIND("amandola";D2 )0;"amandola";""))))))) --------------CUTHERE---------------- thank you very much Claudio |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem in finding words into cells of a column
Typo in the line, sorry:
... the names: Cremona, Spatacco, etc are listed down in X1:X20 The names are assumed in K1:K20 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
Count cells based on date range in another column | New Users to Excel | |||
Comparing Cells and Displaying Data | Excel Worksheet Functions |