des

  1. D

    Help Needed!!

    Hi All, Hoping there's an easy formula for this as I am having a blank moment. So the below is a simple example of what I am trying to pull through in to column E. I would like to look up multiple "Item Number" which are the same, sometimes theres 2/3/4 of the same items. I would then like...
  2. U

    How to transpose

    I have data that is material description July Aug Sept. The forecast is below each month. I will like the format to be Mat Des Jan Forecast Mat Des Feb Forecast Essentially, I will like to transpose the months and Forecast. I hve 80 unique material numbers. What is the quickest way of...
  3. B

    Conditional Format for alternating duplicates

    The Following rows are manually highlighted based on text value in Column B. I know how to conditional format for duplicates, but I don't know how to conditional format when there is more than one version of duplicates, in alternating sequence, with variable number of rows. is there a way to do...
  4. A

    Calculer note en jours ouvrés

    Bonjour Je souhaite un analyseur de la conformité des dates des expéditions des commandes clients à une date J. Sachant que les commandes positionnées en jour "J" sont à expédier à "J + 1". le résultat doit donner les notes suivantes: "1 si l 'expédition a été effectuée à" J + 1 ". Ensuite "2"...
  5. Z

    macro- delete hidden rows after filter in place

    Hello all first time user but have used this board many times. macro noob here but have been doing basic macros for a while. I have 2 tabs, tab 1 and tab 2 They both have same content let's talk about tab 1 which has the following data <tbody> Fund dept Descrip Item 123 abc des c1...
  6. N

    Excel Macro VBA - Subtotal function issue

    Hi everyone, I have made a macro to add in a table a sub total from a filtered database. The sub total function being the only solution, because the SUM function is taking into account all the rows, and I only want the ones which are filtered. To do so, I have write this ...

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