Look up question
I downloaded data from my bank in a csv file, saved it as a spreadsheet. I need to create a search / look up function so I can go through all that bank data and calculate my expenses at different places for different time frames.
The problem is that the data looks like this:
“WAL-MART #1234 01-01-01 NEW YORK NY 9876 DEBIT CARD PURCHASE-PIN”
Of course, I have multiple purchases at Walmart, and the description is a little different for each one.
How do I do a lookup function to capture all the Wal-mart purchases throughout a given timeframe?
Or is there a better way than the look up function?
Thanks.
|