# Search:

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

Page 1 of 6 1

1. ## Thread: Sum of multple values, dependant on specifc date (within broader dates)

by Peter_SSs
Replies
3
Views
105

### Re: Sum of multple values, dependant on specifc date (within broader dates)

Your thread title says you want to sum multiple values, but your first post says you want to count something.
Are you summing (if so what as I am sure your aren't summing dates) or are you counting?...
2. ## Thread: Need a formula that only show the set cost figure once for each unique User Id

by Peter_SSs
Replies
3
Views
164

### Re: Need a formula that only show the set cost figure once for each unique User Id

Cheers. Thanks for the follow-up. :)
3. ## Thread: Counting Consecutive Cells with value

by Peter_SSs
Replies
91
Views
58,573

### Re: Counting Consecutive Cells with value

This is an Excel forum & I only answer questions on that topic so I am unable to help in relation to Google Sheets. Perhaps somebody else might take up that issue for you.
4. ## Thread: Counting Consecutive Cells with value

by Peter_SSs
Replies
91
Views
58,573

### Re: Counting Consecutive Cells with value

Welcome to the MrExcel board!

Her are 2 options that I think do what you want. The formulas can be placed wherever you want. In my example, they are each copied down.

<b>Count Last Seq</b><br...
5. ## Thread: reversing the order of 2 columns

by Peter_SSs
Replies
7
Views
203

### Re: reversing the order of 2 columns

If you are interested, here is a vba way to reverse a table (but keep the headings) without looping through the rows and columns.

Sub Reverse_Table()
Dim rws As Long, cols As Long
Dim...
6. ## Thread: VBA Formula

by Peter_SSs
Replies
31
Views
636

### Re: VBA Formula

Not with my code ....

Before:

<b>Yes</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:8pt; background-color:#ffffff; padding-left:2pt; ...
7. ## Thread: VBA Formula

by Peter_SSs
Replies
31
Views
636

### Re: VBA Formula

What does that mean?

What are the expected results for your last sample data?
8. ## Thread: Autofill dates for specified year

by Peter_SSs
Replies
11
Views
180

### Re: Autofill dates for specified year

:laugh: That could be it. We can't help if we live "at the bottom of the world".

Regards
Peter
9. ## Thread: Autofill dates for specified year

by Peter_SSs
Replies
11
Views
180

### Re: Autofill dates for specified year

I'm not so sure...
That does some really strange things for me.
I started out with the whole column formatted as General & my date system is d/m/y
When I enter 1/1/2019 in A1 it shows up as...
10. ## Thread: Autofill dates for specified year

by Peter_SSs
Replies
11
Views
180

### Re: Autofill dates for specified year

It also assumes that the column is already formatted as Date?
The Fill Series does not require that assumption.
11. ## Thread: Reverse Hex Byte Pairs

by Peter_SSs
Replies
29
Views
473

### Re: Reverse Hex Byte Pairs

You're very welcome. Thanks for the follow-up. :)
12. ## Thread: reversing the order of 2 columns

by Peter_SSs
Replies
7
Views
203

### Re: reversing the order of 2 columns

You're welcome.

.. and of course if the data started out in a jumbled order then sorting wouldn't reverse the table anyway. :)
13. ## Thread: Keeping key words in row data and delete the rest of the rows Macro updating Please

by Peter_SSs
Replies
8
Views
189

### Re: Keeping key words in row data and delete the rest of the rows Macro updating Please

No problem, glad to help. :)
14. ## Thread: Autofill dates for specified year

by Peter_SSs
Replies
11
Views
180

### Re: Autofill dates for specified year

It just uses one of Excel's built-in features.
DataSeries We want some sort of series (pattern)
Rowcol:=xlColumns Go down columns not across rows.
Type:=xlChronological We want some sort of date...
15. ## Thread: vba If condition help..

by Peter_SSs
Replies
10
Views
143

### Re: vba If condition help..

You're welcome.

The option using Instr that I gave in post 2 was not quite correct. I have edited that code so if you are testing, be sure to re-visit post 2 to get the correct code.

by Peter_SSs
Replies
30
Views
437

Cheers. :)
17. ## Thread: Autofill dates for specified year

by Peter_SSs
Replies
11
Views
180

### Re: Autofill dates for specified year

If you have the first date in cell A1, then try

Sub FillDates()
Range("A1").DataSeries Rowcol:=xlColumns, Type:=xlChronological, Date:=xlDay, Step:=1,...
18. ## Thread: Deleting Lines with a Macro Command

by Peter_SSs
Replies
30
Views
437

### Re: Deleting Lines with a Macro Command

Then replace that first block of blue code in post 23 with this

With Range("AK2", Range("AK" & Rows.Count).End(xlUp))
.Replace What:=")", Replacement:="", LookAt:=xlPart
.TextToColumns...
19. ## Thread: Keeping key words in row data and delete the rest of the rows Macro updating Please

by Peter_SSs
Replies
8
Views
189

### Re: Keeping key words in row data and delete the rest of the rows Macro updating Please

My mistake, I mis-read your request and thought the rows had to start with those texts ( & I hadn't seen post 4 when I drafted my code).
It is a simple fix, just add this red asterisk

.AutoFilter...
20. ## Thread: Deleting Lines with a Macro Command

by Peter_SSs
Replies
30
Views
437

### Re: Deleting Lines with a Macro Command

Yes, sorry, as I said my suggestion was untested & I forgot about Replace changing the format even though I had set it to text with the "@". :oops:

After the various rows have been deleted, are...
21. ## Thread: vba If condition help..

by Peter_SSs
Replies
10
Views
143

### Re: vba If condition help..

:huh: Really?? I think you should check again.

Here's my test of your code line

Sub Test()
Dim i As Long

For i = 1 To 3
If Sheet1.Cells(i, 1).Value = Green Or Red Or Blue Then
...
22. ## Thread: Deleting Lines with a Macro Command

by Peter_SSs
Replies
30
Views
437

### Re: Deleting Lines with a Macro Command

Untested, but try adding the blue code where shown.

Sub MoveNameDeleteRow_v5()
Dim r As Long

Application.ScreenUpdating = False
For r = Cells.Find(What:="*", LookIn:=xlValues,...
23. ## Thread: vba If condition help..

by Peter_SSs
Replies
10
Views
143

### Re: vba If condition help..

Well in that case you would have found that it does not work. :eek:
24. ## Thread: For loop with irregular step or use arrays if possible

by Peter_SSs
Replies
14
Views
357

### Re: For loop with irregular step or use arrays if possible

You shouldn't have to do any loop from 1 to 100 to find a few values if you don't want to

If they are in consecutive cells starting from, say B2 then you could use something like this to just...
25. ## Thread: Deleting Lines with a Macro Command

by Peter_SSs
Replies
30
Views
437

### Re: Deleting Lines with a Macro Command

You're welcome. Glad we got there in the end. :)
Results 1 to 25 of 150
Page 1 of 6 1