serial

Hi A have a row with 0 and 1 and they comes in a serial. A wants a formula to calculate the largest/ second largest serial of 1's in a row. I wants to variate were to start and stop, sometimes I have to start counting in a middle of a serial of 1's 1111111110000000111111000000000001111111111...

Greetings, This is my first attempt at using the Input Box Method. I have this piece of code that strips away extraneous characters and leaves just the serial number: Option Explicit Sub Extract_Count() Application.ScreenUpdating = False 'Change Column Headings...

Hey every one i just new in VBA and i need your help as welli have row data file of serial numbers with product name and i want to open it and show data as well in excel with vba here is the sample:i want to be like this i use below codes to open serial numbers :Sub ExpandSeries() Dim RR$...

Hello Friends, I need some help in the below table. I have an excel file like this. Now i want to put serial no 1,2,3 like this but according to ID Type Column whichmeans first serial number for AA ID Type starts from 1 to 4 then for ID Type BB it starts from 1 not continuing from serial number...

Hello! I am trying to get an array formula to work so I can have one value return multiple answers. My formula currently is: =INDEX('GP Serial Data'!$F:$G,SMALL(IF((Summary!$B$2='GP Serial Data'!$F:$G),ROW('GP Serial Data'!$F:$G)-MIN(ROW('GP Serial Data'!$F:$G))+1,""),ROWS($A$1:A1))) I'm...

Hi, I am having an excel data where a serial number is required based on a particular column value. <tbody> Serial Number Batch New Serial Number 1 010869GN9 1 2 053332AR3 2 3 785870XE1 3 4 46625HJT834 4 5 010869GN9 6 76886PES8 5 7 785870XE1 8 053332AR3 </tbody> I want...

Hello all , I am very amateur in excel , We have excel count sheet of our inventory ,nearly a sum of 20k unique serial numbers of parts with barcode on them when my staff does stock count they scan and find each part and fill a colour in the cell to check , that involves 2 person and a lot of...

I am trying to format a report, but am having a difficult time. I have 3 fields that I want to display information on. Equipment Type, Model, and Serial Number. What I would like is for the Equipment Type be centered on the page and grouped. Under it I would like each equipment type (printer...

I'm working on a spreadsheet with two columns, Column A has a list of serial numbers & Column B has a list of scanned data which contains some of those serial numbers as well as junk data all in one continuous line (ex 'ABCD1234FGHJ' where '1234' would be the relevant serial number). I'm...

Hi guys and gals. So I am having trouble coming up with a solution to my problem. The scenario I have is an auto populating form based on one key cell. I select the serial number and the rest of the form fills out based on that selection, all of this work fine, until I get to the point that I...

Hello, I am needing help to sum values for each series. The series is in column A and the values are in column B. I have place an example at the bottom. I would like to do this with VBA. Thanks <colgroup><col span="2"><col><col span="2"></colgroup><tbody> What I Have What I Need SERIAL...

Hi, I have a small problem. I have 3 colums A, B and C. In col A I have Family serial number. All parts in the same family have the same serial number. In col B I have sub serial numbers. Each sub part has it's own designated serial number. In col C I would like Excel to number each row/sub...

Greetings. I've Excel 2016 spreadsheet that I created that captures the following information per these columns:A = Operator number B = Serial number of part being tested C = Date / Time (this is auto-filled once the Serial No. is scanned into prior field) D-F = test set-up confirmations G-AD =...

Hi folks, I have a shared workbook that breaks if you sort and filter in certain ways because of blank cells. I would like it serialized when I use it, this code works but seems slower than I would expect. Is there a technique someone would teach me that might decrease the time this takes this...

Hi Guys, I have two columns, A and B for arguments sake. Column A has 2-4 alpha numerical characters in it, and Column B is numbered 1-12 and then after 12 starting back at 1 again. I need Column B to insert 0's infront of the number (1-12) inserted into the column so that the total characters...

Hi, I'm new to this forum. I am trying to create Part and Price data base, where entering in a particular part number and quantity pulls up the serial number and price depending on quantity ordered. I was able to do a VLOOK UP [formula used is "=VLOOKUP(D2,$A$7:$B$61,2,FALSE)"] to find the...

Hello, I am trying to figure out how to create a MAXIF Array function using duplicated value sums, and a known criteria value. Example: I have a shipment report that shows parts shipped down to a part and serial number. I need to summarize the data by part number showing only the largest...

Master tab column A is a list of 50 serial numbers (rows 5-55), column B is the device type the serial number belongs to (rows 5-55) and column C is the user of the device (rows 5-55). Each of the serial numbers is hyperlinked from the Master tab to its own tab which is named with its...

Hi, I have got 8 different types of components and each component has a quantity of up to 150 pieces. Each piece gets measured and marked with a serial number. I have a basic spreadsheet to capture the data (https://imgur.com/a/6xcAM). Pretty straightforward. with some conditional formatting to...

I need some help/suggestions with an analysis I am performing based on product serial numbers. Background: I have a spreadsheet of 500 or so serial numbers for one of our electronic products. The serial numbers cover 4-5 different model numbers. Each of these models contains 30-50 pieces of...