exce 2013

Hello Everyone . I want to print my hyperlinked all pdf file by 1 Click by using VBA.

Need a little help please, Why doesn't this work in Excel 2013? I have the same formula in 365 and it work fine, How do I adjust it for Excel 2013, please? Basically if I typed in apple in Col B Sheet name New List (another sheet), Column D in this sheet should return all value with the word...

AB1Multiple Searchable Data Validation 2Multiple data Validation1000 English...

Hello Fellow Experts, I have a table in the form of "INPUT" format. I want to convert that table in the form of "OUTPUT" format. What is the best way to do that? Here is the link to the source file and also attached image There is a Previous thread. Peter has solved a similar problem quite...

Hi guys, I want the below result from the string, how can I do this with formula? AB1STRINGREQUIRED RESULT2BBBA123A3BB1234B4CC3C5DD123CD6F11CCD32CD7F11CCE32CME8F11CCF3CMF9F11CCG345CG

I want to write a VBA code which picks the latest date from column remarks and if its been more than 3 days if column remarks isnt updated with new date it should show overdue and if RFI status is set to closed Follow up overdue should automatically be turned to No

I have a few columns as below Name Company Date of employment Date of transfer Employment status Threshold Dory Walmart 27-SEP-19 19-OCT-19 Exited Dory Walmart 01-NOV-19 01-JAN-20 Exited Dory Walmart 27-JAN-20 Active 24-MAY-20 Zack Genozome 27-SEP-19 19-OCT-19 Exited Zack...

Hi, if i had cell value for example =21+22 answer should be 2 as it has used 2 value in the formula =41+40+41 answer should be 3 as it has used 3 value in the formula now in adjacent cell i need the count of values in that formula <tbody> =21+22 2 =41+40+41 3 </tbody>

Here's the link of my excel sheet https://drive.google.com/open?id=1A4NIA-UMu1PoJ7K8r1z3LyTrAwQZe_gn. So From column A:F where I entered the data. I want to filter the unique value in column 5 and put in in column G and apply a conditional formatting as pictures shown? Thank you.

Hello my name is sebastiaan and i am doing an internship in an company fort hat company i am trying to make an excel file that works with userforms to keep track of the maintance of the UV machines that are installed in section 1-8 and in 9-12 and in 13-16. Each section has 4 userforms: Main...

Alright guys, I feel a bit embarrased to ask help for conditional formating, but I have tried and tried to make this work out myself but I cant accomplish anything. I am just stuck. I need to do some multiple condition formating here. I have categories which take part of a material inventory...

Dear programming enthusiasts and professionals, I have created macro in Excel VBA to perform iterative operations. The intention of this code is to paste the values from one range of cells, which contain formulas, into another range. In this code, I have specified the location of the...

I'm trying to convert seconds to minutes in excel 2013, tried this by a2/86400 and then formatting the cell but it is not giving me desired result, I need something like this.. cell A2 cell B2 0 1 1 1 2 1 3 1 ... 58 1 59...