effectively

I'm trying to automate the processing of several files, and several of the files throw up the message: "We found a problem with some content in 'ThisFile.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes." In order to get around this...

Hey All, I am stumped on the following and would greatly appreciate any help on offer! I have two rows of data which share a common cell (URL), that I would like to effectively merge like so: Before: After: Can this be done? Kind regards, Cas

Hello, I am trying to get the following statement to work, but I get a debug, based on the code up to then... can someone tell me what i need to change to get this to run. effectively there are two scenarios which should return "on target". If Cells(j, 30) >= 2 And Cells(j, 26) >= 6 Or...

Hi All, Long time consumer of tips in this forum achieved through google-fu, but I haven't had success finding an answer to this one... Specific Question: How can I get the table of results of a Find and Replace dialog box Find all search output as text to put into a worksheet for downstream...

Hi Guys, Can anyone help me with this formula? I know I can use either one to exclude weekends however if the Start date is the same as the completed date it shows 1 day where effectively I need it to show 0. =NETWORKDAYS(A1,B1) =SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1)/7)) Surely it wont...

Hello folks This is crazing me. As you'll see the formula below works out the percentage of counts of 'yes' against a total of counts of 'yes' and 'no' in the range of D13:D16. So far so ok. =SUM(COUNTIF(D13:D16,"Yes")/(COUNTIF(D13:D16,"Yes")+COUNTIF(D13:D16,"No"))) [So if D13:D15 ="yes" and...

Hi there I have a graph with a Y axis that goes from 0 to 100 in increments of 10. I would like to hide the y axis between say 20 and 50 so effectively the y axis shows 0 to 20 and then from 50 to 100. Is this possible?