totally

I'm trying to count how many agents hit goal in a particular quarter. I've set up the following formula to see if the number in column B is greater than that in column H, subtracting if LOA is entered. My problem is it's counting blank spaces, totally throwing off my calculations, and I can't...

Hi I'm trying to amend the formula below so that the result is the sum of all data in the respective columns and rows matching cells C19 and E17. I might have the totally wrong formula! =INDEX('Cashflow labour'!$CM$26:$EA$128,MATCH($C19,'Cashflow labour'!$CM$26:$CM$128,0),MATCH(E$17,'Cashflow...

Hi Someone worked from 10:00pm to 6:00am next day. I want to calculate the difference. So I tried A1=10 pm B1= 6 am C1=(A1-B1)*24 But did not work I watched a video and the guy said use =Mod((B1-A1),1) But did not explain why. I know what mod is used for but how this idea came from? Mod...

Hi! So I have something like this: Function InsertHyperlink (x as string) as string InsertHyperlink = "=HYPERLINK(""www.mrexcel.com/forum/" & x")" end Function Since it's totally wrong, any idea? Have a nice day!

Hi, I have more than 1000 pdfs and I need to copy some specific texts from them on the basis of keyboard. It is just like vlookup. Is it possible, totally helpless and it is very hectic to copy and paste from 1000 pdfs. Please help. Any help in this regard will be highly appreciated....thanks...

Hi Guys, So we perform studies for our clients across a range of topics. I was wondering if there was a way to add features only certain people could ever see. For instance, if I wanted to include a 'reset all' button...where the template we use would be totally blanked to be used for a new...

Hi All, I have tried (on line) to find answer to my question but instead totally confused. I would like to Get next unused sequence number 10223 10224 10229 10304 I need to get 10225 Yhank you in advance.