Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 1.29 seconds.

  1. Re: VBA to convert column range of date to long int

    From what I found here: https://social.technet.microsoft.com/wiki/contents/articles/12814.active-directory-lastlogontimestamp-conversion.aspx, it appears that the formula you posted should work.
    ...
  2. Re: VBA to convert column range of date to long int

    That statement, in and of itself, is incomplete, and does not give enough information. A simple "data type" conversion will not do what you want.
    You can easily convert a date to an Integer on an...
  3. Re: Conditional formatting based on condition of one cell and value of another

    Welcome to the Board!

    You cannot base Conditional Formatting off of the formatting applied by other Conditional Formatting, but you can apply the same logic.

    Let's say that your date is in cell...
  4. Re: VBA to convert column range of date to long int

    Wow, I would love to know the logic behind that formula, what is actually really supposed to represent! I have never seen that type of conversion done on a date before.

    In any event, you could...
  5. Replies
    4
    Views
    52

    Re: Access: Keep Navigation pane closed

    I often hide it using File -> Options -> Current Database -> Navigation and uncheck the "Display Navigation Pane" box, though that doesn't lock it down or prevent them from using F11 to see it, or...
  6. Re: VBA to convert column range of date to long int

    Please explain exactly how you get from 10/15/2019 to 132155712000000000.
    What is the logic?
  7. Re: VBA to convert column range of date to long int

    Is your date entered as a valid date or text?
    What exactly are you converting it to?
    I ask because Excel already stores dates as integers, specifically the number of days since 1/0/1900. So all...
  8. Replies
    13
    Views
    353

    Re: Conditional formatting highlight

    You have a few issues, including referencing the wrong column in your COUNTIF formula, not locking down the correct ranges, and using WILDCARDS in your criteria.
    Remove ALL your current Conditional...
  9. Re: highlight cell according to date difference

    Try this slight variation:

    Private Sub Worksheet_Change(ByVal Target As Range)

    Dim rng As Range
    Dim cell As Range

    Set rng = Intersect(Target, Range("F5:F10000"))

    ...
  10. Replies
    2
    Views
    64

    Re: IF statement based on date

    Try:

    =IF(YEAR(C9)=2019,F9+F10,0)
  11. Thread: #Value Error

    by Joe4
    Replies
    6
    Views
    60

    Re: #Value Error

    I don't think it like setting numeric fields equal to "".
    What if you try:

    =IF(ISBLANK(C8),0,H7+F8-G8)
    If that does not work, please tell us the contents of C8, H7, F8 and G8.
  12. Re: highlight cell according to date difference

    So, do you only want it to check that as you enter the value in the cell (and not done the road, for values already entered in)?
    If so, you can use VBA to do that.

    Righ-click on the sheet tab...
  13. Replies
    13
    Views
    353

    Re: Conditional formatting highlight

    I don't know how much more able I will be able to help without seeing your workbook.
    As I mentioned before, I cannot download files from my current location, but I can from my home.
    So, if you are...
  14. Replies
    36
    Views
    1,035

    Re: Code needed for Max & Min Values

    Perhaps it will speed up some it you disable screen updates and calculations until the end of the code too:

    Private Sub Worksheet_Calculate()

    Dim cell As Range

    ' Exit if A1 not...
  15. Replies
    3
    Views
    144

    Re: If CountIf - Help Displaying Blank Cell

    You are welcome. Glad it works for you!
    :)
  16. Replies
    3
    Views
    144

    Re: If CountIf - Help Displaying Blank Cell

    Is this what you are looking for?

    =IF(COUNTBLANK('Document Request'!K10:K40)=31,"",IF(COUNTIF('Document Request'!K10:K40,"Outstanding")>0,"Outstanding",IF(COUNTIF('Document...
  17. Replies
    3
    Views
    103

    Re: Why the lag before Excel calculates?

    I came across it some years ago (10+) when supporting someone who had workbooks of Excel files with 20-30 sheets of data, spanning dozens of columns and tens of thousands of rows, mostly with VLOOKUP...
  18. Re: VBA to search a column for the first instance of a date within a designated month

    Are you just trying to get the SUM of a particular month?
    If so, instead of doing something like that, why not use a SUMIF, SUMIFS, or SUMPRODUCT formula to sum all the records where your designated...
  19. Thread: Sort by cities

    by Joe4
    Replies
    4
    Views
    103

    Re: Sort by cities

    You are welcome.
    Glad we were able to help.
  20. Replies
    3
    Views
    103

    Re: Why the lag before Excel calculates?

    Whoa! That is a lot of cells with calculations!

    With Auto Calculation, Excel determines which cells need to be re-calculated when a change to the data is made. It does this by tracking...
  21. Replies
    17
    Views
    388

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

    Just knowledge of the different functions available and their capability (so experience, really). There aren't too many hard-and-fast rules regarding whether VBA is needed or not. Things like date...
  22. Thread: Sort by cities

    by Joe4
    Replies
    4
    Views
    103

    Re: Sort by cities

    You don't even need to split the columns, just add a helper column with the following formula (for an entry in cell A2):

    =MID(A2,FIND("(",A2),LEN(A2))
    You can then sort by the helper column (and...
  23. Replies
    17
    Views
    388

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

    You are welcome. The keys are the ROW and MOD functions.

    ROW() will return the row number of whatever cell the formula is placed in.
    To see this, you can simply enter =ROW() in any cell and see...
  24. Replies
    17
    Views
    388

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

    LOOKUP will return whatever is found in the cell, be it a number, text, or date.
    OFFSET is a range function.

    Regarding your question, a few questions about it, that may make this really easy....
  25. Re: Week numbers but in the same month only add up

    Where are the values you are adding up, and where are you putting these SUMs?
    How are you currently getting the SUM? With a SUMIF or SUMIFS formula?
    If so, you should able to do what you want with...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4