• 410K Members
• 7,075 Online
• 466K Conversations

## help with excel

Occasional Visitor

# help with excel

can someone tell me what formula to use to create a range of numbers the continues from the last range based on the number used to the left of it? attached is a image of what I am hoping to do. the yellow box is the number I want to the range to start with. the red box is how big the range should be. the green box is the range. I put a few examples of what I am looking for below. Thank you!

2 Replies

# Re: help with excel

Hi

Take a look at the attached file. I couldn't tell from the image which columns you were using.

I put the stat value in cell C2 and in cell D5 entered the following formula and copied down

=IF(C5="","",\$C\$2+SUM(C\$4:\$C4)&"-"&\$C\$2+SUM(C\$5:\$C5)-1)

# Re: help with excel

If the StartNumber is in B1, try this formula in C3, copied down rows:
=SUM(B\$1:B2)&
“-“&
SUM(B\$1:B3,-1)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies