Thanks Pecoflyer but I didn't explain myself. I'm actually looking some data validation on the amount entered.



Basically I need numbers entered categorised into bands. So if people type in a number between 0 and 300 say I want in the next column text to appear as 0-300 if they type in 345 I want 301-600 to appear - this is so that when I do a pivot I can show the total of 0-300

I know I could do this in pivot tables but I need specific bands to appear not automated ones based on the range of results.