Search:

Type: Posts; User: Joe4; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 1.25 seconds.

  1. Replies
    5
    Views
    84

    Re: IF x numbers of days have passed, do this.

    No, you do not need a helper column.
    If your date is in column D, you could do a formula like:

    =IF((TODAY()-D7)>=5,G7+H7,"")
  2. Thread: Count If

    by Joe4
    Replies
    4
    Views
    67

    Re: Count If

    You are welcome.
  3. Replies
    29
    Views
    255

    Re: excel 2002 convert numbers to mathematical

    Are there really question marks and dollar signs in your text data?
    If so, then you will need to remove those to make them actual numbers.
    A simple Find/Replace can do that, or it can be done via...
  4. Thread: Count If

    by Joe4
    Replies
    4
    Views
    67

    Re: Count If

    That counts how many are greater than 60. If you want the number between 0 and 60, try:

    =COUNTIFS(Sheet1!M:M,">=0",Sheet1!M:M,"<=60")
  5. Replies
    5
    Views
    84

    Re: IF x numbers of days have passed, do this.

    Something like this?

    =IF(E7>=5,G7+H7,"")
  6. Re: get rid of an error occurred trying to save import/export specification ''

    Can you try it on another computer?
    If so, do multiple databases have the same issue?
    If not, then I suspect that you might have an issue with Access, and might need to re-install it on your...
  7. Replies
    8
    Views
    223

    Re: Conditional formatting by merged cells

    "Target" is relevant with Event Procedures, which are event that automatically trigger and run VBA code.
    You are using a "Worksheet_Change" event procedure, which is VBA code tha tis automatically...
  8. Replies
    11
    Views
    134

    Re: Removing Duplicates with Timestamp

    Glad we were able to help.
  9. Thread: Nested IF formula

    by Joe4
    Replies
    9
    Views
    75

    Re: Nested IF formula

    You are welcome.
  10. Re: Adding a +1 to a Row when dragging across Columns

    Forget about the formula for a second.
    What is it that you are ultimately trying to do?
    Are you simply trying to create a column counter?
  11. Replies
    11
    Views
    134

    Re: Removing Duplicates with Timestamp

    Curious, which suggestion ended up working for you?
  12. Replies
    11
    Views
    134

    Re: Removing Duplicates with Timestamp

    You can determine if it is date or text by using a formula like this (for an entry in cell A1):
    =ISNUMBER(A1)
    If it returns TRUE, it is valid date. If it returns FALSE, it is text.

    If it is...
  13. Thread: Nested IF formula

    by Joe4
    Replies
    9
    Views
    75

    Re: Nested IF formula

    Your conditions seem a bit confusing, but maybe something like this:

    =IF(COUNTIF(I15:L15,"NA")=4,"NA",IF(COUNTIF(I15:L15,"N")>0,"N",IF(COUNTIF(I15:L15,"Y")>0,"Y","")))
  14. Replies
    29
    Views
    255

    Re: excel 2002 convert numbers to mathematical

    Can you post an example of any number on your sheet, what it looks like?
    Then, for that exact value, let's say it is in cell A1.
    What does this formula return?
    =LEN(A1)
  15. Replies
    1
    Views
    31

    Re: Save cell range as .scr on desktop

    Duplicate, re-posted here: https://www.mrexcel.com/forum/excel-questions/1112643-save-selected-range-script.html

    Please do not post the same question multiple times. All clarifications,...
  16. Re: "Be careful! Parts of your document may include personal information that cannot be removed by the document inspector"

    It is not the code that is causing the issue (it is a setting, as Mark points out), but you may be able to handle it by code.
    See here for various solutions/workarounds to this issue:...
  17. Replies
    7
    Views
    76

    Re: Help me with entering times in Excel

    Here is a good article that shows you to apply the Time Data Validation Mark is talking about:
    https://wmfexcel.com/2014/08/10/data-validation-time/
  18. Re: VBA Change Entire Columns with specific header to Value instead of Formulas

    Assuming my assumptions above are correct (header in row 1, change ALL columns starting with "AIFinal", then this code should do what you want:

    Sub MyCopyValueMacro()

    Dim c As Long
    Dim...
  19. Re: Cannot find contact for administrator to request attachment function

    That is correct, attachments are not allowed on this Board.
    This is a Sticky about it, right in this "About This Board" forum: https://www.mrexcel.com/forum/about-board/508133-attachments.html
  20. Replies
    5
    Views
    48

    Re: Conditional formatting

    Just keep adding more criteria to the AND statement, i.e. to exclude columns 2 and 4

    =AND($R10="Yes",COLUMN()<>2,COLUMN()<>4)
    You can keep going with this to exclude even more columns. Just...
  21. Replies
    5
    Views
    78

    Re: Text into date format

    You are welcome.
  22. Re: How do you count occurances of something over a period of time?

    Welcome to the Board!

    Take a look at using the COUNTIFS formula, which allows you to count records meeting certain criteria.
    See here for an example on how to do a date/time range:...
  23. Replies
    7
    Views
    227

    Re: Conditional formatting highlight

    What range is this formula being applied to?

    I think you may need to lock down some more ranges, possibly.
    I am pretty sure the part in red needs to be $A3 to lock the column A reference down....
  24. Replies
    5
    Views
    48

    Re: Conditional formatting

    Yes.

    If you wanted to exclude the 4th column, you could use this formula:

    =AND($R10="Yes",COLUMN()<>4)
  25. Replies
    5
    Views
    78

    Re: Text into date format

    OK, to make it "2019", try this variation instead:

    =DATE("20" & RIGHT(A1,2),MID(A1,4,2),MID(A1,6,2))


    I cannot recreate that error, it works fine for me.
    Make sure that your formula is...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4