non-sequential

  1. W

    Using SUMIF with a non-sequential SUM range

    Hi Folks, probably trivial, but not familiar with non-sequential ranges. Assuming I have 2 columns, X and Y, with 5 rows of data, 1 to 5. Col X is the lookup range, Col Y is the sum range. If the criteria in lookup range is "A2", and this occurs on e.g. row 2 and row 5, then obviously...
  2. L

    VBA to Capitalise non-sequential columns in a table

    Hi and thanks in advance for any help with this! I've got a problem which I'm sure is fairly basic to solve but I can't seem to find the solution.I have a table (Table1) which has various columns. I'd like to use VBA to capitalise 3 of the columns (Surname, Gender...
  3. L

    Allocating sequential number to non-sequential cells, in non-sequential order

    Hi! I'm quite new to excel and looking for some help with a problem - thanks in advance for any help. I need a good way / formula to allocate a sequential number, but in non-sequential cells and that will not change the value of previously allocated numbers? The resulting...
  4. A

    Find non-sequential numbers in column "B"

    The case management system used in my office assigns a "case" number to each matter entered into the system. I can run a report and the "case" number is part of that report. Beginning this FY (Sept. 2013) the system number was re-set to have the first "case" number to be 2014-##### (e.g...
    • ATXMSL
    • Thread
    • conditional format missing numbers non-sequential
    • Replies: 2
    • Forum: Excel Questions

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