Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.14 seconds.

  1. Replies
    5
    Views
    756

    Re: How can I post attachments here?

    Fluff, perhaps you missed the banner on EF? Management on that forum have had multiple requests made to help us combat spam. They have ignored those requests for ages, so now we are just leaving...
  2. Replies
    1
    Views
    157

    Re: Average of column depending on filter

    Have a look at using SUBTOTAL for this
  3. Replies
    1
    Views
    174

    Re: Excel average/averageif question

    Take a look at using averageif() for this
  4. Replies
    2
    Views
    234

    Re: Complex Formula; Formula or VBA?

    maybe it is lol?

    You can probably do this with AVERAGIFS and LARGE
    =averageifs($C$2:$C$1000,$D$2:$D$1000,15000,$C$2:$C$1000,">="&large(if($D$2:$D$1000=15000,$C$2:$C$1000),3))
    entered using CTRL...
  5. Re: How to return same value within series of identical titles but only 1 value among NAs

    If you could enter the PN into the 1st instance (C1), you could use =C1, copied down (all teh way), then just enter the new PN when you get to the next title
  6. Re: Overwriting formula result with another cell

    Short answer - no.

    You can either have a formula in a cell, OR data. 1 will always over-write the other
  7. Replies
    8
    Views
    140

    Re: Looking for a empty cell in formula

    OK then, based on your comment in post #1 , you have your formula the wrong way round?

    =IF('Up to Date'!G2<>"";'Up to Date'!$H$2;"")

    Although my preference is to test for "nothing" this way......
  8. Re: Formula uses more levels of nesting than allowed

    1. If you start at the highest and work down, you can cut down on the IF's
    2. Looks to me like there is a mathematical regression there?
    10-(11:46-0:01)/2
    something like that?
  9. Replies
    8
    Views
    140

    Re: Looking for a empty cell in formula

    Looks to me like you are referencing the same sheet in that formula?
  10. Replies
    21
    Views
    909

    Re: Making presence list

    And Im guessing that "Monday" will change each day?
  11. Replies
    4
    Views
    216

    Re: Top "N" List with Selection Criteria

    See if this will help?

    A
    B
    C
    D

    1KEYSalesColorName
  12. Replies
    21
    Views
    909

    Re: Making presence list

    You could probably just filter on the day you want to see?
  13. Thread: Reverse Link

    by FDibbins
    Replies
    2
    Views
    204

    Re: Reverse Link

    Is this a homework assignment?
  14. Replies
    9
    Views
    341

    Re: Conditional Formatting

    Good stuff :) As long as you got where you wanted to be :)
  15. Replies
    12
    Views
    376

    Re: Help with IF Statement

    I agree, thats why I said your LEN should help in that case :)
  16. Re: Find SKU price from a history of prices if i know the sales date

    If you want to bring back the SKU price based on the SKU date,you wont be able to use vlookup - the search criteria needs to be in the very 1st column of the range.
    Because you need to test for 2...
  17. Re: Eva is creating the first VBA code in her life, please help her :(

    If this is exactly the same routine each time (deleting same sheets, converting same formulas, etc) have you tried using the macro recorder. It will record and replay each and every thing you do. ...
  18. Re: Repeat at regular interval after first occurrence

    If you only have 12 months across(A:L), and may rows down, why dont you just do something like...
    B2=55
    C2=66
    D2=77
    E2=B2
    then just copy that across as needed.
    You can then copy from E2:L2 down...
  19. Replies
    12
    Views
    376

    Re: Help with IF Statement

    jtakw, sandy's TRIM should have picked that up (unless it was a carriage return)?
    But LEN should ID any differences in characters
  20. Replies
    9
    Views
    341

    Re: Conditional Formatting

    Actually, yes it will, I dont have 365, but I seriously doubt they would have changed that.
    Did you use the "use Formula" option? :)
  21. Replies
    6
    Views
    225

    Re: Find duplicates starting from today

    1. Are these real dates, or text dates?
    2. I have a feeling that formulas will probably be faster than VBA
  22. Re: Selecting range in a column between two values

    x-posted here
    https://www.excelforum.com/excel-programming-vba-macros/1237581-selecting-range-in-a-column-based-on-another-cell-value.html
  23. Re: Finding Fraction of 2 calculated fields in Pivot Table

    x-posted here
    https://www.excelforum.com/excel-charting-and-pivots/1237576-finding-fraction-of-2-calculated-fields-in-pivot-table.html
  24. Re: Formatting help to make large dataset pivot table ready

    Ok, but I still ask - even if you rearrange the top table to look like the bottom table, when you pivot the bottom table, wont it still just end up looking like the top table again?

    And again -...
  25. Replies
    1
    Views
    195

    Re: Preferred Method to aggregate daily data

    For me, I would add the data as you described - 1 day below the other, all on the same sheet. This keeps calcs (relatively) simple. Keep in mind that if this data is coming from a different...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4