Solved

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

Forum|Forum|5 years ago
April 17, 2020
3 replies
40 views

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:

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.