12/12/2018

  1. A

    Get First, High, Low, Last value within a given period

    I would like to request assistance with a VBA solution. I would like to get the following information below for each month/year and append the information in cell AA2. The dates begin in column (D18 - until) and the values Column (P18 - until). My intention will be to graph the results...
  2. U

    How to find productive time from a chat report

    Hi, I am looking for convenient way to find productive time of resources working in shifts to handle chats. I get chat handled report with start time, end time and resource ID who handled it. They can work of one or more chats at at time and there can be multiple breaks or idle time during the...
  3. X

    Transposing cells using macro and adding additional data

    Hey Guys, in a bit of a pickle. How do I transpose cells from Columns to rows using a macro and also include the Asset Number and Date next to its respective element. <tbody> Asset Number Date Iron Cr Nickel Al Pb Cu Silver TA20 12/12/2018 24 25 26 52 45 85 65 TA22 10/04/2018 65 875 45 895...
  4. R

    Formula help for a two-column match / mismatch

    I thought I was on the right track, but have messed it up somewhere. Sorting based on a match in column C was easy enough, and then I could go down and visually pick out where I had a mismatch in column D. Tried to get a formula in E that would just return a YES in the highlighted rows...
  5. E

    Consolidating multiple rows into one row with row data from some columns across page

    Hello. I have multiple rows of data that I would like to consolidate into one row based on information in a number of columns. In the example 1 below I would like to consolidate all rows based on UniqueId, however would like the rows for Product & Question columns combined across the page with...

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