# Search:

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

Page 1 of 6 1

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

by Snakehips
Replies
4
Views
171

### 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. ## Thread: Find average of last three occurences (data in two columns)

by Snakehips
Replies
4
Views
171

### 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. ## Thread: Vlookup based on Moving Target range

by Snakehips
Replies
4
Views
147

### 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. ## Thread: Vlookup based on Moving Target range

by Snakehips
Replies
4
Views
147

### Re: Vlookup based on Moving Target range

Can you not then use INDEX(AA) MATCH("L") ?

by Snakehips
Replies
7
Views
202

### 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....
6. ## Thread: Formula works on paper, but not in spreadsheet. Error = a specific expression is added to desired result.

by Snakehips
Replies
7
Views
200

### 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. ## Thread: Return single value based on several drop down lists

by Snakehips
Replies
2
Views
130

### 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. ## Thread: make cell blank if greater than

by Snakehips
Replies
1
Views
86

### 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. ## Thread: so close yet quite can't get in

by Snakehips
Replies
3
Views
197

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

by Snakehips
Replies
1
Views
158

### 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. ## Thread: Formula to calc YTD Target

by Snakehips
Replies
2
Views
136

### 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. ## Thread: Subtracting from a total and show remaning

by Snakehips
Replies
7
Views
264

### 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. ## Thread: Subtracting from a total and show remaning

by Snakehips
Replies
7
Views
264

### 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. ## Thread: Subtracting from a total and show remaning

by Snakehips
Replies
7
Views
264

### 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. ## Thread: Automatic Sort Number From Small

by Snakehips
Replies
2
Views
89

### 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. ## Thread: Blank entry in drop down list

by Snakehips
Replies
5
Views
338

### 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. ## Thread: Blank entry in drop down list

by Snakehips
Replies
5
Views
338

### 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. ## Thread: Index match to replace dynamic named range

by Snakehips
Replies
4
Views
224

### 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. ## Thread: Blank entry in drop down list

by Snakehips
Replies
5
Views
338

### 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. ## Thread: Art work pricing formula

by Snakehips
Replies
2
Views
211

### 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. ## Thread: Formula to Count Matched reference as 1, regardless if are multiples matched in Range/Reference.

by Snakehips
Replies
7
Views
496

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

by Snakehips
Replies
9
Views
283

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

by Snakehips
Replies
4
Views
224

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

by Snakehips
Replies
14
Views
325

### Re: Confusing Code

Kevin, be more specific and use... Target.Value = "þ" and that should hopefully do it.

by Snakehips
Replies
2
Views
95