I need an excel expert
Budget: £10 – £20 GBP
From the 'TOTAL SPEND' tab, I need to organise data into 3 categories - High, Medium, and Low.
It needs to be a table that shows the supplier Name in one of the above three categories
Low = 10,000 or less
Medium = between 10,001 and 49,999
High = 50,000 and above
Ideally a formula set up so any new supplier added will automatically appear in the table in the relevant column
It needs to be a table that shows the supplier Name in one of the above three categories
Low = 10,000 or less
Medium = between 10,001 and 49,999
High = 50,000 and above
Ideally a formula set up so any new supplier added will automatically appear in the table in the relevant column