Hi all
Can you help with this?
I have various locations within our company structure, and various company credit cards at each location. Each location could have a different number of card numbers assigned to it. Lets say column A has the locations, and column B has the card numbers. Column A may look like this:
Location 1
Location 1
Location 1
Location 2
Location 3
Location 3
Column B contains a list of 16 digit credit card numbers.
I need to be able to list all cards assigned to Location 3, for example. As Im sure you're aware, VLOOKUP is only giving me the 1st entry for Location 3
Any clever ideas greatly appreciated.
Many thanks
OS Win 98 Excel 2000
Can you help with this?
I have various locations within our company structure, and various company credit cards at each location. Each location could have a different number of card numbers assigned to it. Lets say column A has the locations, and column B has the card numbers. Column A may look like this:
Location 1
Location 1
Location 1
Location 2
Location 3
Location 3
Column B contains a list of 16 digit credit card numbers.
I need to be able to list all cards assigned to Location 3, for example. As Im sure you're aware, VLOOKUP is only giving me the 1st entry for Location 3
Any clever ideas greatly appreciated.
Many thanks
OS Win 98 Excel 2000