put

Hello I have put together a formula but cannot get it to work. Can anyone see where I have gone wrong? I’ve looked at it for so long I can’t see the wood for the trees...

Hi all, I am trying to find a formula that calculates the last working day of the following month based on whatever date I enter in to cell B2. I expect it to be some combo of WORKDAY and EOMONTH but I can't get it to work. For example if I put 13/04/2019 (UK format) I want the result to be...

Hello, I am trying to expand on the following formula: =IF(B1="","","Hi") Verbally it reads, "If B1 equals blank, put blank, other wise put HI." What I'am trying to do is add another criteria for the blank portion such as: "If B1 equals blank AND John, put blank, otherwise put hi." I don't...

Hi all, I wonder how to find the location of a cell at the exact middle of the cells filled above of it. Here is the code of the listbox which allows to put in the row 5 all the items (let's call them b) contained in the listbox 2, with a separated column at each item Dim b%, con For b = 0...

Hi - Is there a way to say look in A10 and if the word "March" appears, put "March" in B10? Thanks!

Hi! I'm still learning to use nested formulas, and I'm trying to divide this particular formulate below by 7, but when I put /7 the output is incorrect (in this case the sum is 24 but the output of when I put /7 I get 20 - which is definitely not right). Please help...

Can someone please try this and see if you get the same problem? In a new workbook, put the number 1 into cell A1. Then add a Data Validation rule, stating it must be a whole number greater than 0. Now in the VB Editor, put this is Sheet1: Option Explicit Private Sub...

Hi, I want to put previous 6 months' Sheet Names in last sheet of workbook. Sheet names are in MMM-YY format and each month new sheet would be added with new months data. The requirement is to put each sheet names either in separate rows or in separate columns. Can somebody please advise a...

Hello All I hope you can help on this please I have a drop down list in cell "P2" which allows me to select a value that then triggers a filter with the code shown below. Question 1 - How can I make this range Dynamic as the rows change daily. Question 2 - It is possible to put a value in...

Hi, I currently have a macro to search words in folder and put the result in my excel. However, it only gives me one result where i want to give me all words found in the text files available in the folder. Sample: If i have 2 words found on the text1.txt it will give me the result 2 rows...

Hi all, i found a macro online which is really useful for me but unfortunately i am useless at Excel. can anyone help me modify it slightly? In the code below an input box pops up for me to choose the columnn but can this be changed so it always just looks at colum A:A? i would still like to...

I am Looking to Create a Custom list from one that I put an X next to the item in another Column. For Example I want all the Items i put an "X" in Column B to List those Items in Column D. <tbody> A B C D 1 Motherboard X Motherboard 2 RAM X RAM 3 Video Card Power Supply 4 Power...

Hi, I am trying to create a formula that will count the numbers in each cell without counting the letters, for example; 2N 3N 4N 5N 6N the sum would be 5 but when I put the formula in place it would count 10. Any ideas?

One of my workbooks has become corrupted, I printed all the vba, and now I have to retype it all, do I need to put each back into the modules or can I just write each sub one after each other in one module?

Hello,</SPAN></SPAN> Data column "C" and columns D:F got results what I want copy all results of columns D:F and put them together in the columns H:I as shown in the example below</SPAN></SPAN>...

I have a problem regarding the SUM-function. It doesn't seem to be able to correctly sum the numbers put in a sheet. I guess it has to do with some sort of formatting, but I genuinely have tried to format it to the best of my knowledge. I have put in all the numbers manually using 3 decimals...

Following from Rick Rothstein's comment here: https://www.mrexcel.com/forum/excel-questions/747715-rnd-not-truly-random.html he suggests, if I understood him correctly, that you should only ever have the randomize function once. In that case, why not just put it in the Workbook_Open...

I have workbooks of 100 of thousands of rows and I need a code please that will count the number of matching cells in column D and put a running count in column D please. Please note it has to be a code rather than a formula. Thanks Before Excel 2010 <tbody> C D 978 AUA520D 1030 979...

This probably sounds familiar, but I have been rifling through google and herd all day to find a solution. Here is some background information: The spreadsheet is for trend analysis on tests. You put in the class number, number of students, and what version of the test they are on(there are 3...

I input the month (ie. January / February / march / ... etc.) into cell A1. I'm looking for the formula for cell A2 that will increment cell A1 by one month. I'm NOT using full dates ... just the words January, February, .... etc. So if i put January in A1 ... February will appear in A2 or if...