excel multiple criteria

  1. B

    VBA leave tracker

    Hi please help me for this VBA code. Sheet 1 is leave planner Sheet 2 is Data (name &date&leave) are all in there The native excel formula is =xlookup = b5&c2, NAME&DATE, LEAVE,"") And then drag it until =xlookup = b5&AG2, NAME&DATE, LEAVE,"") And also drag it down from =xlookup = b5&c2...
    • bench205
    • Thread
    • excel excel & formula excel multiple criteria vba vba & code
    • Replies: 1
    • Forum: Excel Questions
  2. S

    Match and extract based on horizontal and vertical criteria between 2 dates

    FOR EXPERTS Hello everyone. As this is my first post on this platform as I got stuck after days of trying without success and I apologize if already exist the same post because I couldn't find it. Namely, I have a excel table that consist of horizontal dates (of 2-3 years) and vertical data...
    • Silverstone
    • Thread
    • excel excel experts required excel horizontal and vertical excel matching excel multiple criteria offset & match
    • Replies: 2
    • Forum: Excel Questions
  3. B

    Multiply Cell by Two Different Numbers Based on Range

    I am attempting to create a formula in B6 that considers the following criteria: If SUM B1:B2 <100 then SUM(B1:B3)*28 If SUM B1:B2 >100 then multiply the first 99 hours by $28 and every hour worked thereafter by $32. Then add B3*28. * B1 & B2 are the only hours to be considered regarding <...
    • brandon12
    • Thread
    • excel excel if statements excel multiple criteria formula formula =if() if and nested "if statements"
    • Replies: 6
    • Forum: Excel Questions
  4. K

    Excel lookup using multiple criteria

    Hi, Below is a sample table which I need to extract data from: <tbody> Event Name Location Feb Feb Feb Feb Feb Feb Feb Feb 04-Feb 05-Feb 06-Feb 07-Feb 08-Feb 09-Feb 10-Feb 11-Feb Event-1 Loc-1 Yes Yes Yes Yes Loc-2 Yes Yes Yes Yes Loc-3 Yes Event-2 Loc-1 Yes Yes...

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