質問する

stuarts.burgers's profile - activity

2019-09-15 13:12:35 +0200 バッジを受け取った  人気の質問 (source)
2019-09-11 10:38:06 +0200 質問をする Combining Columns In Calc

Combining Columns In Calc Hi I have a set of data and I need to combine some cells but not others, with the result of t

2019-09-05 10:08:00 +0200 バッジを受け取った  卓越した質問 (source)
2019-05-11 07:42:32 +0200 バッジを受け取った  卓越した質問 (source)
2019-05-11 05:48:21 +0200 編集された質問 Aligning two lists in Calc problem fixed by Gilberto

Aligning two lists in Calc Hi, I have two lists from different sources that I need to make sure that the contents of the

2019-05-11 05:47:11 +0200 ベストアンサーマーク Aligning two lists in Calc problem fixed by Gilberto

Hi, I have two lists from different sources that I need to make sure that the contents of the lists are positioned in the same place within their cell. C:\fakepath\street names.ods

In the above example, I need the contents "Green Cells" to be positioned in exactly the same position within their cell as the contents of the "Yellow Cells".

I have attempted to add or subtract spaces but to no avail.

What I am attempting to do is use Matching formula "=MATCH(E2&D2,$'Mailman''s Route'.A$1:A$538&$'Mailman''s Route'.B$1:B$538,0)" where the "Green Cells" are E and the "Yellow Cells" are $'Mailman's Route' .A$1:A$538.

The other part of formula works, if I cut and paste from "E" into "A$" and I can get a Match to work without doing anything to the "D" and "B$" cells.

The Yellow List is taken from a database and arrives to me an Excel Sheet that I open in Libre Calc

As I have 16 Green List and up to 33 Yellow Lists per Green Lists I really need to automate.

I have done the cut and past thing as a workaround but I would like to automate the process as I do not have the time to do cutting and pasting.

Thanks Stuart

2019-05-11 05:43:23 +0200 コメント付き回答 Aligning two lists in Calc problem fixed by Gilberto

Giberto Thank you it works brilliantly, thank you for your input and wisdom, you have just saved me a huge amount of tim

2019-05-10 19:01:16 +0200 バッジを受け取った  人気の質問 (source)
2019-05-10 09:13:00 +0200 編集された質問 Aligning two lists in Calc problem fixed by Gilberto

Aligning two lists in Calac Hi, I have two lists from different sources that I need to make sure that the contents of th

2019-05-10 09:12:20 +0200 質問をする Aligning two lists in Calc problem fixed by Gilberto

Aligning two lists in Calac Hi, I have two lists from different sources that I need to make sure that the contents of th

2019-04-20 22:30:18 +0200 コメント付き質問 Problem with =Match in Libre Calc

Thanks I had a further look and found that f there was three parts to a street name ie "Old Mill Road" there is two spa

2019-04-20 14:29:17 +0200 バッジを受け取った  人気の質問 (source)
2019-04-20 02:46:45 +0200 質問をする Problem with =Match in Libre Calc

Problem with =Match in Libre Calc I am using the formula "=MATCH(E2&D2,'Mailman''s Route'.A$2:A$500&'Mailman''s

2019-02-09 22:31:56 +0200 バッジを受け取った  有名な質問 (source)
2018-11-16 00:09:03 +0200 バッジを受け取った  卓越した質問 (source)
2018-08-06 16:42:05 +0200 バッジを受け取った  卓越した質問 (source)
2018-07-14 11:27:52 +0200 バッジを受け取った  人気の質問 (source)
2018-07-14 03:32:17 +0200 コメント付き質問 Automatic movement of data between cells and removal of duplicate cells

For the other Household options, this would not be an issue as C3 would not equal C2 or A3 would not equal A2.

2018-07-14 03:31:50 +0200 コメント付き質問 Automatic movement of data between cells and removal of duplicate cells

Looking at Families Raw.ods my thoughts were If C3=C2 and A3=A2 then copy A2 to B2 and replace A2 contents with "Famil

2018-07-14 03:29:34 +0200 コメント付き質問 Automatic movement of data between cells and removal of duplicate cells

Looking at Families Raw.ods my thoughts were If C3=C2 and A3=A2 then copy A2 to B2 and replace A2 contents with "Famil

2018-07-14 03:08:17 +0200 コメント付き質問 Automatic movement of data between cells and removal of duplicate cells

Sorry, the Number in the above examples is the street or house number for each house, not the elector number.

2018-07-14 03:08:17 +0200 バッジを受け取った  解説者
2018-07-14 03:03:45 +0200 コメント付き質問 Automatic movement of data between cells and removal of duplicate cells

We are on a very tight Budget and if we can halve the number of letters going out as in the above example we can do more

2018-07-14 03:00:34 +0200 コメント付き質問 Automatic movement of data between cells and removal of duplicate cells

Thanks for your help, The list of names and address is taken from an electoral roll that is given to an Election Candida

2018-07-13 23:32:30 +0200 編集された質問 Automatic movement of data between cells and removal of duplicate cells

