Select cells in particular sequence

Discuss the spreadsheet application

Select cells in particular sequence

Postby Osmario » Mon Jul 15, 2019 1:44 pm

Hi

A1 2
A2 17
A3 21
A4 4
A5 98
A6 12
A7 44
A8 22
A9 115
A10 39

When I have to select 5 (five) cells and the first one is A8 (22) my select begins at A8 and must to finish at A2 (17).
How can I make a formula that restart from begining?
Thanks in advance
OpenOffice 2.4 on Ubuntu 9.04
Osmario
 
Posts: 2
Joined: Sun Jul 14, 2019 4:09 pm

Re: Select cells in particular sequence

Postby RusselB » Mon Jul 15, 2019 3:38 pm

Welcome to the Forums.
Generally speaking the order in which a range of cells is selected has no bearing on how the data in that range is handled.
Example: Selecting the cells from A8 to A2 and then summing the relevant values is no different from selecting the cells from A2 to A8 and then summing.
In fact, I can't think of a single function where the specific order of the range is relevant.
Can you please explain why it is necessary for the range to be selected as you have specified?
or am I misunderstanding your question? If this, please try to explain what it is you are trying to accomplish
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5288
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Select cells in particular sequence

Postby Osmario » Mon Jul 15, 2019 4:05 pm

Thanks for your answer.
I was enough clear, sorry.
I need count, not select. If I have a large range, for instance, with 800 cells in a column.

Bert regards
OpenOffice 2.4 on Ubuntu 9.04
Osmario
 
Posts: 2
Joined: Sun Jul 14, 2019 4:09 pm

Re: Select cells in particular sequence

Postby RusselB » Mon Jul 15, 2019 4:44 pm

The COUNT function also does not care the order of the cells in the range.
In fact I can't think of a single spreadsheet function where the order of the range matters.
Counting in sequences of 5, restarting at the next entry for 800 entries is going to be the same count as counting the 800 all at once.
Again, if you can explain what it is you are wanting in the long run, we might be able to save you time from asking for help at each step.
If you do need to count through a looping progression, then a macro is needed.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5288
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests