abc123

<tbody> A B 1 Part Number Name 2 ABC123 C1,C2,C3,C15 3 XYZ321 J1 4 IJK100 L1,L2 </tbody> Hello, I have data like the table above (with many more rows and longer names) and I need to break the Name column so that each name is separate with the Part Number listed next to it. An...

Hello, Basically, I have over 1200 part numbers and I'm looking at an 8 quarter forecast. I am trying to get the below result that will be quick and efficient. Would like to be able to sort by quarter and etc. Any help will be greatly appreciated. Current: <tbody> Part Number QTR 1 QTR...

I have a spreadsheet of store numbers that I need to change around. The first 3 characters are always ABC, and then it follows with 2-4 digits. I need to make these all 4 digits, with the missing characters being made 0. So for example ABC1234 would stay as is, ABC123 would become ABC0123, and...

please guide me in copying dynamic range to another sheet in another workbook. please help me. my file enclosed. copy from a2 to r39. r39 may increase or decrease. a b c d e f g h i j k l...

Hi, Please note the following request will be to action this only in Excel - I'm on a works pc and don't have other software available to do this. I have 3 lists of product codes. The codes are in a random order and can be duplicated across the the 3 columns. Each product code has an...

Hi all, My database has multiple columns as follows Column A: Tracking number (txttracking) Column B: New / Resupply (txtrequest) Column C: Resupply No. (txtresupplyno) etc e.g. I have 3 rows with the same tracking number ABC123 new n/a ABC123 resupply 1 ABC123 resupply 2...

Hi, I have two data sets. They are identical apart from one has an additional field that I want to Index & Match and return to my data set. The issue I am facing is I have instances that have multiple occurrences for my criteria. Example My Data Col A Col B 1 ABC123 2...

I have a query which displays records linked to companies based on the ID: <tbody> ID Name Date Current ABC123 John Smith 01/01/19 Yes ABC123 James Jackson 22/12/18 No LMN321 Sam Franklin 12/10/18 No LMN321 Danny Hudson 25/12/18 No </tbody> Is it possible to make the records show 1...

Hello, I am a new user here, thank you in advance for helping me. As well, I have basic VBA skills and really trying to wrap my head around this problem... This is what I would like to do. 1) I would like to scan from the top of column "D" 2) As it is scanning down the cells in column "D" it...

I have a spreadsheet that In Column A, I want to Look up instances where the cell has a value of ABC123 and then run a Copy Data Code and return to look up the next instance of ABC123, but the code is loosing ABC123 and not going through all instances of it. I made some comments in my code below...

Hi all, I have been searching high and low for a macro to compare 2 columns within a range (possibly selected) and highlight the rows that have duplicate values. The columns would be: Column 1 = AO Column 2 = AS Within the range selected, those 2 columns will always be the 2 being compared...

Hi, I was wondering if someone could help me with macro I have. I have some code that copies a sheet onto another workbook. I would like to do some manipulation then on this data. Can anyone help? The following is what I would like to do: Put a filter in row 14 on DFS TAB Filter anything that...

Hi, Please help. I have a sheet of data that is outputted from an external source, see below: <tbody> Vehicle Reg AxleType Axle Position Dimension New/Retread Brand Pattern Event Mileage OTD Date RTD Removal Regrooved abc123 Drive 3 L 295/80R22.5 New GOODYEAR KMAX Fitment 10 24 1.1.2016 24...

I need to create a report that looks up data provided on another worksheet and spits out the sum of all trades maturing in less than or equal to 12 months. So the data looks like this: Worksheet A <tbody> Portfolio Maturing < 1yr ABC123 DEF345 GHI678 </tbody> Worksheet B <tbody>...

Example: <tbody> Column 1 Column 2 Row 1 ABC123 MNO456 Row 2 ZZZ987 YYY789 Row 3 MNO456 ABC123 </tbody> How could I identify Row 1 and Row 3 as being matches/duplicates rows, when the columns may have the data swapped? Ideally I would want the a VB script or way to delete the Row 3...

Hi, I am looking for a formula to look through P25:P70 and make sure they are all the same alpha numeric entry ie If all entries are ABC123 then return ABC123 if there is one or more anomalies then return "mismatch" Many thanks for any help

Hello! I'm trying to create a macro that does the following: 1. Find all instances of the value "#N/A" in Column C 2. When it finds "#N/A" in Column C compare the value in Column B of that same row to Column B of the row above it. 3. If Column B matches the Row above it, then copy Column C...

Objective: You are trying to reconcile the descriptions between two sources shown in the tables below (descriptions are associated by its CUSIP and Account Number) by performing a wildcard search for keywords. These are csv files that have been downloaded and imported into Excel. Case is...

hey all - i am back again. so i am trying to sum up H5:L81 if the corresponding text in F5:F81 = "ABC123". for some reason it is not pulling when i use the following forumula =SUMIF(F5:L81, F5:F81="ABC123") what am i doing wrong? thanks!