From column A to B special formatting? and how to calculate

[nova_sweet]

Hi!

I have a question about the following sheet. Having a column A with numbers (that can change sometimes) and a column B where the numbers should be shown as a range (do not know if you call it that). The numbers in B should change depending on what the numers i A are.
Maybe best with an exampel:

How is it possible to show the range (from xxx to xxx) and how is can it be calculated?

Thankfully for all ideas.

Best regards!

 

[Special-K99]

If you're counting the numbers from 000-019 as 20
then

020-028 is 9 not 8
112-195 is 84 not 83

in B1 put 0

in C1 put
=SUM(A$1:A1)-1
and copy down the column

in B2
=C1+1
and copy down the column

Columns B & C are your output "from" and "to"

 

[FormR]

Hi, as per special-K99 I don't think you being consistent with the way you are deriving the start and end numbers in each range posting the full table of results might help to clarify.

Can you complete that example table with the rest of the results and paste directly in the thread?

 

[nova_sweet]

Ok. Yes. You are right. My bad. Very confusing the whole thing......

I typed in the numbers by hand just to give an impression how it should be. I do not have a mathematical formula behind this.

 

[Special-K99]

Please see my updated reply above using two columns as output

 

[nova_sweet]

Thank you. I am deeply impressed. It seems almost to easy to be true
But it looks exactly how I had in mind.
I will have to do some other work-stuff now, but will try this out more later on.
Thanks again!

Best regards,
Annika

 

[nova_sweet]

Hello again,

I have one more question: your suggestion works fine but how could I manage to show empty cells (B and C) in case A has the value 0?