![]() |
how to create a psuedo hash in excel
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? |
All times are GMT +1. The time now is 11:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com