colb

  1. S

    Pluck out positive values and it's respective data within an array

    Hello excel guru's So from row 18 to Row 24 I have a transaction listing going across many columns and within ColB on those rows, I have values like this: -7.73 -27.57 5.52 12.40 -4.14 266.54 -42.40 From Row 60, I would like to populate bits of data from these transactions but only from the...
  2. R

    Finding an average

    ColA ColB 4 1 3 2 2 3 5 3 2 3 1 2 A20 B20 17 14 Sum ColA and Multiply by 3 (17*3) = 51 Sum ColB and Multiply by 2 (14*2) = 28 Then I need to add those 2 values (51+28) and...
  3. A

    Number data in a column based on its uniquness

    Hello Everyone, I think my question / problem is simple but since i am still learning I need your help. I have 2 columns (ColA,ColB) ColA = Random volume of rows with some data which repeats frequently. ColB= should pick up a sequential number 1,2,3,4 for every new data in ColA. If a data...
  4. A

    Code Optimisation (Find and Delete)

    Good Morning all.... Got an odd one in that what I have is working, just not well.... I have a sheet with two columns and 100k plus records Col A contains a text description that is fetched by a VBA Cut and Paste from another sheet. In ColB I have automated a COUNTIF to copy from Row2 down...
  5. J

    add business days

    hello, I have 2 columns of dates I want to find the number of business days ( ignore holidays) between ColA + ColB then add the number of days resulting back to ColB ( date or cell No ) to show a future date I used networkdays to get the difference but can't get the rest...
  6. Y

    formula to return next different value within column

    Such as Col A a a b c c e k k e I need result in column B (duplicate value is not my concern, just jump to next different value) ColB: a b c e k e

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