Hi everyone,
I'm working on a categorisation project for work and needed to know how to perform a specific action. I've identified a list of key words from invoice data, the spreadsheet we're working with also contains a general ledger account (GLA) for each invoice. I need to find a way to determine all possible combinations of key words and GLAs. Since there are 106 key words and 83 GLAs, there should be 8798 combinations of the two. Secondly, I need to be able to take each combination and count the number of times it occurs over the data sets. i.e. how many times does Keyword A + GLA B occur?
I'm guessing the output would be best displayed by a pivot table.
Thanks everyone,
Luca F
I'm working on a categorisation project for work and needed to know how to perform a specific action. I've identified a list of key words from invoice data, the spreadsheet we're working with also contains a general ledger account (GLA) for each invoice. I need to find a way to determine all possible combinations of key words and GLAs. Since there are 106 key words and 83 GLAs, there should be 8798 combinations of the two. Secondly, I need to be able to take each combination and count the number of times it occurs over the data sets. i.e. how many times does Keyword A + GLA B occur?
I'm guessing the output would be best displayed by a pivot table.
Thanks everyone,
Luca F
