•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is there a way to select rows, based on the value of a specific column?
Our take
If you're looking to streamline your data analysis in Excel, selecting rows based on a specific column value can simplify your workflow significantly. Instead of exporting multiple sheets for each town, you can leverage Excel's filtering capabilities to focus on relevant data. By instructing Excel to display only the rows corresponding to a particular town name, you can efficiently create targeted pivot tables. This approach not only enhances your productivity but also allows for a more organized analysis of your data set.
I'm a relative beginner with Excel, since I mostly work with my data in other programs specific to my field. However, I wanted to make some quick pivot tables in Excel. Normally, I'd query the specific attribute I'm working with (in this case specific towns), and just export all entries that match that attribute into Excel. However, in this case that would result in an overwhelming amount of different Excel sheets with how broad this data set is. So, I was wondering if I could make that sort of querying selection in Excel itself; so say tell Excel to select all rows that have a specific town name, and then I could use that to make my individual pivot tables for each town.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to move selection without moving selected data?I'm working with a very large data set (>50,000 values), and need an efficient way to index and create charts from a selected range. What works is CTRL+F for the name of a well (B2 shown here) which then allows me to select all cells named B2. What I want to be able to do now is to move the selection frame over to just select those 724 cells but ONLY in columns D&E. Excel lets me select B through E via Shift+Arrows. How can I only move the selection pane without moving/pasting data over? TIA. https://preview.redd.it/b4vlmr4s4vug1.png?width=2879&format=png&auto=webp&s=6fbe5539eef3ebbe820569a09c95959ab45e71ff https://preview.redd.it/5bii8s4s4vug1.png?width=2874&format=png&auto=webp&s=ec70f1611e884ffc812eabfdc73843e284eb32e1 https://preview.redd.it/glq2ur4s4vug1.png?width=2878&format=png&auto=webp&s=990755d70452fb92246c7e9ed6d1fb5c973e397b submitted by /u/OnewhoSortsNew [link] [comments]
- Using Data from Two Sheets to find classesI work in a corporate job and somehow became the person on my team that knows excel best. I’m okay with excel. Not an expert. But I need help. I have a spreadsheet that lists available training classes and how many seats the class has and how many are still available. I also have a sheet of learner requests for classes. I would love to combine the data and be able to query or pivot to show a list of students that could be enrolled into available classes. What’s the best method of going about that? Thanks. If I need to go elsewhere to ask questions like this please direct me. Thanks. submitted by /u/Coffee4words [link] [comments]
- I’ve been using Excel more lately and I’m trying to understand some of its more advanced features without making everything overly complicatedWhen working with data that has multiple conditions or needs to update automatically, what are the most efficient functions or tools to use? for example, is it better to rely on formulas like XLOOKUP and FILTER, or are there built in tools that handle this more cleanly? Also, how does excel handle performance when formulas start getting longer or more complex? Is there a point where using too many formulas slows things down significantly? What are the best built-in features in Excel for handling complex data in a simple way? submitted by /u/icepix [link] [comments]
- Group particular rows that contain certain wordsI have a about 300 rows of data in a spreadsheet, I want to select all the rows that contain a certain word and group them somehow or put them in a table. When I control, select the rows manually and right click the option to create a table disappears. There must be a way I can do this. Does anyone have any ideas? For context, the list is property addresses and I want to group them by suburb. submitted by /u/Boom_Gate_Lady [link] [comments]