Automatic movement od data between cells and removal of duplicate cells Hi, I know what I would like to automate but di

2018-07-13 22:51:33 +0200 編集された質問 Automatic movement of data between cells and removal of duplicate cells

Automatic movement od data between cells and removal of duplicate cells Hi, I know what I would like to automate but di

2018-07-13 22:49:47 +0200 質問をする Automatic movement of data between cells and removal of duplicate cells

Automatic movement od data between cells and removal of duplicate cells Hi, I know what I would like to automate but di

2018-07-06 08:01:45 +0200 バッジを受け取った  人気の質問 (source)
2018-06-06 18:29:15 +0200 バッジを受け取った  卓越した質問 (source)
2018-06-05 20:14:27 +0200 ベストアンサーマーク Ordering Results from a Filter in Calac or in Base

I have a dataset in a Calc Sheet. I want to be able to filter so that I get the results in a very specific order. What I have is Street Addresses and I have a "Mailman's Route". What I want to do is to filter or in some way order the Street Addresses so that they follow the " Mailman's Route" Included in the data set I have is the names of householders and what I am attempting to set up is a Spreadsheet to run through a Mail Merge program so that we create Addressed communication to the Householders. As the "letters" are produced they are done in delivery order ie up one side of a cul de sac and down the other. The Cul de Sac I can deal with it is the Street that the Cul de Sac runs off is the problem. I need to insert the Cul de Sac at the point on the spreadsheet so as you have a letter for the last house before the junction, then letters for the Cul de Sac, then a letter for the first house after the junction.

I know that it is possible as I have in the past used software to do it but I now no longer have access to this program.

Can some nice person help? I have attempted to use advanced filters in Calc but the result just creates a list in alphabetical order and groups all of one streets addresses together

Further to Jim K's comment here are the files that I mentioned below along with the Mailman's Route

C:\fakepath\After Advance Filtering.ods

C:\fakepath\DESIRED RESULT.ods

C:\fakepath\MAILMAN'S ROUTE.odt

I hope that this adds clarity. I have removed a lot of extra information from the spreadsheets as it is not related to my query.

2018-06-05 20:09:49 +0200 コメント付き回答 Ordering Results from a Filter in Calac or in Base

Thank you. Now I need to put some time aside to get my head around this, also I need the time to create the 400 Mailman

2018-06-05 13:30:41 +0200 バッジを受け取った  人気の質問 (source)
2018-06-05 09:35:30 +0200 コメント付き質問 Ordering Results from a Filter in Calac or in Base

Hi, Jim thanks for your pointers I have created a couple of spreadsheets that show where I start and what I would like

2018-06-05 09:34:29 +0200 編集された質問 Ordering Results from a Filter in Calac or in Base

Ordering Results from a Filter in Calac or in Base I have a dataset in a Calc Sheet. I want to be able to filter so that

2018-06-05 09:17:04 +0200 コメント付き質問 Ordering Results from a Filter in Calac or in Base

Hi, Jim thanks for your pointers I have created a couple of spreadsheets that show where I start and what I would like

2018-06-05 09:05:08 +0200 コメント付き質問 Ordering Results from a Filter in Calac or in Base

Hi, Jim thanks for your pointers I have created a couple of spreadsheets that show where I start and what I would like

2018-06-04 00:14:02 +0200 質問をする Ordering Results from a Filter in Calac or in Base

Ordering Results from a Filter in Calac or in Base I have a dataset in a Calc Sheet. I want to be able to filter so that

2018-06-04 00:00:04 +0200 バッジを受け取った  熱心な人
2018-06-03 07:00:53 +0200 コメント付き回答 Adding Filters Together

Hi Thanks for your help, I have in the past used a system that would allow me to do what I need but I no longer have acc

2018-06-02 21:36:08 +0200 コメント付き回答 Adding Filters Together

Hi Thanks for the tips and the video link I have things working but I now have a further problem, The report I get is in

2018-06-02 21:33:33 +0200 コメント付き回答 Adding Filters Together

Hi Thanks for the tips and the video link I have things working but I now have a further problem, The report I get is in

2018-06-02 04:10:50 +0200 コメント付き回答 Adding Filters Together

I then highlight all 11 rows Click on Data More Filters Advanced Filter then I get a popup which I guess I need to put

2018-06-02 04:00:44 +0200 コメント付き回答 Adding Filters Together

Thanks for your help This old brain does not function as well as younger ones, most of the team looked at me a bit stra

2018-06-02 00:56:32 +0200 ベストアンサーマーク I need to split a column of numbers into odd or even

I have a column of number such as 1 2 2 3 5 5 6 7 7 7 7 9 9 10 10 11 11 15 15 15 16 17 17 and I wish to sort them into odds and evens but I can not get started help does not give me the answer I need, I am sure that it is a very easy task but getting my 62 year old brain around it is just not happening.

Thanks Stuart

2018-06-02 00:55:40 +0200 バッジを受け取った  有名な質問 (source)
2018-06-02 00:55:40 +0200 バッジを受け取った  卓越した質問 (source)