# Search:

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

Page 1 of 6 1

1. ## Thread: Too many arguements in IF function

by Peter_SSs
Replies
7
Views
39

### Re: Too many arguements in IF function

No, mine was untested - because i don't have the other workbook set up & I made a typo. Leave out this errant letter & try again. :oops:
2. ## Thread: Too many arguements in IF function

by Peter_SSs
Replies
7
Views
39

### Re: Too many arguements in IF function

You're welcome.

One further comment. I don't know if the data in your 'Staff info summary' sheet changes much but if any cell in columns B:DQ changes (that is over 120 million cells) that formula...
3. ## Thread: Too many arguements in IF function

by Peter_SSs
Replies
7
Views
39

### Re: Too many arguements in IF function

That depends on exactly what the formula is trying to achieve. My best guess is this.

=IF(\$D\$1="","",IF(VLOOKUP(\$D\$1,'[Employment Contract (Causual Employee) HC_May20180903_D_SB.xlsx]Staff info...
4. ## Thread: Ranking with Tiebreakers

by Peter_SSs
Replies
3
Views
111

### Re: Ranking with Tiebreakers

In that case, try this.

<b>Rank in Groups</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:8pt; background-color:#ffffff;...
5. ## Thread: Highlight only last ones that finds in end of the column

by Peter_SSs
Replies
12
Views
150

### Re: Highlight only last ones that finds in end of the column

.. even simpler:

Sub Highlight_Last_v2()
Dim c As Range, cFound As Range

For Each c In Range("C3:K3")
Set cFound = Range("C6:C37").Find(What:=c.Value, SearchDirection:=xlPrevious)
...

by Peter_SSs
Replies
11
Views
239

### Re: Need some help a formula Please

OK, thanks for the confirmation.
7. ## Thread: Highlight only last ones that finds in end of the column

by Peter_SSs
Replies
12
Views
150

### Re: Highlight only last ones that finds in end of the column

Another way with the same comment as Fluff about spaces v No spaces.
I also assume that it is a mistake that you have cell C33 coloured and not C35?

Sub Highlight_Last()
Dim c As Range,...

by Peter_SSs
Replies
5
Views
214

### Re: Student Choice

Yes, as written, people at the bottom of the list are getting higher priority than those at the top. And of course Choice 1 gets a higher priority than...
9. ## Thread: Vba - insert two columns after each occurrence of dept name

by Peter_SSs
Replies
6
Views
151

### Re: Vba - insert two columns after each occurrence of dept name

Try

Sub Insert_Columns_v2()
Dim c As Long

For c = Cells(3, Columns.Count).End(xlToLeft).Column + 1 To 8 Step -4
Columns(c).Resize(, 2).Insert
Cells(3, c).Resize(, 2).Value =...

by Peter_SSs
Replies
3
Views
112

### Re: Is there a SUM-minus formula instead of SUMPRODUCT?

.. or possibly just this?

=SUM(B2:B5)-SUM(A2:A5)
11. ## Thread: Merge two ranges together and wrap them into each other

by Peter_SSs
Replies
4
Views
148

### Re: Merge two ranges together and wrap them into each other

Since I had been playing around with this too, I will post my offering. This is a bit different as it does not require any looping. My testing showed it to be about 3 times as fast as the post 2 code...

by Peter_SSs
Replies
1
Views
74

### Re: Udf vlookup

Why do you need a UDF? Could we use standard worksheet formulas like this?
I've done this on a single sheet but it could easily be adapted to two.

<b>Check Mark Up</b><br /><br /><table...
13. ## Thread: Ranking with Tiebreakers

by Peter_SSs
Replies
3
Views
111

### Re: Ranking with Tiebreakers

I don't fully understand the requirement.
You said you wanted to use column L as the tiebreaker instead of the order in the sheet. I can see that in the green rows but in the two amber sections you...
14. ## Thread: Conditional formatting formula for cell

by Peter_SSs
Replies
6
Views
132

### Re: Conditional formatting formula for cell

No problem. They were basically your formulas. ;)
15. ## Thread: Conditional formatting formula for cell

by Peter_SSs
Replies
6
Views
132

### Re: Conditional formatting formula for cell

I think so. For this sample select D3:H5 and enter the CF rules (formulas) as shown. Make sure your rules end up in this order when you go in to Conditional formatting -> Manage Rules ... (you can...

by Peter_SSs
Replies
11
Views
239

### Re: Need some help a formula Please

Hmm, I thought this meant that after 35% was deducted from the selling price, you still made your 10% profit.

So in my first example, if you sold for 169.23 and deducted 35% of that (59.23) you...

by Peter_SSs
Replies
5
Views
214

### Re: Student Choice

OK, let's see if this is any use.

In my sample, I have 20 students and 5 possible Activities and each student can have a maximum of 5 choices. Those choices are entered in A1:F21 as shown below.
...

by Peter_SSs
Replies
5
Views
190

### Re: Excel Header and Footers

Welcome to the MrExcel board!

Another code to try. Further detail on implementation ..
1. With your workbook active press Alt+F11 to bring up the vba window.
2. In the Visual Basic window use...

by Peter_SSs
Replies
11
Views
239

### Re: Need some help a formula Please

Is this what you mean?

<b>Selling Price</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:8pt; background-color:#ffffff; padding-left:2pt; ...
20. ## Thread: VBA Remove only certain duplicates

by Peter_SSs
Replies
5
Views
122

### Re: VBA Remove only certain duplicates

Welcome to the MrExcel board!

Please keep all correspondence in the forum. Refer to #4 of the Forum Rules
My signature block below has a link with options for posting small sets of sample data...
21. ## Thread: For loop to create a top blank row

by Peter_SSs
Replies
3
Views
106

### Re: For loop to create a top blank row

I understand that you are learning about nested loops and are therefore using that concept but of course that result could be obtained without any looping at all by moving all the cells at once.

...
22. ## Thread: Conditional formatting formula for cell

by Peter_SSs
Replies
6
Views
132

### Re: Conditional formatting formula for cell

What cell or cells are you trying to colour?
Could you give a small set of sample data and explain your requirement in relation to that sample data?
23. ## Thread: Trouble highlighting row data.

by Peter_SSs
Replies
34
Views
1,153

### Re: Trouble highlighting row data.

Thanks for the additional info. Unfortunately, I don't see an easy way to achieve that. I think probably a bit much to try to achieve in a forum like this but you never know, somebody might chime in...
24. ## Thread: VBA to create list based on input

by Peter_SSs
Replies
5
Views
163

### Re: VBA to create list based on input

You're welcome. Thanks for the extra explanation. :)
25. ## Thread: Vba - insert two columns after each occurrence of dept name

by Peter_SSs
Replies
6
Views
151

### Re: Vba - insert two columns after each occurrence of dept name

OK, cheers.
Results 1 to 25 of 150
Page 1 of 6 1