Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 1.29 seconds.

  1. Replies
    2
    Views
    44

    Re: IF statement based on date

    Try:

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

    by Joe4
    Replies
    4
    Views
    39

    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.
  3. 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...
  4. Replies
    11
    Views
    327

    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...
  5. Replies
    36
    Views
    1,032

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

    Re: If CountIf - Help Displaying Blank Cell

    You are welcome. Glad it works for you!
    :)
  7. Replies
    3
    Views
    141

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

    by Joe4
    Replies
    4
    Views
    103

    Re: Sort by cities

    You are welcome.
    Glad we were able to help.
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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....
  16. 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...
  17. Replies
    17
    Views
    388

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

    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...
  19. Replies
    8
    Views
    1,123

    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...
  20. Replies
    8
    Views
    1,123

    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.
  21. Replies
    1
    Views
    63

    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.
    ...
  22. 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],...
  23. 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...
  24. Re: VBA Change Entire Columns with specific header to Value instead of Formulas

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

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