# started

1. ### Filter Everything, Except for a Single Criteria

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...
2. ### Pivot Table Sub Total

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...
3. ### Sumif formula for time ranges

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
4. ### error message

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...

6. ### Return the current quarter between two dates

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...
7. ### Analyze % moving in right direction?

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...
8. ### index match subsequent values between 2 dates

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...
9. ### COUNTIFS - Summary of all data

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")
10. ### getting #value! instead of total

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
11. ### Alignment issues

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...
12. ### VBA range

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...
13. ### Formula Efficiency - Advice please (perhaps useful to many users)

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...
14. ### SUMIFS for negative numbers

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...
15. ### Sumif problem

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...
16. ### VBA to change a formula in a cell with a command button?

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...
17. ### Excel has started freezing / stalling when I merely copy a range

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...
19. ### Bring header value in cell for first non-blank cell in row

I would like to find a way to complete the last column using a formula. The results should match year started column. Any suggestions? <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color...
20. ### The best "Excel-ist" you know?

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...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...