if array

  1. C

    Nesting within ARRAY and IF formula Google sheets

    Building out a holiday request system that is specific to my team and I am struggling to factor in half day holiday requests. I have the following formula: =ARRAY_CONSTRAIN(ARRAYFORMULA(IF(SUM(($D16>=IF('Vacation request management'!B:B=Workings!$B$2,'Vacation request...
  2. szita2000

    Pull together same category winners VBA? or Textjoin

    Hi Guys. I am trying to find a solution to this. I have a list of winners and categories they won in. <tbody>#DAE7F5[/URL] "] K L 20 Jimmy John Singing 21 Billy Bob Dancing 22 Sue Partridge Singing 23 Jones Smith Guitar 24 Blake Boris Drum 25 John Wellington Guitar </tbody>...
  3. S

    If array formula?

    Hello, I was trying to write an If-array type formula (shift+ctrl+enter) to get the following results. Given values in columns A, B, and C: A B C D 33 Needs Attention 34 Needs Attention 34 Routed 34 Needs Attention 34 Needs Attention 36 Not Found 35 Routed 35 Routed I should get...
  4. L

    Array formula - Weighted Average Price of filtered data above .01 cent

    I am having trouble modifying a formula I built out to calculate what the weighted average price of a filtered set of data is. After a lot of trial and error, I was able to successfully create an array formula that could do the above. However, I now want to add if parameters to the formula that...
    • lshub
    • Thread
    • filter and if array filter array if array
    • Replies: 11
    • Forum: Excel Questions
  5. A

    multiple if condition

    Hi all, I'm formulating a formula like this: IF (BI2="Run") then IF(L2<=1;"X-Small") IF(L2<=3;"Small") IF(L2<=10;"Medium") IF(L2<=20;"Large") ELSE "X-Large" Can you please help me use this into right excel formula. Thanks in advance. Any help is appreciated.
    • aeduj_17
    • Thread
    • excel if array if else multiple if_true text search
    • Replies: 3
    • Forum: Excel Questions

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