seq

  1. gheyman

    Need to add Seq (1,2,3...) down row using code

    I need to number my rows down to the last row with data. I want to put the seq in B5 down I'm using Dim CBOMLstRw As Long CBOMLstRw = Sheet2.Range("C" & Rows.Count).End(xlUp).Row right now I am adding 1 to cell B5 and a formula to add 1 to B5 and copying the formula down to the end...
  2. S

    Insert the value of a different column depending on matching cell value

    Hello Everyone Hope you are doing good. I want to put the value of SEQ NO in the SEQNO_I column when bot the ID column values matches. As per example below, when ID 4280 matched, SEQ NO 559 inserted in the SEQNO_I column <tbody> SEQ NO ID SEQNO_I ID ADDRESS 559 4280 559 4280 1155...
  3. M

    Modify text string with count, tokenizing and more user readable format

    Hello, I would like to ask for help with following problem. I have a list of strings in column A, from row 1 to row 3100, the text expresses a relation between Operators and Elements. Example: OR, Con1 SEQ, Con2 OR, Con3 PX, Con3 PX, Con2 OR, Con6 2xPX, Con6 PX, Con6 DD, Con1 SEQ...
  4. P

    AutoFill Seq Value

    Hi can anyone help? I have data in columns "A2:W" Sheet1(Updates) Columns B, N have headers 'Seq' Columns C, W have headers 'Used' Where the last row for Column "W" is "W6" and a value of 1 and the value in column "N" for the same row is 20 I want to AutoFill down with 1's from "C2" the...
  5. B

    Sequence

    Hi Folks, I am horrible with my "if" statements. I hope I can get some help. <tbody> Item SEQ ID ETc Apples 2000 1 Chicken 2000 2 Pears 2001 1 Onions 2002 1 steak 2002 2 </tbody> What I need does it the SEQ numbers to do +1 if the ID shows 1 OR repeat...

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