Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding a particular text
I have two sets of data, one column containing the whole address and one
containing only the city names. I need to arrange the data as per the city names. Can i do it in Excel? I kinda tried using the Find( ) command like isnumber(find(text),,) but it only works for a cell and not for an array. Can anyone help?? |
#2
|
|||
|
|||
So you have 2 separete columns, one with the city name already extracted and
matching to the corresponding address on every row? If this is the case you can do a Data-Sort and just sort on the city name column. Excel will copy the respective address record to correspond to the sort. -- Regards, Dave "Animesh" wrote: I have two sets of data, one column containing the whole address and one containing only the city names. I need to arrange the data as per the city names. Can i do it in Excel? I kinda tried using the Find( ) command like isnumber(find(text),,) but it only works for a cell and not for an array. Can anyone help?? |
#3
|
|||
|
|||
Can you simply sort on the column that contains the city name?
|
#4
|
|||
|
|||
....Sorry forgot to add make sure BOTH the city name and address column are
selected before you do the sort. -- Regards, Dave "DaveB" wrote: So you have 2 separete columns, one with the city name already extracted and matching to the corresponding address on every row? If this is the case you can do a Data-Sort and just sort on the city name column. Excel will copy the respective address record to correspond to the sort. -- Regards, Dave "Animesh" wrote: I have two sets of data, one column containing the whole address and one containing only the city names. I need to arrange the data as per the city names. Can i do it in Excel? I kinda tried using the Find( ) command like isnumber(find(text),,) but it only works for a cell and not for an array. Can anyone help?? |
#5
|
|||
|
|||
the city names are not an extract of the addresses at all...they are two
totally different sets of data but the address data could contain the city name and in all probability shall contain it. I want to check whether the address data has that city name and if so align it accordingly "DaveB" wrote: ...Sorry forgot to add make sure BOTH the city name and address column are selected before you do the sort. -- Regards, Dave "DaveB" wrote: So you have 2 separete columns, one with the city name already extracted and matching to the corresponding address on every row? If this is the case you can do a Data-Sort and just sort on the city name column. Excel will copy the respective address record to correspond to the sort. -- Regards, Dave "Animesh" wrote: I have two sets of data, one column containing the whole address and one containing only the city names. I need to arrange the data as per the city names. Can i do it in Excel? I kinda tried using the Find( ) command like isnumber(find(text),,) but it only works for a cell and not for an array. Can anyone help?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Improvements for text finding functions | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Finding Specific Text in a Text String | Excel Worksheet Functions | |||
Finding the mode of text | Excel Discussion (Misc queries) | |||
Finding Partial Text in a Cell | Excel Worksheet Functions |