Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 1.63 seconds; generated 13 minute(s) ago.

  1. Replies
    3
    Views
    127

    Re: If CountIf - Help Displaying Blank Cell

    You are welcome. Glad it works for you!
    :)
  2. Replies
    3
    Views
    127

    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...
  3. Replies
    3
    Views
    100

    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...
  4. 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...
  5. Thread: Sort by cities

    by Joe4
    Replies
    4
    Views
    98

    Re: Sort by cities

    You are welcome.
    Glad we were able to help.
  6. Replies
    3
    Views
    100

    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...
  7. Replies
    17
    Views
    381

    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...
  8. Thread: Sort by cities

    by Joe4
    Replies
    4
    Views
    98

    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...
  9. Replies
    17
    Views
    381

    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...
  10. Replies
    17
    Views
    381

    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....
  11. 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...
  12. Replies
    17
    Views
    381

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

    If I understand your question correctly, then I do not think that link is doing the same thing that you want, so I don't think you will be able to adopt those methods.
  13. Replies
    17
    Views
    381

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

    Excel can either have a formula, or a hard-coded value in a cell, and one cannot turn to the other without it being done manually, or by VBA.
    So I think you answer requires VBA. You would need...
  14. Replies
    8
    Views
    471

    Re: Converting number to fixed length field

    Mike,

    If the entry is truly a numeric entry (maybe with formatting to show decimals):


    Then your code wouldn't work in this case:

    Now, if 10152.00 was entered as Text, then it would work...
  15. Replies
    8
    Views
    471

    Re: Converting number to fixed length field

    I think you are overcomplicating this unnecessarily.
    Just multiply your original number by 100, and zero pad that.
  16. Replies
    1
    Views
    52

    Re: Excel Issue between dates (specific month)

    Assuming that your dates are in cells A1 and A2, and A2 is always after A1, this formula will return a "Yes" if any August date falls in the range, and a "No" if it does not.
    ...
  17. Re: Combine/Join 2 tables and get an output in 3rd table

    Sorry, we need to remove the JOIN part too, and add the other table to the FROM clause, i.e.

    SELECT (A.[First Name]+' '+A.[Last Name]) AS [Employee Name], A.[Person Number], A.[Work Email],...
  18. Re: Combine/Join 2 tables and get an output in 3rd table

    Is "Cost Center" in Table B a Text/String or Numeric field?
    If numeric, try this:
    Remove the "ON" clause from the query, and instead add:

    WHERE MID(A.[Cost Center],4,8)=B.[Cost Center]
    if "Cost...
  19. Re: VBA Change Entire Columns with specific header to Value instead of Formulas

    You are welcome.
    Glad I was able to help!
    :)
  20. Replies
    2
    Views
    54

    Re: Combining multiple cells into one

    Welcome to the Board!

    What version of Excel are you using? If you are using Excel 2016 or newer, I think this can be done easily with the TEXTJOIN function (see:...
  21. Replies
    17
    Views
    381

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

    It is important to understand exactly what that part of the formula is doing:
    TODAY()-D7
    It is taking the past date in cell D7, and seeing how many days it is in the past from today.

    If you do...
  22. Replies
    9
    Views
    269

    Re: Conditional formatting highlight

    Did you try locking down the references like I showed in the last post and see if that solves your issue?
  23. Replies
    17
    Views
    381

    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,"")
  24. Thread: Count If

    by Joe4
    Replies
    4
    Views
    93

    Re: Count If

    You are welcome.
  25. Replies
    30
    Views
    804

    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...
Results 1 to 25 of 144
Page 1 of 6 1 2 3 4