Dear

**Jululian**
Thanks for your kind words! Your appreciation means a lot to us.

If you want the interval, for example,

**501 to 1000**,

**1001 to 1500**, and so on, you need to make some changes. Within the

**ISTEXT** function, first, you must modify

**ROW(1:21)** so that it iterates through rows 1 to 21 (it was

**1:4** previously). Next, add "

**500+1**" to get the intended intervals. Within the

**FREQUENCY** function, make adjustments likewise for rows but add "

**500+500**". So, get the point: adjustment will vary from the interval and dataset you use.

Don't worry! I have modified the previously given formula for your desired intervals. Please check the following:

- Select cell
**D2**.
- Insert the following formula:
- Hit
**Enter**.

View attachment 1406

Hopefully, these ideas will help you. Stay blessed.

Regards

**Lutfor Rahman Shimanto**

ExcelDemy