5/1/2018

  1. D

    Converting specific columns to vertical one record

    I have similar to this table with many columns and thousand of rows (patients) - as you can see each patient have 6 tests(test1 to test6) with different 6 result. - all other columns have the same result. - I need to switch the results from vertical to horizontal so I the table can show one...
    • dankar
    • Thread
    • 5/1/2018 5/25/2018 abcdefgh power query tested usa
    • Replies: 19
    • Forum: Excel Questions
  2. C

    I'm trying to find a way to show a monthly grid of counts of patients in a location of each hour of each day.

    I need to be able to count cases/patients located in a certain place and show the count that were there each hour of each day of the month. I've started this work but I'm stuck. First off I have a false on the G5 cell that should be true. To complicate this further they want to be able to see...
  3. J

    date time forumla

    Hello to all, I need to find a formula that will take two dates and two different time ( time in and time out) and subtract them to give me the time what was the balance used I.E Date time in date completed time out time used 5/1/2018 10 AM 5/2/2018 11: PM...

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