confused

I have the follow formula in cell D26...

I got a bit bored at work today and decided to took at the standard templates in excel to see if i could pick up any new tips and tricks. I downloaded this one created by Mircosoft but there is something in it that i cannot work how they have done it...

I have two userform (Userform A - ShowModal=True & Userform B - ShowModal=False). When I minimize A, B appears. When I close B, A also closes. I want A to remain showing. How can i make B remain open when I close A. (Confused...my apologies)

I am finding confused for printing the userform. Please help for creating excel VBA code for printing userforms.

Hi I am trying to pull from the sheet below into my cell the first and last name from Job Costing. In the sheet below first name is in C2 and last name is in B2. Then eventually I would scroll down. I looked up =Right Len, but confused its saying maybe I need to do =Left len any help thanks...

Hi I just watched a video and he said that to do =A1:A6-B1:B6 I need to press CTRL+Shift+Enter I selected cells C1:C6 then typed =A1:A6-B1:B6, in cells C1 and pressed Ctrl+Enter only and I got the right answers. So how come that works without using Array? I am a bit confused here. Thank you...

1.I am confused as to what [&] means does itdenote what is between the [&] is a string like: & this is a string & ? 2 If I want to put a formula in a certain cell like J2 to be (B2 – NamedCell) would I; DIM ABC as string ABC = NamedCell ; set ABC as a named cell Range(J2).Formula...

Hi friends, I am not sure how to answer this question for a VBA class i'm taking. How would I count only words with 5+ letters? Thank you! CatLadee :confused: msg = "Total words: " & UBound(arrWords) - LBound(arrWords) + 1 & vbNewLine & "Large words:" & ????? MsgBox msg

Good Morning 2 ALL!!! I need help with macro to auto hide all columns w/passed dates! Starting in F5 which has the date 1/1/2018, to the end of W/S columns always in row 5. All dates are progressive to the end of W/S Columns! Is this possible??? Thanks for any help!!! :confused: :confused...

Hello, I'm trying to construct a formula that basically does this. I'll keep it simple. If cell A1 has "x" then G1 = "Blue" but if cell A1 and B1 both have "x" then G1 = "Blue Green" but if cell A1, B1, and C1 have "x" then G1 = "Blue Green Red". How can I do this? It' confused me for the...

Hi That question is answered in the article below. The author is saying macro and vba are different. I am very confused now. I thought macros (recording macro) are vba sub routines, am I right? I thought these recorded macros will be saved as vba subs...

Hi, I am a little confused by the following rounding tt = Round(1915.5 * 3.27, 2) 1915.5 * 3.27 = 6263.685 so the rounding should round up 5 to 6263.69 but I am getting 6263.68 What is happening? This is excel 2016 Thanks

Good day all, It has been YEARS since I used a Forum so you can guess that I have a few questions, but I will keep it to down for now. This is what I am trying to do. I am having a problem with the setup of a spreadsheet I am trying to create and I wanted to provide a sample screenshot (to the...

I have 'inherited' a spreadsheet that has a vlookup in a table that refers to a table in another file. It won't work. Any suggestions?.. I have tried making sure the files are both in the same e-folder on my c drive. I am lost for ideas. I am new to working in tables. would appreciate any...

Hello, I have excel 2016 pro plus (not 365). I have an option (3rd from top) when I right click on a pivot table which says 'Tabular, no-subtotals layout'. Don't get me wrong, I love it but I am completely lost as to how I got it. I must have changed something at some point but as far as I know...

Hi all thanks in advance for any help. What I want to do: Look for a value in A1 of sheet 2 in column A of sheet one and when it finds it sum column O/P/Q of the same row. I thought like this: =vlookup(A2,Sheet1!A:D,1,false,sum(Sheet1!O2:Q2) or this: =VLOOKUP(A2,SUM(Sheet1!O2:Q2),1,FALSE)...

hi Experts.. how can i parse the data from this website into excel? :confused: https://api.binance.com/api/v1/ticker/allPrices into 2 columns Symbol and Price really appreciate the help :)

Hi all, It's my first time posting here, and I apologise for what will surely be a question full of incorrect vernacular and confusion. I will however be concise. So: I'm building a roster for event staff - it should be simple, but I got carried away. The first sheet (Schedule)is where start...

Hi guys, I get confused as to the syntax between SUMIF and SUMIFS. Do you know a way you guys can remember each syntax without getting confused one with the other?

I'm wanting to identify a string that starts with one char A to Z, then any number, than a period and space. I *think* LIKE [A-Z][1-9]. *" could be be a starting point but I'm not sure if I'm getting confused with Regular expressions, plus how to handle a number > 9. Thanks for any help