Hello,I am trying to figure out a way to create one big master list that lists all of the accounts within the given range.
I have about 1000 rows with different variation of ranges (1st example below) and for each range listed below, I need to list each account within that range in column D and then getting it to do the same for each different range. For example, for my example below, the 1st range is from 70000 to 71000, I want to list all accounts within that range in column D (including the beginning and ending account rage). So for the 1st range, I should ultimately have 1000 rows and continue on for every range there after. If the range is 70000 to 70001 then it would list two object accounts and so on. I think you guys get the point.
At the end I would end up with four columns like in the second example below and will have thousands of rows for the different ranges.
I started doing this manually and trying some IF scenarios, but I haven't been successful and this would obviously take me forever to do it manually.
Any help is greatly appreciated. I did look around and I didn't quite find something that would help me with this, so thanks in advance for your help!!
<tbody>
</tbody>
I have about 1000 rows with different variation of ranges (1st example below) and for each range listed below, I need to list each account within that range in column D and then getting it to do the same for each different range. For example, for my example below, the 1st range is from 70000 to 71000, I want to list all accounts within that range in column D (including the beginning and ending account rage). So for the 1st range, I should ultimately have 1000 rows and continue on for every range there after. If the range is 70000 to 70001 then it would list two object accounts and so on. I think you guys get the point.
At the end I would end up with four columns like in the second example below and will have thousands of rows for the different ranges.
I started doing this manually and trying some IF scenarios, but I haven't been successful and this would obviously take me forever to do it manually.
Any help is greatly appreciated. I did look around and I didn't quite find something that would help me with this, so thanks in advance for your help!!
Key (Col A) | Account From (Col B) | Account To (Col C) | ||
70000 :71000 | 70000 | 71000 | ||
<tbody> </tbody> | 72000 | 74000 | ||
72000 :74900 | 72000 | 74900 | ||
Key (A) | Account From (B) | Account To (C) | List Each Account (D) | |
70000 :71000 | 70000 | 71000 | 70000 | |
70000 :71000 | 70000 | 71000 | 70001 | |
70000 :71000 | 70000 | 71000 | 70002 | |
70000 :71000 | 70000 | 71000 | 70003 | |
70000 :71000 | 70000 | 71000 | 70004 | |
70000 :71000 | 70000 | 71000 | 70005 | |
70000 :71000 | 70000 | 71000 | 70006 | |
70000 :71000 | 70000 | 71000 | 70007 | |
70000 :71000 | 70000 | 71000 | 70008 |
<tbody>
</tbody>