question

Hi all, Hopefully a simple solution to this question, I want to basically return the date of the Friday just passed in "ddmmyyyy" format, so a formula to return 19072019 in the example of today's date. If the date were Thu 12th September I'd want 06092019 - if the date is a Friday then stay as...

Hi all, Question for you, why is it that I have to put a 0 betweenthe speech marks to get this formula to return a value? If I take the “0” out of the speech marks I get nothingback? What am I doing wrong. =SUMIFS(V5:V2247,T5:T2247,"",X5:X2247,"0",Y5:Y2247,"EME") Steve

Good Morning is it possible to answer the following question without creating a data list (to reference in a countif formula) I have a range of data in column A of Worksheet 1 1 1 1 2 2 2 5 5 5 and so on The question states which number is represented 10 times. i can work out the answer...

Hi all, been a while! I'm creating another spreadsheet and wondered if anyone can help me out with it. I have a survey that asks a question, with responses to the question being: - Definitely - Likely - Not Sure - Unlikely - Definitely Not - N/A The downloaded sheet displays the answers in six...

Hi all, This is my first time asking question online for excel(mostly just google and have the answer) but i struggle to think of a good way to ask this question on google. Basically I am making a cell at E2(shown below) to show subject 1 OR A2 <tbody> A B C D E 1 subject 1 subject 2...

Hello and thank you in advance for any help. I'm looking to have VLOOKUP return a hyperlink, but one which is a reference within the workbook, rather than a URL. Can't find a format for writing the hyperlink to begin with that Vlookup can then return as working. Explanation of the below...

Hello, got problem, can somebody help me? How can I save file as .csv by macro in current folder? I would like to avoid defining file path to save because it will be different in every case. Another question - how can I grab string from cell(A1) and put it in the name of saved workbook as...

Dear Friends and fellows, Yesterday I asked one question which is not clear. it's because of my lack English knowledge. Kindly you all pardon me for that. Here is the clear question. If we take from 1 to 9 as complete 360° rotation. from 1-4 how much degree rotation. kindly write clear...

Hi Everyone, I'd like to ask a question about a very simple excel problem but I don't know how to solve it, haha. I have a sequence formula like this: <tbody> 1000 5% =ROUNDDOWN(A1*(1+$B$1),0) =ROUNDDOWN(A2*(1+$B$1),0) =ROUNDDOWN(A3*(1+$B$1),0) =ROUNDDOWN(A4*(1+$B$1),0)...

Hello, I use this formula to get the actual charge (AF19), Min Charge (AG19), Or max charge (AH19) by days of the month. Question is how do I keep the cell for say the June 2nd total blank without the min charge populating if the data is not filled in yet in the other cells to get the total...

Hi All I am using this code and the target range represents 1 layout of 72 cells. I need to include 23 more layouts. My question: should I cram it all in 1 target range or should I duplicate this code for each layout? If Not Intersect(Target...

Hello everyone I know that once you enter a formula into a cell you can drag it down to fill in to all the cells under it. My question is in certain cells i have a different formula in it and was wondering if there was something i could put into the formula to prevent it from changing when i...

I am wondering if it is possible for a formula to return only the last part of a text string (without the $) from another cell? ie. in this example, the formula would return 81416. "over $47,630 up to $81,416" Hoping for a solution. Thanks!

Hi Sorry if this off topics. I am reading the job description below. I would appreciate if you can answer my questions just to get an idea what is the requirement and where I am at. 1) Validate MS Access databases to align with current excel model My question: Is this Access, Excel or VBA...

How do I create a question and answer bank with excel in a way that I can randomly produce tests with corresponding answer sheets? Also, I need to create multiple choice tests. Little about me: real dumb. Basic instruction and guidance is appreciated. Thanks in advance!

Could I trouble you for a formula to count the number of words in a cell. These are actually names so in an example of Stephen Thomas Smith the answer is 3. Such a simple question but I have thousands of rows that I need to review. As ever my sincere thanks

I was sent a workbook that had macros selecting columns of varying length. The debugger showed me it did not like the selection (A1:A) Once I changed it to (A1:A1000) far more cells than I'll ever populate, the macro works fine. The question is why does my Office 2016 not like it but many...

A kind soul helped me out with this the other day. Now I have a subsequent question: How do I set a variable to this value? Here's what I'm trying to do: Set MyFile = Workbooks(" & Range("B1") & " " & Range("C1") & ".xlsx") so it would end up being: Set MyFile = Workbooks(Donors April.xlsx)...

It's such a simple question, but I don't know how to write the formula... Here's the question: If one knows that in 2018 that $3.59 was paid in dividends, and that in 2024 the expected dividend is $7.10, what is the percentage increase per year that will get you from $3.59 to $7.10? Thanks...

Thank you for your time in reading this< I've done my share of searching, but I think I don't know how to ask this question. I have a workbook with multiple connection queries, but I don't want to bring all the tens of thousands of lines of data into the table. Is there a way to look at the...