Hi I have to work on some sheets at work where I need to count the number of times a set of values happen between a range of data. e.g. I will be given a min of 0.04 and max of 0.10 and need to know how many times 0.04,0.05,0.06 etc appears within a range of data.
The min and max values I am given can change each time I have to do this, is there a way I could use a macro or something similar to automaticaly do this for me or atleast let me change from 0.04 to 0.05 etc without editing the formula manually. I hope this makes sense