consolidation function

  1. G

    Formula to consolidate two different columns

    Hi, I am trying to create a formula which looks at two different columns (1 and 2 in this example) and returns the value if there is one in either column 1 or column 2. And if both columns are empty, then leave the cell empty. For example for the first row, the formula would return $205 and...
  2. F

    Consolidate two columns in one sheet with VBA- HELP PLEASE

    HI everyone! I am trying to consolidate data from two columns next to each other for a macro. When I recorded the macro, it gave me this code in VBA: Selection.Consolidate Sources:= _ "'C:\Users\random\Desktop\[DensityTest.csv]DensityTest'!R2C2:R823C3", _ Function:=xlSum...
  3. N

    Multiple file selection for data consolidation

    Hello MrExcel Team, I was messing a little bit with many threats here and I cannot found a proper solution. Bellow the code and the explanation: I open several excel sheets with the very same layout in order to consolidate especific cells. The problem is that the files selected are not...

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