incomplete

  1. M

    MS Access Query

    Could someone please let me know if my query is correct...I keep getting a syntax error? iif(Sum([Assignment_test]![CountOfPlanNumber]+[Assignment_test]![InvComplete])=0, "Complete", "Incomplete"))) AS Expr2 FROM Assignment_test;
  2. A

    Ebook

    I just attended a session where a free ebook was mentioned on dynamic arrays. I was given an incomplete link. Can I get the link?
  3. A

    formula to find if value meets criteria in another column

    Hi all, I'm having trouble figuring out a formula in excel, and was hoping someone may be able to assist. I have data for a number of people and the status of their work in another column. Essentially want to calculate an overall status. If they have atleast one work complete in 2018, then...
  4. P

    Averaging without ZEROs and incomplete months

    Hi, I have a complex dashboard that uses box plots, and other statistical formulas to come up with a forecast for how many Call Volumes are coming into the suppport center. The problem I am having is the fields below point to a 9 month calendar and when we are in the current month, the volume...
  5. D

    2 if(and statements

    GOOD AFTERNOON, I HAVE STRUGGLED ENOUGH TRYING THIS NOW ITS TIME TO ASK THE GURUS. WORKING WITH 2 COLUMNS: F WILL ONLY CONTAIN 0 OR 1 H WILL ONLY CONTAIN YES OR NO SHOULD IT BE IF AND OR? PLEASE HELP...
  6. D

    Comparing Values in Cells

    Hi all, I need help for this. A1 A2 A3 0 0 just Blank (if both cell contains 0) 12 12 Completed (if A1 and A2 are equal) 12 14 incomplete (if A1 and A2 is not equal) I just want output in A3 to be displayed. Thank you guys.
  7. B

    Deosnt End with 4 DIGIT Number

    Hi , I have a column of address . I want to sort out the complete and incomplete address Example - Complete address ends with 4 Digit Number as this Incomplete doesnt end with 4 digits <tbody> ZETLAND NSW 2017 true YOUNG NSW 2594 true YEPPOON QLD 4703 true WOOROLOO WA 6558 true 1...
  8. S

    Formula

    Hi there, I have a list of tasks that I want to summarise by % on how many are complete or incomplete etc. What formula is best to use? Thanks!
  9. J

    Search criteria in one column and find maximum corresponding value in another column, then show maximum value in every row that matches original crite

    Hi. I would really appreciate some help with the below. Column A is the order number, B is the status of the indvidual line, C reflects B numerically with a "1" for complete and "0" for incomplete. If A1 = A2 then D is blank, if there is a difference then the completion % is displayed...
  10. andrewb90

    Code runs perfect until adding excel restart

    Hello all, I have a sub that works nearly perfectly, except that excel seems to lag after running. My solution to the lag was always close and reopen excel. I finally added that to the sub (using call at the very end) yet now the original sub does not run in its entirety. I'm at a loss as to...
  11. K

    Incomplete Pasting/Corrupt File? Excel 2010

    Hello everyone, I have an issue in excel 2010 where it will not fully paste the information I'm trying to copy/paste. Sometimes less than half the data is transferred over, as if it doesn't recognize the other pieces of data. (I'm copy/pasting in between workbooks, sheets, and directly from the...
  12. C

    Data Validation allows only part of list

    Hi All, I have a worksheet in which I have a data validation that allows values from the "names" list. Originally the "names" list was static and all was well. Then I had to make it dynamic and the data validation subsequently began to show only the first 17 names (out of ~500). When I...

Some videos you may like

This Week's Hot Topics

Top