Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to Group Numbers at Uneven Intervals in Excel

There are times when we are required to group numbers into intervals of unequal sizes. To do this, we need to understand how to use the LOOKUP function in excel. This article provides a clear guide on how to group numbers at uneven intervals in excel.

Figure 1: How to group numbers at uneven intervals

General syntax of the formula

=LOOKUP(value, intervals, groups)

Explanation of the formula

The LOOKUP function plays a fundamental role in helping us group at uneven intervals. In the example above, the groups are in column C.

The formula in cells C2 is =LOOKUP(B2,D5:D8,E5:E8)

Understanding how the formula works

  • The function is configured in a way that allows it to lookup values in the ranges supplied. In our example above, the function is configured as follows;
  • The lookup values are ages found in column B.
  • The lookup vector is the named range “age”, D5:D8
  • Result vector is names as “group” which is E5:E8
  • The above setup allows the LOOKUP function to perform an appropriate match in the numeric values in the column D. it then returns the values associated to it from column E.

Things to note

  • LOOKUP function will return a corresponding group is it finds an exact match in the age column,
  • In the event that the function does not find an exact match, it will traverse the age column until it finds a larger value.
  • The function will return the largest value which is associated with the 50+
  • The LOOKUP function returns an #N/A error in the event age is less than the smallest value in the age column.
  • For this function to work appropriately, the ages must appear in an ascending order.

Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Solution examples
Hi, my VLOOKUP isn't working. No matter what I do it is returning the same result regardless of the sku it is searching for - even if I copy and paste the sky into the sheet the exact same way it is typed in the sheet its searching
Solved by X. H. in 20 mins
I can't make VLOOKUP work. I have 2 columns. Column A with a complete 11 digit NDC number, Column B contains a 9 digit NDC with the right 2 digits removed. I'm trying to populate column C with the full 11 digit number from column A based on a partial match with column B.
Solved by M. A. in 17 mins
In cells F6:F13, add a VLOOKUP function that returns the raise recommendationâ??High, Standard, or Lowâ??for each employee by exactly matching the Name in column A in the range you named Evaluations. Be sure to use exact match criteria. In cells G6:G13, add a VLOOKUP function that returns the starting raise percentage based on the ranges in the Standard Raise table in cells A16:B19 and the number of years employed in column E.
Solved by X. J. in 20 mins
Use the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range E5:N8). Be sure to use appropriate relative and absolute cell references. Hint: You will need to use a function within the HLOOKUP function to determine the appropriate row.
Solved by X. C. in 12 mins
i want to hide a column but still use it in formula. is this even possible?
Solved by X. E. in 11 mins

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc