L
Legacy 479770
Guest
Hello I was hoping that some can help me. I have a tabular data for frameworks that shows a large number of suppliers split by value band and region. The values (approx 48) are text strings for instance: £50m+, £50k-£15m, £250K-£5m; 0 - £3m
1. I am trying first to assign them to the following bands, £1m – £2m; £2m – £3m; £3m – £4m; £4m - £5m; £5m - £10m; £10m – £15m; £15m – £20m; £20m – £30m; £30+
2. Then I want to be able to create a searchable dynamic list and pull out all information by searching for a specific band for instance £1m-£2m it should bring up all framworks and suppliers within that range, so from bands: £50k-£15m, £250K-£5m, but in the same time if £4m - £5m is selected it will also include. £50k-£15m, £250K-£5m
Could someone help please?
Thank you. Kasia
1. I am trying first to assign them to the following bands, £1m – £2m; £2m – £3m; £3m – £4m; £4m - £5m; £5m - £10m; £10m – £15m; £15m – £20m; £20m – £30m; £30+
2. Then I want to be able to create a searchable dynamic list and pull out all information by searching for a specific band for instance £1m-£2m it should bring up all framworks and suppliers within that range, so from bands: £50k-£15m, £250K-£5m, but in the same time if £4m - £5m is selected it will also include. £50k-£15m, £250K-£5m
Could someone help please?
Thank you. Kasia