omitted

  1. G

    count of consecutive cells with same value omitting the first three

    Hello, I have a row of 31 cells which can be blank, or contain a value of either 1 or 0. I need to count all the 1s and 0s except consecutive 0s of more than 3. In example: <tbody> A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF 1 1 1 1 1 1 0 0 1 0 0 0 0 0 1 1 0 0 1 0...
  2. U

    Select data on row, depending on data 2 rows down

    Hi all, Wonder if someone call help me with something. Basically I have a whole load of data which I need to sort of "sanitize" so to speak. The data looks like this (it can be in a text doc or put into a new sheet) mac-address (omitted) profile persons-name domain LONDON hostname...
  3. J

    What do I use? Index? Match? If? Combination of all three?

    Good afternoon, I have a workbook. Within that workbook I have two worksheets, one is called customer list and the second is called raw data. The raw data worksheet is set up like below... <colgroup><col width="129" style="width:97pt"> <col width="31" style="width:23pt"> <col width="63"...

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