Start digging out the car. Depending on your personal strength, the amount of snow piled up on a car, and the temperature, this task can take anywhere from 5 minutes to an hour. It will be much faster if you can get a helper or two on the job.
Select the input range and the bin range. The input range is the range of cells that contain data. If your input data is a set of ten numbers, and you have copied it into the A column (from A1 to A10), then enter your data range as A1:A10. The bin range is the range of cells that contain your bin numbers.
Do not type these yourself. They will disappear when you edit the formula. Explanation: The range (array constant) is stored in Excel's memory, not in an range. This array constant is used as an argument for the MAX function, giving a result of 63. F9 Key. When working with array formulas, you can have a look at these array constants yourself. 1. Select C2:C6-B2:B6 in the formula.