depts

  1. A

    Vba - insert two columns after each occurrence of dept name

    I need help with simple VBA Code. I have a SAP BW Excel Extract. In Row 3 there are are column headers of ten Depts. Each Dept's name occurs four times. I want to find the last occurrence of each Dept's name and insert two blank columns for each Dept. All the first blank column's header must be...
  2. P

    SUMIFS Wildcard

    Hi Guys, I'm using Excel 2016 and trying to retrieve some values from a table, here's a simple example; <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Dept Sub Dept Sales Dept A Dept A1 100 Dept A Dept A2 150 Dept B Dept B1 500...
  3. S

    Multiple if conditions

    Sir Can you help me I have 7 columns In Excel (Rows A to G) with 100 rows of data Column F is used for Departments. Total 18 depts in Excel How do I write a function or macro in excel to to group the depts as follows: Dept A,B,C=Good, Dept D, K, N=Average, Dept M=Review & so on This Grouping...

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