sean

  1. Sean15

    Help with SUMIF

    Hi: 2*Invest 10 3*Invest 20 4*Invest 30 2*Restricted - Invest 10 N49 = invest O49 = SUMIF($N$43:$N$46,"*"&N49,$O$43:$O$46) Returns 70. Required value $60.00 Could you help please? Regards, Sean
  2. Sean15

    Parsing serial numbers

    Hi: I have a set of long serial numbers formatted as shown below. I want to return ALL text and numbers after 991- Example: 600-1150301-520-199-991-CPG1500-- Required value would CPG1500-- Could you help please? Sean
  3. Sean15

    Multiple VLOOKUP stump

    Hi: Could you tell me why this formula is returning "" =IF('LReports'!J3="UG",VLOOKUP(H3,'AVERAGE Price'!$B$5:$D$39,3,0),IF(J3="DF",VLOOKUP('LReports'!H3,'AVERAGE Price'!$B$5:$D$39,2,0),"")) VLOOKUP range looks something like this: column B column C column D MMYY DF UG 917...
  4. Sean15

    Excel says formula is missing parenthesis

    Hello: I want formula to return "" for #N/A =if(IFERROR(LOOKUP(2,1/(COUNTIF($D$2:D10,$B$3:$B$21)=0),$B$3:$B$21),"") But Excel says formula is missing parenthesis. Could you help please? Regards, Sean
  5. S

    Listing Best Performers

    Hi All, I am trying to create a Best Performer Cell which would show the name of the best shop performer. Mary, Sean and Leane all have 100% insurance but Mary only did 1 sale where as sean and leane did 10. but mary is listed as the best performer as her name is higher up the list. to give...

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