Skip to main content
Solved

I would like to generate some columns and rows with even and odd numbers


sorinduru

Hello.

I have a next situation.

I own a list in Excel with the streets of a certain area of Romania (Bacau County)

I take the example this streets : AGUDULUI, ALBA IULIA and ALECU RUSSO

On AGUDULUI Street I have the even numbers from 2 to 10 on one side of the street and on the other side of the street are the odd numbers from 5 to 13.

Tabel 1.

Where:

MIN_EVEN – the lowest even number on the street

MAX_EVEN – the highest even number on the street

DCOUNT_EVEN – the number of even numbers appears on the street

MIN-ODD - the lowest odd number on the street

MAX_ODD – the highest odd number on the street

DCOUN_ODD- the number of odd numbers on the street

Tabel 2.

I would like to create some lines and columns (as I put in Table 2 – but may look different) and I wish to populate with the even numbers also with the odd numbers.

Thank you very much.

Sorin Duru

 

Best answer by takashi

Hi @sorinduru, this screenshot illustrates a possible way.

 

Result:

 

View original
Did this help you find an answer to your question?

3 replies

takashi
Contributor
Forum|alt.badge.img+19
  • Contributor
  • Best Answer
  • April 17, 2020

Hi @sorinduru, this screenshot illustrates a possible way.

 

Result:

 


Forum|alt.badge.img+2

@sorinduru If you can attach a small sample dataset it makes it easier for community members to experiment and present a possible solution.


sorinduru
  • Author
  • April 20, 2020
takashi wrote:

Hi @sorinduru, this screenshot illustrates a possible way.

 

Result:

 

Thank you very much!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings