Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have 4 columns of data
first column is a list of US cities second columns is the change in population from 1990 to 2000 for the cities in the first column third column is a list of US cities (not all the same cities as the first or in the same order) fourth column is the change in average income from 1990 to 2000 for the cities in the THIRD column. I want to turn the 3rd and 4th columns into a psuedo hash table so that I can match the cities in the first column with the third column, and then store them in cells corresponding in order to the first. Is it possible to match text this way in excel using functions and not having to write a VBA script? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
create a data entry form template in Excel 2003? | Excel Discussion (Misc queries) | |||
how do I create qif files from Excel for import into Quicken? | Excel Discussion (Misc queries) | |||
How to I create a pdf file from Word or Excel files | Excel Discussion (Misc queries) | |||
Is there a way to create a standard OHLC bar chart in Excel? | Charts and Charting in Excel |