No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
 | In excel, what I am trying to do is list the number of occurrences of column B, based on the number from column A. Here is sample data: [B] A..........B[/B] 3..........40 5..........56 2..........23 .......... .......... .......... .......... Example output to column C would be: [B]C[/B] 40, 40, 40 56, 56, …  |
| | I have a database of all 5000 cities to compare against. What I am trying to do is extract only the exact city names from a string. For example, let's say column A in Excel contains these phrases: [LIST] [*]bankruptcy new haven [*]personal injury new york [*]personal injury new york … |
| | Hi! The program I am using is excel. What I am looking to do is alphabetize a string [I]within[/I] a cell. Note, I do not wish to alphabetize a column of words. Here is an example. Let's say cell A1 contains a string like so: "The Law Firm of Cohen … |