started

ActiveSheet.Range("$A$8:$AH$1894").AutoFilter Field:=1, Criteria1:=Array( _ "NOT STARTED", "ON-HOLD", "STARTED"), Operator:=xlFilterValues ActiveSheet.Range("$A$8:$AH$1894").AutoFilter Field:=2, Criteria1:="NCR" Hello All, The Code above is working to filter only "NCR" (after Field...

Afternoon kind folks. I have a pivot table which I want to add a extra subtotal to. The pivot table shows a list of Business Reports in rows then the columns show the percentage complete by how well its done good/bad/not started etc. Currently I have to add an extra column on the worksheet...

Hi All Sorry for being a noob but I'm trying to fid a formula that will allocate the time spent on a job EDIT: More details in post#4

I am using Excel 2019 which I just download from Microsoft. I deleted the old Microsoft office which had word and excel because I was getting an error message. I am trying to enter stock symbols in column A and in column B I have the following =xlqprice(A3, "yahoo"). I have used this formula...

I started a thread that had a bad name so I started a new thread with a more meaningful name. The original thread is here https://www.mrexcel.com/forum/excel-questions/1098809-i-need-some-help-please.html#post5283211

Hello Excel Gurus! I'm trying to find a simple formula to give me the currentquarter between two dates. I have to do quarterly performance evaluations on mypersonnel; however, the traditional fiscal year quarters work for works for thepersonnel I have that have been here since 10/1/2018. For the...

The heartrate of patients were measured at two different times. The healthy range let's say is 60-90, and some patients started with values higher, some started with lower ones. How / with which formula do I analyze how many percent of the patients have moved in a right (or wrong) direction...

Trying to figure out an array formula that would pull all data between 2 dates. Here is what I started with: {=INDEX(Loan_ID,MATCH(1,((Transfer_Dates>=Begin_Date)*(Transfer_Dates<=End_Date)),0))} But that only returned the top value. Then I tried...

When trying to count a particular group (Group 1 or Group 2) I am getting the correct data (1) How to get the overall data (2) using COUNTIFS <tbody> Group Status Group 1 Not Started Group 2 Not Started </tbody> =COUNTIFS($B:$B,"Not Started",$A:$A,"Group 1")

when i paste this i get #value! =SUM(IF('Shirt Database'!A2:A500,'Goal Keeper List'!B61,SUMIF('Shirt Database'!$F$2:$F$500,{"sub on","sub off","started","injured"},'Shirt Database'!$K$2:$K$500))) TIA

Hi. I have an issues with alignment in the worksheet below. .For some reason the column headers have started behaving strangely. You can see, even thogh they are centre aligned and columns are plenty wide enough they have started to be misaligned. Please help! They have all of a sudden done...

I have a button on my spreadsheet that copies a worksheet and pastes it in a new workbook. This is my code: Private Sub cmdCopySheet_Click() Worksheets("home").Unprotect Password:="costings" Dim CopyMonth As String CopyMonth = Range("I13").Value...

Hello all, Please can anyone offer advice at to whether this is a good or bad habit. I have a number of workbooks that pass data between themselves. Rather than have links embedded within the myriad of different worksheets I have created a single sheet of "IMPORTED" values which the formulas...

Is there a way to use SUMIFS for negative numbers? What I started with: =SUMIFS(QA!M:M,QA!D:D,">="&Summary!B1,QA!D:D,"<="&Summary!B2) The result should be -11 (5 negative twos and 1 negative one) however the result is 258974 what I tried to fix it...

Dear friends and respected seniors :) I have this data starting from cell a1 to d8 :biggrin: A 2 5 5 A 3 5 12 B 6 12 -3 B 4 12 B 2 12 C 1 -3 C -6 -3 C 2 -3 I am comparing the contents of column A and summing up similar data from column B a1 and a2 has A, hence 2+3 = 5, a3, a4 and a5 have...

I have this code started in C12 and continues down to C31...... =IF(ROW()<$D$4+12,$F$4-((($F$4-($F$4/$B$4))/($D$4-1))*(ROW()-12)),"") There's a few things going on here but essentially the value will "turn down" in division based on a value in B4 and Full Scale in F4. I was thinking how...

When I highlight a range I want to copy and type Ctrl-C, the entire application freezes, and my mouse cursor becomes a spinner icon (i.e. indicating that Excel is thinking/processing), which prevents me from interacting with Excel at all...this usually lasts between 30 and 120 seconds before the...

So we will eventually have three spreadsheets, but for now we're getting the ball rolling with two. The first sheet is for individual employees to keep track of issues that arise. Various columns to track the aspects of each issue. I wanted to have the data automatically written from the...

I would like to find a way to complete the last column using a formula. The results should match year started column. Any suggestions? Book1ABCDEFGHI1Name20142015201620172018Grand TotalYear StartedYear Started using formula2Name 1181820163Name 212152720174Name 329427120165Name 4292920186Name...

This is just an open topic of discussion I've been curious about and would like to hear from the community. I remember when I had just turned 20 and learned excel was more than just a bunch of squares you can punch numbers into. Fast forward 10 years, I finally started diving into macros this...