# Search:

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

Page 1 of 6 1

## Search: Search took 0.05 seconds.

by ststern45
Replies
6
Views
120

### Re: Excel Function

Ok I figured out the new code.

Thanks again for all your help

by ststern45
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...

by ststern45
Replies
6
Views
120

### Re: Excel Function

Thank you soo much Eric
Works like a charm
Thanks
Steve

by ststern45
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,...

by ststern45
Replies
9
Views
203

### Re: Formula Help

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

Thank you so much!!

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...

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

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. ## Thread: Excel Formula - How Many Times a Value Appears

by ststern45
Replies
5
Views
224

### 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. ## Thread: Excel Formula - How Many Times a Value Appears

by ststern45
Replies
5
Views
224

### 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. ## Thread: Repeat Digits Formula

by ststern45
Replies
3
Views
239

### Re: Repeat Digits Formula

Thankyou for all your help. Very much appreciated!!
12. ## Thread: Repeat Digits Formula

by ststern45
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. ## Thread: VBA Code Help

by ststern45
Replies
3
Views
77

### Re: VBA Code Help

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

Thanks you!!
14. ## Thread: VBA Code Help

by ststern45
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. ## Thread: Formula Help - High to Low and Odd to Even

by ststern45
Replies
1
Views
132

### 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. ## Thread: Conditional Format Question

by ststern45
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. ## Thread: Formual Help - Duplicate Dates

by ststern45
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...

by ststern45
Replies
4
Views
277

### Re: Excel Question

Thanks so much.

Works like a charm!!

by ststern45
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...

by ststern45
Replies
3
Views
143

Thanks!
21. ## Thread: Conditional Format Question

by ststern45
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...

by ststern45
Replies
24
Views
1,024

### Re: Formula Help

Excellent Eric.
Works to perfection.
Thank you so much.
Steve

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...

by ststern45
Replies
24
Views
1,024

### Re: Formula Help

Is it possible to change the formula below that counts 3 digits to count just 1 digit...