Forum Discussion
HELP: ATTACHED SAMPLE DATA, RANDOM AT LEAST ONE OF THE TWO COLUMNS MATCH
Have an excel spreadsheet with over 50,000 rows, two worksheets, first one is called Transactions, second is called Branches which has the Transit Number, and Routing Number for all Branches in each...
Hi,
Can you please clarify this "if no City is matched up, just pull a city and then a Random branch from that City"? do you mean here is a Random City from the list?
As in your above dataset of Branche's worksheet, there is NO city called Victoria. How would you like the results to appear?
Regards, Faraz Shaikh,
Microsoft MVP, Excel Expert, MCT, MIE
- In the case of Victoria, there are 21 branches, but some of the smaller towns that were generated in the transactions do not have a listing in the branches, so once the Province matches, if no City is found, a random city/branch is pulled from the Province.
So an example is one of the transactions in British Columbia, Tumbler Ridge, does not have a branch in the town/city, so just want a random branch pulled where the Province is equal to British Columbia.
