This is probably a really easy request, but my mind has gone blank.
I have over 10,000 rows of data in column A which are brand names. In column B I have the corresponding invoice prices.
What I am trying to do is collate this information into a simple table that tells me how many of each brand goes into which pricing bracket
Can anyone please help
I have over 10,000 rows of data in column A which are brand names. In column B I have the corresponding invoice prices.
What I am trying to do is collate this information into a simple table that tells me how many of each brand goes into which pricing bracket
Can anyone please help
| Brand | £0-£10,000 | £10,001 - £15,000 | £15,001 - £25,000 | £25,001 - £40,000 | £40,001 - £75,000 | £75,001 - £100,000 | £100,001 - £140,000 | £140,001 - £180,000 | £180K + |
| Brand One | |||||||||
| Brand Two | |||||||||
| Brand Three | |||||||||
| Brand Four |
