Find several cells with same text but can't isolate them

Discuss the spreadsheet application

Find several cells with same text but can't isolate them

Postby jhoward1950 » Thu Jan 09, 2020 10:10 am

first. i am a 69 year old novice.
i have made a generic checkbook for my yearly expenditures for each month.
what i have been trying to do is find, in each month, the cells that have the same identifications
then isolate them from the other cells so it will be simpler to copy and paste to another sheet.
any help will be appreciated - jerry

i have attached my checkbook entries for each month of 2019.
each month there will be, for instance, lowes, ky farm burea, glen etc....
the data I want to extract from each row are the cells labeled date, check no, amount and who check was written to .
for the 12 months I would like to find lowes and highlight those while hiding the remaining info until I cut and paste the highlighted info. once cut and paste has removed the info then turn all other info back on and continue repeating the process until all lines are gone.

open office 4.1.1 in Windows 10.
Attachments
2020 January Checks.ods
2019 check summary spreadsheet
(122.5 KiB) Downloaded 21 times
open Office 4.1.1 on Windows 10
jhoward1950
 
Posts: 3
Joined: Tue Jan 07, 2020 11:34 pm

Re: i find several cells with same text but can't isolate th

Postby Lupp » Thu Jan 09, 2020 1:41 pm

Welcome to the forum!

This should be a task for filtering, in specific for the tool 'Autofilter', but...

I cannot find a column to reasonably apply a filter to. Should column G of the first sheet contain what you call "identifications"? If so:
-1- A column intended to be used this way must contain the appropriate "identifications" for every row to be evaluated.
-2- A column intended to be used this way must NOT contain anything else.
-3- The entries to be used as "identifications" need to be assured to be from a "stock" of allowed values. No similarities like "walmart" similar to walmartt" (See cell G1392.) can be accepted.

Generally your sheets seem not to be designed with a clear and reasonable structure in mind. You would need to rework them insofar.

(What about 'CurrentChecks'.BF2824? What about cell BF2019 same sheet? Where are the months you talked of accessible as data?)
On Windows 10: LibreOffice 7.0 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2929
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Find several cells with same text but can't isolate them

Postby jhoward1950 » Thu Jan 09, 2020 6:09 pm

Thanks for the reply.

i now have attached the correct file.
i am attempting to use this sheet to aide in preparing my 2020 budget by extracting data from the Check Identification
column.
this is what i am doing.
in my example i know i have written several checks to glen. for each month i find each check written to him and then select the row his data is in. once this row is selected i cut and paste it to the right of the original data. then i scroll down to the next check written to glen and use the same procedure described above until i cut and paste each check entry for the year. i know there must be a simpler way to isolate these checks to glen and cut a nd paste all with one selection.

i am working on a more detailed expense sheet for 2020.

as you can see what i want may be simple for many but is a challenge for me. i have parkinson's disease and it makes typing slow and difficult.

i will be grateful for any help or suggestions.
jerry
Attachments
2019 Expense Summary.ods
(34.71 KiB) Downloaded 22 times
open Office 4.1.1 on Windows 10
jhoward1950
 
Posts: 3
Joined: Tue Jan 07, 2020 11:34 pm

Re: Find several cells with same text but can't isolate them

Postby RPG » Thu Jan 09, 2020 9:29 pm

I think you must make a clean nice tabel and forget what you want do.
When you have a clean nice table then you can analyze your data real easy.
It is not a problem when in your table are data of several years. Maybe you have to insert a column but that is your problem

Your office program does have several tools for analyzing your data the best is maybe: pivottable.
In the help file there is a explanation and when you search this forum you can find also examples and explanations.

I clean up a little your table but I do understand it complete.

What you have to do is learning and not to much typing.
Attachments
2019 Expense SummaryRPG03.ods
Two pivot table
(67.93 KiB) Downloaded 22 times
LibreOffice 6.3.3.2 on openSUSE Leap 15
RPG
Volunteer
 
Posts: 2196
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Find several cells with same text but can't isolate them

Postby Lupp » Thu Jan 09, 2020 9:43 pm

Sorry. You ignored my comments above. I still cannot find data I could accept as the "identifications" you mentioned.
You won't get anywhere this way.

I also inserted some comments into the reworked document. See attachment.
Attachments
aoo100684kindOfFilterProblem_1.ods
(48.79 KiB) Downloaded 12 times
On Windows 10: LibreOffice 7.0 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2929
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Find several cells with same text but can't isolate them

Postby DiGro » Thu Jan 09, 2020 10:23 pm

Jerry,

welcome to the Forum.

As LUPP pointed out, your sheet is not really designed for this.

I took the liberty to adjust the sheet a bit so you can use it to sort to your needs (I hope :P )

In the attached sheet on tab 2019 you can filter with the little triangle next to NAME2 (or, if you know the ID, the little triangle next to ID)
Click the little triangle and a list will open. This will show you the names from your data.
Pick one and you will see the payments to that person.

Once ready, click the triangle again and choose ALL, or the next name or ID

Please check the list in N1 to M143 to check if I made the right assumptions as to the names I gave an ID to.
For instance: M8 to M11 mention a Cindy I gave the ID ID_0005 to. If that are different persons you should change their ID
to a new one. If it Is just one person, you should use only one name for her and not four. You then should change the names in your data until you have just the one Cindy left and then you could remove the 3 wrong Cindys from the list.

2020 January Checks-2019_1.ods
Adjusted sheets for filtering
(50.36 KiB) Downloaded 15 times
____________
DiGro

AOO 4.1.7 on Windows 10. Scanned with ZIGGO Safe Online (F-Secure)
User avatar
DiGro
 
Posts: 103
Joined: Mon Oct 08, 2007 1:31 am
Location: Hoorn NH, The Netherlands


Return to Calc

Who is online

Users browsing this forum: fiona87 and 21 guests