answer

Hi, I need to average the first n (let's say 3) numbers in a column, from the first one that is not equal to zero. For example: <tbody> 1 5 2 2 5 2 2 5 3 2 0 3 0 0 3 </tbody> In the left column, checking from down up, first there is a zero, and the average of the following 3 numbers...

When I first visit the forum, I see the article list. Then suddenly I am redirected to the login screen, and I can only return to the article list after about fifteen seconds. Ugh. Then often I'll answer a question, spending ten minutes, taking screenshots, etc. I click on Post Quick Reply or...

Hi I asked this question before and I got an answer. The answer was Visual Basic. Now I came to this link which says it is written in C++ https://www.quora.com/What-language-is-Excel-written-in Which one is the the right one. Thank you so much.

I am trying to find the formula in cell B1 Example 1 eg If cell A1 has value 5 Deduct 1 =4 then divide 100/4 =25 Then deduct 25 from 100 = 75 Then add 4 +(75% of 4) Answer would be 7 Example 2 eg If cell A1 has value 11 Deduct 1 =10 then divide 100/10 =10 Then deduct 10 from 100 = 90 Then...

Hi, First time posting so I hope I make sense. I’m just studying excel and have an assignment to complete and I am stuck on which formula I need. I need to check if a provider on sheet 1 e7 is on the approved list on sheet 3 a1:02 and to return a yes or no answer Am I best to recreate sheet 3...

Hello All, This macro worked great in Excel mac 2011 but does not work in the current version. It actually crashes Excel so it cant be debugged. It would print all the pages of each sheet in my workbook. Can some explain why it no longer works and how to fix it? Sub prtme() Dim Answer As...

Hi, I want to calculate a figure and store the answer as a variable to then be used later in the code. At the moment I have the formula, but obviously, it puts this into the cells I have specified rather than storing it in the memory. Dim Data As Workbook Set Data = Workbooks("Data Today")...

Good evening, I attempting to use a Vlookup as to provide me with a yes-no answer and then use that to lock out a box if the answer is "No". I need to define the sheet as it will be hidden to the user as they input data on a Userform. However, every time I run this code I get a run-time...

Hi all I just want to copy a cell (A1) value down to A2. Only if B2 has a value. And so forth, copy A2 to A3 if B3 has a value. Thanks in advance, ColdGeorge

I am summing rows with this formula =SUM(B2:B94) when all of the cells are blank my answer is 0, is there any way to leave the answer blank instead of showing 0?

Hello all, I have read these two posts about Hover over and wanted to ask if there have been any updates in excel over the years that might allow this to happen now. https://www.mrexcel.com/forum/excel-questions/515724-show-contents-cell-when-hovering.html...

Hi. On sheet2, I have a load of questions & answers from a survey. Row 90, Columns D and E contain Yes and No respectively as the answer options, with a tickbox in each cell, one of which is ticked for each question. On sheet1, I want to enter in cell b2 a formula which will return the result...

Hi folks, Need a little help on this code - Private Sub UserForm_Terminate() Dim Answer As String Dim MyNote As String 'Place your text here MyNote = "Did You Save?" 'Display MessageBox Answer = MsgBox(MyNote, vbQuestion + vbYesNo, "???") If Answer = vbNo Then...

So I'm just doing a simple formula of B1/A1 as a percentage. If B1 is 0 then the answer reverts to an error (#DIV/0). How do I get it to be BLANK if answer is zero? Please help - thanks in advance

I am trying to create a query that automatically hides questions based on their answer. My end goal is to have the query to pull a file from my C drive as soon as I download it and automatically format it then create a new filtered sheet that only shows questions with a No or N/A answer. The...

Hi All, I'm sure someone has asked a similar question before, but tbh, I really wanted to get a direct answer to my specific question, so I don't have to spend time figuring out how to retrofit another answer. :P I would like to pull out the contents from the middle of a cell between two...

Hi guys I have been searching and searching and I can't get it working. I am using google forms and I would like to receive by email the answers as data. I.E. Column A will be Name, column B, age and column C city. So I would like to receive an email for everytime someone's answer and be...

Dear Demigods, Really getting frustrated with this! Every single search for the answer seems to return an answer for achieving them same but based on rows. There doesn't seem to be one post to achieve the same with empty cells in columns. So this is the post i am finding everywhere: Column A...

​Hi, I had a file downloaded from somewhere, 3 rows were merged, when i perform unmerged, first and second row was file with data, how could this be done and what is the purpose of this ? Appreciate your kind answer and thank you BR//TE

Sub isAnyWorkbookOpen() Dim wb As Workbook Dim wbs As Workbooks Dim msg As String Dim answer As String Set wbs = Application.Workbooks msg = "The following worksbooks must be closed before continuing." & Chr(10) & "Do you want to save and close these...