5/25/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. M

    Removing extra spaces then countifs issue

    I am trying to get total customers with an order time before(less than) 12:00 PM. So I extracted data from our system and was able to do asave as, and saved my data as an EXCEL report (.XLS) Order time and discharge time had 4 leading spaces in frontof each time. So I created a new column...
  3. Q

    Get the nearest future date from 3 columns

    What would be the best way of going about getting the nearest future date from 3 dates using todays date? A---------- b----------c-----------answer 3/29/2016 3/29/2017 3/30/2018 3/30/2018 2/15/2019 2/15/2020 2/15/2021 2/15/2019 6/25/2016 5/25/2017 5/25/2018 5/25/2018

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