transition

  1. D

    Complex Nested IF AND

    Hi everyone, I could use some help. I'm trying to draft a complex IF statement to break various customers into a green, yellow, orange, or red status. I have a column to specifically state this, which will use conditional formatting per color, so our leadership can more easily see which of...
  2. H

    Microsoft Query > Power BI

    Hi all, Hope all is well Thanks for taking the time to read this. I have recently started with Power BI, previously relying on Microsoft Query to pull data into Excel to manipulate. Looking for any guidance to getting Power BI set up to replace / refresh Microsoft Queries. In principle I...
    • half_pint2152
    • Thread
    • data model dataset microsoft query power bi transition
    • Replies: 3
    • Forum: Power Tools
  3. V

    Randomly assign a grade based on an exact uniform distribution and size (excel/VBA)

    I have a 3x3 migration matrix and I would like, based on the transition rates, to randomly choose which items to move from a state to another and keep the same distribution, for instance if i have this array: Pupil Grade Grade N+1 1 A A 2 A A 3 B A 4 B B 5 A B 6 A C...
  4. N

    changing the transition effect property in macro

    Hi, Is it possible to change the transition effect property in a macro? What I want to do is to change between CoverRight and CoverLeft depending on if the previous tab is left or right from the selected tab. I use the mouse down event to register the present tab and the mouse up event to...
  5. G

    Understanding context transition - duplicate rows

    So I thought I was starting to understand context transition, but I got thrown a curveball over the weekend. I have a dataset that records sales, where each row is a single sale transaction. Columns include a customerid and product id that both connect out to dimension tables, but also includes...
    • gazpage
    • Thread
    • measure profit row rows transition
    • Replies: 1
    • Forum: Power Tools
  6. N

    Locked Sheets and Hiding Rows

    I am having an issue with my sheets being locked and using a MACRO transition code to hide and unhide rows by clicking on a circle shape . My Transition code hides and unhides rows 16-17. I would like to still hide and unhide these rows even if the sheet is locked. But currently when i lock it...
  7. L

    Multipage TransitionEffect

    Hello, I've search but haven't found my answer yet. Is there a way to change the TransitionEffect for a Multipage based off of the button selected? I'm looking for coding rather than changing the effect under the page properties. Example: Next Button: Pages Push up Previous Button: Pages Push...

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