figure

How do you find the statistical difference between a slope of -0.09 and a slope of 0? What steps would you need to do to figure it out? What statistical analysis would you need to do?

Hello, Trying to figure out what to search so I can figure out how to do this. I'm building a part number lookup, so it matches each number and returns information. So of the descriptions are multiple lines. How can I look at the next row and check for " " to determine if the offset...

Hi all, I've been really stuck with the below so I'm hoping someone can save the day for me. I'm trying to divide the last value in each column by a figure stored as an integer but I keep getting a run time 1004 error, method 'range of object'_Global' failed and I can't seem to figure it out...

So I'm creating a spreadsheet to track commission pay-out across multiple pools of business. I want to minimize the risk of my staff doing the % sum themselves but I cant figure out how to use the =IF function. The problem I have is that the commission is different based upon what is sold. For...

Been messing around with codes and just can't figure this out. <tbody> A B C D 1 Player 1 11 22 33 2 Player 2 44 55 66 3 Player 3 77 88 99 </tbody> If Player 1 is not blank; and Player 2 and 3 is blank. I need 11 to be formatted. If Player 1, and 2 is not blank; and player 3 is...

I am trying to use the Find function to find the last location that a word is used in column A. Below is my current code. I have tried various other versions and methods, but cannot seem to figure this out. Sub Find() Range("a10000").End(xlUp).Select Range("a:a").Find("Count").Select End...

​Hi, i would like to combine SUMIF with SMALL but has some problems doing so: I have a table where Week/Year is stored and now i need to create a Top 10 of the worst results for each week. I can easily do it with the whole data set by using =SMALL(Tabel1[Percentage];Oversigt_!A3), but i can...

Hi I’d like to count the names I am entering in column B so I can see at a glance how many times the name appears. Can’t figure out how to do this. Thank you for any help. Regards

Hi All, I have a budget table which I need a little bit of formula help with. So when I select the option of Paid I would like it to deduct the value from the total providing me with the remaining balance. Please see below example of how I would like it to work; <colgroup><col style="width...

Afternoon all I need help with a formula. I currently have this formula: =IF(N2="","",IF(S2="Out of Scope","",IF(A2=A1,"Timesheet","New Booking"))) I need to add another couple of criteria to this formula to return a "" if there is a "Y" in cell AE2 EXCEPT if there is a "Y" in cell AF2 in...

Greetings Folks, I just can't think of how to make this work, I don't know if I'm just mentally exhausted by working on a dashboard all day, but I just can't figure out how to do this. I have 12 columns for Months.. January - December. I'm trying to take a number and I would typically divide...

Can someone please assist.... I am trying to generate a formula where I place a figure amount for example the EURO conversion of the australian dollar to euro being 61 cents in the euro, I would like it then when I make that change to that figure of 61 to lets say 62 it automatically changes...

I have inherited a spreadsheet with a formula I cannot quite figure out. =ROUND(TREND(F3:H3,$F$1:$H$1,4,1),-1) I understand everything except the 1 that follows the 4. What is that 1 mean? TIA

I have a California red wine collection. For each wine I have the Name of the wine (Col A), release year (Col B), Cost (Col C) and Rating on a 100 point scale from my favorite rating source (Col D). The costs of the wines in Col C have been normalized to same year dollars. It has always been...

Hey, I'm hoping someone can help me with this, I know what I am trying to do, but I can't seem to figure out how to make a formula that will understand my thinking. This is what I need to do: I want to figure out what percentage of sales is needed based on the day of the week, but also based...

I want to select newest PET date. But I can not figure it how. IF B:B is PET then select newest date?

Hi, I have the following example URLs: https://viyet.com/andrianna-shamaris-teak-and-bone-inlay-circular-bookcase-sto-49740-27277.html https://viyet.com/janus-et-cie-large-shell-bowl-acc-49959-2600.html https://viyet.com/jonathan-adler-danner-loveseat-sea-45150-33425.html The length is...

I am trying to figure out how to scroll through a data set and have the row and column or just the row highlight as I am scrolling. I do not want to have to click to change rows. I have seen this on a few other sites but I cannot figure out how to complete this task. Any suggestions?

I have a spreadsheet that is full of credit card application dates. Chase has a rule where it will automatically decline a credit card application if you have received more than 5 credit cards, from any institution, in the last 24 months. With that said, I want to do a formula to figure the...

Hey guys. Is it possible to RoundUp the figure returned in my textbox (Price) to be a whole round number? For example, I want '113.2184', to roundup to '114' Price = Application.WorksheetFunction.VLookup(TextBox1.Text, Range("AllProds2"), 10, 0) I don't mind if it rounds up to: '114' or...