•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need a SPECIFIC type of number to be extracted from 2 columns and placed into 1
Our take
Are you looking to streamline your data management by extracting specific PO numbers from two columns and consolidating them into one? It sounds straightforward, but the challenge lies in isolating PO numbers that start with "01001-" while filtering out irrelevant entries. This task can be efficiently tackled using a formula, macro, or script designed to identify and merge the desired numbers. Let’s explore the best approach to help your co-worker clean up this recurring data set, ensuring a more organized and accessible outcome.
Co-worker needs help cleaning up some data (that they get once a month so not a one-off) where he naturally wants all of the PO Numbers to go into the PO Number column he added.
The issue is whoever is originally putting this data together puts the PO numbers in one of two columns (or as often, not at all) so I want to help him write a formula/macro/script that will extract the PO numbers from these 2 columns and combine them into one.
Sounds simple enough but the problem is I ONLY want it to extract PO numbers, which are the ones that begin 01001- and to leave everything else. And as you can see they show up in either column along with a bunch of numbers no one cares about. Is there an easy way to accomplish this that I am missing? Thanks in advance
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Need to split CERTAIN cells into separate nearly identical RowsSo I need a formula/script that can take the rows that have multiple PO numbers listed and split them into separate rows so that all of the data is uniform. All of the data in the other columns stays the same, just the PO numbers would each become their own row. For example: in the 2nd row, for the PO numbers 7919147 and 7919158 the catalog number for both would be DCHN-22-, Manufacturer would be Cook Inc, Vendor stays Cook Inc, etc I believe it is a simple fix my brain just can't figure it out today, thank you in advance (and hopefully I worded it well enough for smarter people to figure out lol) https://preview.redd.it/hevt5f4n7stg1.png?width=1168&format=png&auto=webp&s=445b058d60f84611381fe6f20b17e6e4660ae2dd submitted by /u/coletrain2481 [link] [comments]
- Helping a coworker- How to return a row with three criteria in an existing sheet?https://preview.redd.it/qpc1n7v6hnrg1.png?width=454&format=png&auto=webp&s=b418c6890f9257bc9e55d32d2d5fee93a0a02a31 Hey all , I KNOW there's an answer staring me in the face. I played around with PQ but didn't see what I liked. My coworker has data that looks like this In a new workbook, she wants to take this above data and return the number in C1 (and D1, and E1, etc.) in column A. But not just pasting vertically, returning it for every line of item#s. So Order A, Order A, Order A, etc. She also wants the item# returned in column B of the new book. Short of copying and pasting, I don't know a good way to do that. Finally, once she has those we can do an old fashioned lookup to get the qty to return in Column C, we're good there. Any thoughts? And please don't just say "PQ" and leave. If your answer is PQ, please give detailed instructions and advice. Editing to add output required: https://preview.redd.it/q3hcvmf1jnrg1.png?width=274&format=png&auto=webp&s=99dbd555d964a0f2aa3a09676efa27ae1af887f9 submitted by /u/Knitchick82 [link] [comments]
- Consolidate data from different worksheets with final information coming from a combination of the worksheetsHoping for some help on a problem I can't wrap my head around. I need to consolidate some information from 12 different tabs (one data pull per month) into one worksheet with some of the data needing to be overridden and some needing to stay. With the most recent pull of the data not necessarily being the information I want showing, I'm not sure how to proceed. I'm trying to find a way to create this and pass it along to someone else to just load data and it automatically puts out the result I'm looking for. For instance, I pull information from my system in January for the entire year (broken into monthly buckets) and all of that is perfect. My second data pull of the year in February isn't so clean. I need to see the numbers from January on any of the January data (because it zeros out in February in my system) but everything related to February through December needs to be from the most recent data pull. Third pull of the year in March, I need to see the numbers from January and February for the January and February data and then need the new info for March through December. Basically, by the time December rolls around, I need data from all 12 sheets. Hopefully this makes sense. Any thoughts on how I can accomplish this in Excel? submitted by /u/megd726 [link] [comments]