1. G

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

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

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

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

    Changing linking so instead of being between tables, it is linking between ranges

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

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

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

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

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

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

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

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

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

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

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

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

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

    VBA needed please

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

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

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

Some videos you may like

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...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...