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