Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.19 seconds.

  1. Re: Find average of last three occurences (data in two columns)

    I'm sorry but at the moment I'm not seeing why that should be.
    Below is a shot of my test, with some blanks, with some text entry for product and price and with some formulas generating product and...
  2. Re: Find average of last three occurences (data in two columns)

    Maybe like...
    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  3. Replies
    4
    Views
    181

    Re: Vlookup based on Moving Target range

    As far as I understand what you are trying to acheive then, like.....
    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  4. Replies
    4
    Views
    181

    Re: Vlookup based on Moving Target range

    Can you not then use INDEX(AA) MATCH("L") ?
  5. Replies
    7
    Views
    225

    Re: Excel Formula

    Similar questions here.
    However, if the <<<<< and >>>>> are a common feature of the text and all numbers to extract to same cell, then maybe like....
    <b>Excel 2010</b><table cellpadding="2.5px"...
  6. Re: Formula works on paper, but not in spreadsheet. Error = a specific expression is added to desired result.

    Try...


    =$X2-MIN($X2*$Y2%,IF($AG$6>0,$AG$6,9^9))-MIN($X2*$AG$3%+$AG$4,$X2*$AG$7%+$AG$8)

    Hope that helps.
  7. Re: Return single value based on several drop down lists

    Assuming that you will have a table defining the Cost Centers then, maybe like.....
    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  8. Replies
    1
    Views
    95

    Re: make cell blank if greater than

    Maybe along these lines if the range is contiguous yet variable


    Sub test()

    Set Rng = Selection ' or specify in some other way


    Rng.Value = Evaluate("IF(" & Rng.Address & ">30, """"," &...
  9. Replies
    3
    Views
    226

    Re: so close yet quite can't get in

    Do you actually need anything other than an indication of a break taken late or not at all? <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border:...
  10. Re: Nested Formulas and automated cells updates

    You cannot attach a file so detail of what you have/want is not entirely clear to me, nor likely to others, judging by the lack of response.

    Does something like the below approach offer any...
  11. Replies
    2
    Views
    163

    Re: Formula to calc YTD Target

    I think Steve and I might be similarly confused.

    If D7 is the year that you want the return for, but only up to the equivalent of today, then you need like....


    ...
  12. Re: Subtracting from a total and show remaning

    If you are wanting something other than what I have provided then I am afraid that it is not clear to me.
    My formula works top to bottom on the account list and allocates only for accounts that are...
  13. Re: Subtracting from a total and show remaning

    It does that now if the first selected value >= 500
    Do you mean if 500 for any selected value it should be used in preference?
    Can you illustrate that scenario?
  14. Re: Subtracting from a total and show remaning

    mewingpants
    Maybe.....
    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  15. Replies
    2
    Views
    121

    Re: Automatic Sort Number From Small

    Maybe along these lines....<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  16. Replies
    5
    Views
    374

    Re: Blank entry in drop down list

    Sorry, but I cannot appear to get rid of the extra blank row while using the .List method.
  17. Replies
    5
    Views
    374

    Re: Blank entry in drop down list

    I'm not exactly sure what you have or where when you are using that code but if it is a Userform Combo then I imagine that I would be using like below in say the userform Initialize...Private Sub...
  18. Re: Index match to replace dynamic named range

    Not sure if this has potential to speed things up for you or not....

    If confirmed Ctrl + Shift + Enter then E1 will return the range values.
    Otherwise, G1 will return the range address for use...
  19. Replies
    5
    Views
    374

    Re: Blank entry in drop down list

    With just the header R1 and ANYTHING in R2
    lastrowr = Sheets("INFO").Cells(Rows.Count, "R").End(xlUp).Row will return 2
    Then resizing R2 by 2 will include R2 (N/R) AND R3 which is blank. Same...
  20. Replies
    2
    Views
    226

    Re: Art work pricing formula

    Are you envisioning something like....
    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  21. Re: Formula to Count Matched reference as 1, regardless if are multiples matched in Range/Reference.

    Andy. This is a bit cumbersome looking but if I understand correctly, it may set you an the right path...

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color:...
  22. Thread: Formula Help

    by Snakehips
    Replies
    9
    Views
    307

    Re: Formula Help

    I was about to post my UDF solution this morning, only to find that Peter had pipped me to it. So I didn't bother.
    A quick test appeared to show both giving a similar result other than Peter's...
  23. Replies
    4
    Views
    239

    Re: worksheet copy

    Try...


    For Each Sheet In ActiveWorkbook.Sheets
    If Sheet.Name Like "*" & ActiveCell.Offset(0, 13).Value & "*" Then
    Sheet.Activate
    Set wsN = ActiveSheet
    ...
  24. Replies
    14
    Views
    341

    Re: Confusing Code

    Kevin, be more specific and use... Target.Value = "" and that should hopefully do it.
  25. Re: VBA - add comment to cell that script highlights

    Mike, try...


    Sub Highlight_Cell_frm_Array()

    Dim vntWords As Variant
    Dim lngIndex As Long
    Dim rngFind As Range
    Dim strFirstAddress As String
    Dim lngPos As Long
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4