•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need better way to organise spreadsheet
Our take
Are you looking for a more efficient way to organize your spreadsheet for tracking football stadium visits? The challenge of managing duplicate entries, like multiple visits to Anfield, can clutter your data and hinder your experience. Imagine a streamlined approach where each stadium appears only once, yet still provides easy access to all your visits. This not only simplifies your records but also prepares you for adding more stadiums in the future. Let’s explore innovative solutions to enhance your data management and improve your productivity.
I am currently keeping track of visiting football stadiums (often called the 72 or the 92)
as you can see on the attached image, the shear amount of anfield visits leads to many duplicate entries and am wondering if anyone has a suggestion on tidying this up, so that anfield appears once, but perhaps links through so that i can see all visits
there will also likely be more stadiums in the future that will have multiple duplicates.
*several columns to the right cropped off because of personal data.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Any way to automate removal of older rows of data?I have a spreadsheet with 4 columns: first name, last name, score and date. I have people who are duplicated, some with the same date which I can easily remove with "remove duplicates" but I have examples where there are people with multiple rows from where they have taken a test a few years later, and i am trying to find a way to optimise my chopping up of this spreadsheet to only have a single row per user, and showing only their most recent score for the test. The date column is dd/mm/yyyy and then a 24 hour format time stamp and I can't think of a good way to optimise that as it covers multiple years. Theres no good consistency over the old date and the most recent date I imagine excel has some way of pruning older data. Atleast I hope so or ill have to check 50000+ rows manually to remove old results 😭 submitted by /u/Skellyhell2 [link] [comments]
- Slow spreadsheet - need troubleshootingHi, I have a spreadsheet that has two tabs, one is essentially the original data which is YTD driven for a particular GL account, the company has smaller amounts of transactions, so by December we are talking about maybe 3-5k rows of transactions for the account total. The main tab being utilized, has about 30 columns of look up and sumifs formulas referencing the source data and in total approx maybe 500 rows by year end? To me it doesn’t seem excessive. I’ve dealt with way heavier spreadsheets that have more omph and run faster. But for some reason this one is slow as all hell to work in. I’ve even tried barcoded some data and not seen any improvement. I’m not too techy into what else could be slowing it down. And ideas on what to troubleshoot from here? submitted by /u/SlideTemporary1526 [link] [comments]
- join content from cells in a column without losing content from the corresponding columns.basically how do i make the highlighted screenshot look like the unhighlighted one but with a function for a spreadsheet with like 170k rows. sorry that this is in sheets. im trying to figure out if what i need is to buy excel basically what i want is to condense duplicative info while listing/joining the different pieces, all controlled for case number. https://preview.redd.it/4rfjrucnjdzg1.png?width=1408&format=png&auto=webp&s=ff424cf0a8553fe30b769986169901c1ca25a3bd https://preview.redd.it/c8mtq58ojdzg1.png?width=1080&format=png&auto=webp&s=21ccbdfd8ae8d41eb2d69368e62163df3737088b submitted by /u/Abi-Ankeney-PMM [link] [comments]
- Making a fillable form with dropdowns and sections that can be added and moved easily**SEE ATTACHED IMAGE** I am attempting to improve this spreadsheet. I have a decent amount of experience with Excel but I am unfamiliar with the terminology require to describe the exact functions I am attempting to implement. The function of the sheet is to log various statuses and information pertaining to ladders and their inspection status. Each workbook has a header section and a footer section to diffentiate between clients. The sections that detail the individual ladders need to be moveable / re-order more easily, and also be able to insert a blank ladder section for any new ladders that come into service. The reason excel was selected is for access reasons. All of our clients use excel, but if there is an objectively better tool for the job that is part of the Office suite that people can use via the web or with their Office licence then I will consider that. Thank you to everyone who is able to provide some insight into this. https://preview.redd.it/7ln3oocpcjvg1.png?width=1405&format=png&auto=webp&s=584525d55bd27779bd56a9d746b5dcc6dd913c70 submitted by /u/WillowDime [link] [comments]
Tagged with
#Excel alternatives for data analysis#rows.com#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#Excel compatibility#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions