whichever

  1. M

    Help with nested IF statement

    Employee A , aged 62 is in a pension plan, the rules of which in 2015 were: Payout = 1/2 of Salary or 15000 whichever is less, in 2019, the rules changed payout = 1/2 of Salary or Social Security limit whichever is less but if Employee A is above the age of 62, the rule has always been payout =...
  2. G

    Two heading rows - take whichever is not blank

    My data source has two header rows, for which only one is ever populated. I want to take whichever is non-blank as my header. My instant reaction was to transpose in Power Query, add a custom column that picks whichever is non-blank, and then retranspose. However, the transpose step took ages...
    • gazpage
    • Thread
    • 100k column rows transpose whichever
    • Replies: 4
    • Forum: Power Tools

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