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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top