I have 14,000 rows of dollar amounts, in Sheet 1 column A, in Sheet 2 i have
groupings set up in $5,000 increments (similarly to frequency array set up).
Grouping column
4999
9999
14999
In Sheet 1 Colum B, i'd like to put a formula that will compare dollar
amount to grouping, fill grouping label in column B. I could set up Sheet 2
with 2 columns;
0 4999
5000 9999
10000 14999
to try and use some 'between' formula which i've yet to find.
End result
$6,869 9999

I must admit, this one has me stumped. Hope someone can assist. Thanks!