31/08/2017

  1. G

    Lookup for multiple criteria and duplicate conditions

    Hi, I have data arranged in A1:E5 and want to extract values from B3:E5 based on criteria given by the Product Code in A3:A5, the date in B1:E1 and the Data Type in B2:E2. The extract forumla references these conditions in cells G1:G3. e.g G1 = AAA, G2 = 31/08/2017 and G3 = Percentile. The...
  2. M

    Tricky one - finding the last entry for a specific cell and returning a corresponding value.

    Hi, I need to reference the specific site name on column B, find out which entry for that site is the most recent from column A and return the value in C (whether it is "cleared" or "raised"). There will be duplicates in Column B (Source) but I am only interested in what the most recent...
    • Mr James
    • Thread
    • 31/08/2017 cleared date & time picker difficult excel formula max based on criteria
    • Replies: 1
    • 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