guys

Hi guys, any help would be greatly appreciated: This works: =COUNTIFS(HeadcountFeed!$G$4:$G$600,">="&$B$8,HeadcountFeed!$G$4:$G$600,"<="&$B$9,HeadcountFeed!$F$4:$F$600,$A45) This does not: =COUNTIFS(INDIRECT(B15,TRUE),">="&$B$8,INDIRECT(B15,TRUE),"<="&$B$9,INDIRECT(B15,TRUE),$A45) with B15...

Hi guys, hope somebody can help I need a formula to convert fabric weight to meters So lets say the gsm is 80gsm, the width is 154cm weight is for arguments sake 900g How would this be calculated into meters? Hope you guys can help Thanks

Hi guys, I have this formula which is not returning any results =SUMIFS($E$4:$E$339,$D$4:$D$339,"="&K$3,$C$4:$C$339,">"&$J4,$C$4:$C$339,"<="&$J5) Column E are Values Column D Names of staff Cell K3 Name of specific staff member Column C are Dates Cells J4 and J5 are end dates of two months...

Hi guys I am trying to make an outlook email button that when pressed it will attach an already attached file (object) that's on a cell in the worksheet into the body of the email. Hope this makes sense to you guys thanks

Hello everyone, I've been searching for an answer but haven't had any luck. Hope you guys can help. I have this(but bigger): Title 1 Data 1 Title 2 Data 2 I want it to look like this: Title 1 Title 2 Data 1 Data 2

Hi all, I am trying to format the filepath from: \Active\1-OperatingCompanies\abc\report\excel.xlsm to \\Active\\1-OperatingCompanies\\abc\\report\\excel.xlsm. Do you guys know how I can do this in VBA? Thank you.

Hi guys, Hopefully the title makes sense. I have a large excel sheet with a triathlon competition results. Name, country and many other information. To be able to plan ahead for next year i need to know how many athletes are present on the course at specific times. What I was thinking was...

Hi Guys, Is there anyway I can simplify this formula? B26 =SUM(AMADEO!F4,CARMONA!F4,'CAVITE CITY'!F4,'DASMA A'!F4,'DASMA B'!F4,'GEN TRIAS'!F4,GMA!F4,IMUS!F4,MANGAHAN!F4,NAIC!F4,ROSARIO!F4,'SILANG I'!F4,'SILANG II'!F4,TANZA!F4,TERNATE!F4) on B27 it should be like this...

Hello! I want to return data from a certain column based on an IF statement. It is very simple but I have 200+ columns of data so I can not use multiple IF statements. See the attached picture for the best explanation. Picture: https://imgur.com/a/Q5yzg How can I solve this? Thanks for...

Hello guys, I have a formula =INDEX(Data!A:A,MATCH(EC!F85,Data!B:B,0)) on my worksheet. I know I can copy and paste the formula all the way down the workbook but I am trying to write the formula in another cell; once I do that the formula stays in a text state instead of going to #N/A. Anyone...

Hi Guys, I wanted to know if there is an excel formula that can be used to return the value of a number in a certain cell for example I have a1 = Buy 1240 Donuts - $450.00 Now on B1, I want a formula which can return the value 1240. Thank you guys!

hello guys im trying to modify this FIFO file here in this page, i need someone to explain the =table(,h2) on column M heres the link: Office FIFO calculation with Excel Data Table thanks guys

We have had this macro for a while now and lately I get a error on the below when running . Do you guys have any recommendations? ActiveWorkbook.SaveAs Filename:=CompleteFilename, FileFormat _ :=xlOpenXMLWorkbookMacroEnabled, Password:="", WriteResPassword:=""...