Home

help with excel

%3CLINGO-SUB%20id%3D%22lingo-sub-756983%22%20slang%3D%22en-US%22%3Ehelp%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756983%22%20slang%3D%22en-US%22%3E%3CP%3Ecan%20someone%20tell%20me%20what%20formula%20to%20use%20to%20create%20a%20range%20of%20numbers%20the%20continues%20from%20the%20last%20range%20based%20on%20the%20number%20used%20to%20the%20left%20of%20it%3F%20attached%20is%20a%20image%20of%20what%20I%20am%20hoping%20to%20do.%20the%20yellow%20box%20is%20the%20number%20I%20want%20to%20the%20range%20to%20start%20with.%20the%20red%20box%20is%20how%20big%20the%20range%20should%20be.%20the%20green%20box%20is%20the%20range.%20I%20put%20a%20few%20examples%20of%20what%20I%20am%20looking%20for%20below.%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-756983%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-757063%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-757063%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377111%22%20target%3D%22_blank%22%3E%40ancrane%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3ETake%20a%20look%20at%20the%20attached%20file.%20I%20couldn't%20tell%20from%20the%20image%20which%20columns%20you%20were%20using.%3C%2FP%3E%3CP%3EI%20put%20the%20stat%20value%20in%20cell%20C2%20and%20in%20cell%20D5%20entered%20the%20following%20formula%20and%20copied%20down%3C%2FP%3E%3CP%3E%3DIF(C5%3D%22%22%2C%22%22%2C%24C%242%2BSUM(C%244%3A%24C4)%26amp%3B%22-%22%26amp%3B%24C%242%2BSUM(C%245%3A%24C5)-1)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-757333%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-757333%22%20slang%3D%22en-US%22%3EIf%20the%20StartNumber%20is%20in%20B1%2C%20try%20this%20formula%20in%20C3%2C%20copied%20down%20rows%3A%3CBR%20%2F%3E%3DSUM(B%241%3AB2)%26amp%3B%3CBR%20%2F%3E%E2%80%9C-%E2%80%9C%26amp%3B%3CBR%20%2F%3ESUM(B%241%3AB3%2C-1)%3C%2FLINGO-BODY%3E
ancrane
Occasional Visitor

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

@ancrane 

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)

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