sean

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

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

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...

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

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...