•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Help locating specific data from range
Our take
Navigating through extensive data can be challenging, especially when you're still mastering Excel. If you're seeking to filter specific information, such as error code 515, you can utilize Excel's powerful filtering features. By applying a filter to your dataset, you can isolate rows that match your criteria, allowing you to view all relevant details in one place. Additionally, exploring resources like tutorials or forums can provide further guidance. Don't hesitate to reach out for assistance—many are willing to help you enhance your skills and productivity.
Hello all,
I was wondering if someone could assisst me. Im still learning excel and having some success, but currently im struggling with a problem. I have a bunch of data across multiple cells. Some columns would have time stamps, location, error codes, vehicle numbers etc.
Lets say i have a bunch of data for all vehicles and errors. How would i go about automatically filtering through the data looking for, example, error code 515. Ideally have an entire sheet that shows all data but just for a specific error code. Or a name.
I appreciate any help on the matter. Even if you point me in the direction of useful information, videos etc. Id be very grateful.
Thank you
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Need Excel workflow advice for multi-region data cleanup and tracking progressHi excel pros, I work for a company with about 20k employees, and I’ve got a spreadsheet of roughly 2,000 people who are missing data for two required info columns. These employees are spread out across different regions, and then further down to individual locations/teams. What I need to do is send each region only their portion of the data, have them push it out to their locations to fix, and then somehow track what’s been completed and pull everything back together into one clean file. In the past, I’ve been filtering data, saving separate files, emailing them out, then trying to keep track of who’s done what and combining everything back together. I’m worried I’m going to run into version control issues or miss updates. It’s also very cumbersome and it has ended up just being a big stressful mess in the past. I feel like there has to be a better way to handle this, but I’m not sure if I’m overcomplicating it or missing something obvious in Excel. I’m very much a basic user and not super familiar with more advanced features, but I’m willing to learn. Has anyone set up a process like this before? Appreciate any advice or ideas. Even just “here’s how I’d approach it” would be super helpful. submitted by /u/Magnolia05 [link] [comments]
- Sync or map data of two automated columns to the filtering systems of other columnsContext: The automated columns are C (Assigned Codes) and D (Positions). These were transferred from one workbook to another, which is this sheet you're seeing. I used the dynamic array filter function because it has to update in real time, as instructed by my manager. Example, my formula for column C: =FILTER([practicing.xlsx]Sheet1!B:B,[practicing.xlsx]Sheet1!B:B<>"",""") Thus, once the source workbook has more data, it can automatically show in this sheet. Reasons for not using alternatives: Power Query - it's not entirely automatic due to the load every x minutes, and the source workbook has to be closed for it to load in the destination workbook. Power Automate - blocked by my company The Problem: Column C and D aren't linked with the filtering systems of Column A (country) and Column B (Leader Assigned). For example, if the country USA is filtered/selected, then its assigned codes and positions should show. The issue is that their country code (starts with "US") and position, IT, are placed in different rows. If the USA is selected, it will only show rows C3-C4 & D3-D4, which is incorrect. https://preview.redd.it/ursej4pq8jxg1.png?width=916&format=png&auto=webp&s=272aa9d905e6d9e5277c70accc67e2614cc03dbd What I'm looking for: My assigned codes and positions already contain formulas (dynamic array filter function), so using another formula for these columns or in one cell can't be done (I suppose). Is there any way to map the C and D columns to the filtering systems for columns A and B? What I tried doing: Advanced filter - it adds a whole new table, but this sadly isn't what I'm looking for with my data. I want to just use the columns that I have now Custom filter - used the text filter -> begins with. It helps with filtering columns C and D for sure, but it doesn't remap the rows, so the data for columns A and B will appear inaccurate. Please let me know if I am also doing something wrong with what I've tried or done. Thank you in advance, and let me know if anything is unclear. This would really mean a lot to me. I am also open to chatting more! :)) submitted by /u/jeankrstein [link] [comments]
- Transfer Data from One Workbook to Another (SPILL Issue)Hey! I’m working on an Excel setup where the workbook on the left is my source and the one on the right is my destination. My goal is to automatically transfer the “Given IDs” from the source to the destination based on their assigned codes. I fixed the one‑to‑many lookup issue, but now I have another problem — when I type an existing code again in the destination (highlighted in green), it shows #REF! instead of its IDs. Is there any way to fix this without losing the automatic transfer I already have? + A user suggested to the COUNTIF into a MOD. I'm not sure how to operate this so I hope anyone could teach me. + "FILTER('[book 2.xlsx]Sheet2'!B:B,ISNUMBER(XMATCH('[book 2.xlsx]Sheet2'!A:A,B:B)))" = this also helps but I also encounter the aforementioned problem (in my real workbooks, there will be times when I need to enter the same codes directly in the destination, and I don’t want to keep going back to the source workbook to re‑enter them all over again.) Thank you so much in advance! https://preview.redd.it/cb9jv0h57ryg1.png?width=1314&format=png&auto=webp&s=b26b1b2886d53f8fe94b76735e4de21ea9a3b866 submitted by /u/jeankrstein [link] [comments]
- How do I filter out cells that I want so then I can copy the information next to it to paste the filtered data onto a new sheet?im new to using excel because of uni and im struggling trying to filter my data so that i can calculate confidence intervals. So basically i started off with two columns cbd dist and median price, but i need to assign words to the cbd dist values (the cbd dist values r in km, and inner is assigned to a value that is less than or equal to 14.75km) which i managed to do after ages googling. However now I want to only copy the inner group and its corresponding median price values so that i can paste it nicely on another excel sheet for my calculations (as its mixed with outer right now, i also need to split the values so i just have a list of outer and its numbers). So I need something where i can highlight all the inner and then just control shift left so i can get the median values. Does anyone know how I can do this?? Thanks in advance and I’d really appreciate all the help I can get as im stumped atm. Also im new to this subreddit and my old post with an image of the data got removed, lmk if you guys need a ref submitted by /u/EstablishmentAny4929 [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#real-time data collaboration#big data management in spreadsheets#conversational data analysis#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#natural language processing for spreadsheets#Excel compatibility#no-code spreadsheet solutions#Excel alternatives#rows.com#machine learning in spreadsheet applications#financial modeling with spreadsheets#real-time collaboration#Excel