Ok, I have a small project that I need to do, and I can't figure out a function that can help me.
I have a database of about 15,000 records, and in this data is a Column called Square Meters. Next to this column is another called Alottment. I need to be able to put in the Alottment column the number of allotments based on the range that is in the Square meters column. So for example, A2 = 20, I need to be able to analyze that and put "5" in the Allotments field.
The following is my range. I could go through and do this by hand, but on 15,000 records, that would be a little mundane and time consuming. Is this something I can create with a function, or do I need to brush up on my VB skills and do it through VBA.
Range = # of allotments
12 - 23 = 5
24 - 35 = 10
36 - 47 = 15
48 - 59 = 20
60 - 71 = 25
72 - 83 = 30
84 and up = 35
Any help/guidance would be greatly appreciated.
Bookmarks