Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    6
    Views
    120

    Re: Excel Function

    Ok I figured out the new code.

    Thanks again for all your help
  2. Replies
    6
    Views
    120

    Re: Excel Function

    I tried changing the code but it seems that since the digits begin with a zero it changes the calculation/outcome

    Have a followup request using the same sets but extracting the 1st digit from each...
  3. Replies
    6
    Views
    120

    Re: Excel Function

    Thank you soo much Eric
    Works like a charm
    Thanks
    Steve
  4. Replies
    6
    Views
    120

    Excel Function

    Hi everyone,

    Need help with a function/vba

    I have the following 5 numbers from 1 to 30 in ascending order:

    Notice below adding all the results would equal 5 (1-1-1-1-1 =5, 2-2-1-0-0 = 5,...
  5. Thread: Formula Help

    by ststern45
    Replies
    9
    Views
    203

    Re: Formula Help

    Pete,
    Great work as always!!
    Formulas and code work super.

    Thank you so much!!
  6. Thread: Formula Help

    by ststern45
    Replies
    9
    Views
    203

    Re: Formula Help

    Hi Peter,

    Calculating repeat digits from the original set such as 3 exact digits 3-3-3 or 2 digits that are the same such as 7-8-8 (see example below) are tricky. My calculations which are...
  7. Thread: Formula Help

    by ststern45
    Replies
    9
    Views
    203

    Re: Formula Help

    Hi Peter,

    7-7-2 is at the bottom of the list.
    Your correct A10 = 7, B10=7, and C10=2

    Example 1

    A1=9
    B1=1
    C1=5
  8. Thread: Formula Help

    by ststern45
    Replies
    9
    Views
    203

    Formula Help

    Hi everyone,

    I would like to find a formula that will calculate how may cells back when a digit appeared.

    For example,
    A1 = 2
    B1 = 2
    C1 = 2

    2-2-2
  9. Re: Excel Formula - How Many Times a Value Appears

    Thanks the A10 contained the most recent value = 1
    I only tried the =MATCH(FALSE,A20:A1000=A10,0)-1 and worked to perfection.

    Sorry about the confusion. I did change the cell to A20 instead of...
  10. Excel Formula - How Many Times a Value Appears

    Hi everyone,

    Have a request for a formula.

    In cell A10 I have a value of 1

    Cell A15 I would have the formula that would do the following:

    I know the value 1 is in cell A20. I want to...
  11. Replies
    3
    Views
    239

    Re: Repeat Digits Formula

    Thankyou for all your help. Very much appreciated!!
  12. Replies
    3
    Views
    239

    Repeat Digits Formula

    Hi Everyone,

    I'm looking for a formula that will calculate how many digits 0,1,2,3 repeated from the previous range.

    For example,
    Range Y1:AC1 contains the following:
    Y1= 2
    Z1= 3
    AA1=1...
  13. Replies
    3
    Views
    77

    Re: VBA Code Help

    OK Thanks for all your help. I changed the code and worked.

    Thanks you!!
  14. Replies
    3
    Views
    77

    VBA Code Help

    I have a list of 324 sets of data in columns that are identical in size

    I tried using Record Macro then changing a few lines of code but received errors on a few lines of code.
    The new lines of...
  15. Formula Help - High to Low and Odd to Even

    Hello everyone,

    I have 2 requests but they refer to the same cell range

    Cell range = A1 through C1

    Example: Each cell can have a value from 0 through 9

    A1 = 0
    B1 = 0
  16. Replies
    1
    Views
    143

    Conditional Format Question

    Hello everyone,

    I need help with conditional formatting formula.

    The 1st range of values in cell range R10:R12
    Example
    R10 = 9
    R11 = 8
    R12 = 2
  17. Replies
    3
    Views
    189

    Formual Help - Duplicate Dates

    Hi everyone,

    Need help with a formula.

    In cell range A1:A365 I have the numbers 1 through 365

    In cell range B1:B365 I have the dates. Most recent date in cell B1 March 1, 2019

    In cell B2...
  18. Replies
    4
    Views
    277

    Re: Excel Question

    Thanks so much.

    Works like a charm!!
  19. Replies
    4
    Views
    277

    Excel Question

    I have a excel question:

    Is there a way to count the number of times a number repeats in a string before another

    number replaces it.

    I am talking about consecutive repeats within a string...
  20. Replies
    3
    Views
    143

    Re: Conditional Format Question

    Thanks!
  21. Replies
    3
    Views
    143

    Conditional Format Question

    Hi everyone,

    I have a question for creating a formula for conditional formatting.

    In cell A1 has a value 001

    In cell B1 has the value 00

    I would like to highlight cell A1 if the 1st 2...
  22. Thread: Formula Help

    by ststern45
    Replies
    24
    Views
    1,024

    Re: Formula Help

    Excellent Eric.
    Works to perfection.
    Thank you so much.
    Steve
  23. Thread: Formula Help

    by ststern45
    Replies
    24
    Views
    1,024

    Re: Formula Help

    Hi Eric,

    I'm using the formula you provided and it works to perfection for 3 digits.
    Using the same idea and calculating when just 1 digit appears instead of 3.

    Also using the same idea and...
  24. Thread: Formula Help

    by ststern45
    Replies
    24
    Views
    1,024

    Re: Formula Help

    Have an add on question:
    Is it possible to change the formula below that counts 3 digits to count just 1 digit...
  25. Thread: Formula Help

    by ststern45
    Replies
    24
    Views
    1,024

    Re: Formula Help

    Eric,
    You have the same!!
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4