eric

  1. I

    If statement with a between date condition

    Hi Guys I have the below data <tbody> A B C 1 MANAGER DATE STATUS 2 Roy 01/01/2019 Open 3 Roy 01/02/2019 Won 4 Roy 20/02/2019 Open 5 Roy 01/01/2019 Won 6 Roy 01/01/2019 Open 7 Roy 11/02/2019 Lost 8 Roy 01/01/2019 Lost 9 Roy 01/01/2019 Other 10 Roy 01/01/2019 Lost 11...
  2. B

    Transpose Table

    I have a basic table I wish to transpose but can't seem to do so in access. I use the normalization method excel, but can't see how it can be achieved in access. Current Table at top and outcome I seek is below <colgroup><col width="90" style="width: 67pt; mso-width-source: userset...
  3. C

    Help Converting Dates

    I need help in converting dates from this format: YYMMDD 180422 My desired result would be (with slashes): MM/DD/YYYY 04/22/2018 Any takers? Thanks! Eric

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