serial

  1. R

    Count "1" in a serial in a row

    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...
  2. P

    Input Box Trouble

    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...
  3. M

    Expand Serial Number with Model name VBA Code

    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$...
  4. S

    Need help in making Serial No

    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...
  5. K

    Using an Array to return multiple values

    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...
  6. R

    Putting serial no. on column

    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...
  7. H

    Find / search serials no. And auto fill or check .

    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...
  8. G

    Report Formatting

    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...
  9. D

    Find Matching Values from Column

    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...
  10. cooper645

    INDEX/MATCH or LOOKUP dilemma

    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...
  11. T

    VBA: Sum based on Column Criteria

    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...
  12. P

    How to number rows, skip blanks and then ...

    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...
  13. H

    Print a label w/ info, given a PASS status per prior columns

    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 =...
  14. R

    Slow Code (short)

    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...
  15. J

    Creating Serial Numbers with 12 Characters from 2 Columns

    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...
  16. J

    Vlook up with match formula

    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...
  17. E

    MAXIF Array using sum of duplicate value and known value

    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...
  18. K

    Master tab data list parsed out to applicable cells in applicable worksheets

    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...
  19. B

    Serial Number - printing multiple items

    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...
  20. M

    Help with formula for comparing two matrices

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top