Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.90 seconds.

  1. 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. Re: Need a formula that only show the set cost figure once for each unique User Id

    Cheers. Thanks for the follow-up. :)
  3. Replies
    91
    Views
    58,593

    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. Replies
    91
    Views
    58,593

    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. Replies
    7
    Views
    205

    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
    639

    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
    639

    Re: VBA Formula

    What does that mean?

    What are the expected results for your last sample data?
  8. 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. 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. 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. Replies
    29
    Views
    473

    Re: Reverse Hex Byte Pairs

    You're very welcome. Thanks for the follow-up. :)
  12. Replies
    7
    Views
    205

    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. Re: Keeping key words in row data and delete the rest of the rows Macro updating Please

    No problem, glad to help. :)
  14. 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. 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.
  16. Replies
    30
    Views
    442

    Re: Deleting Lines with a Macro Command

    Cheers. :)
  17. 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. Replies
    30
    Views
    442

    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. 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. Replies
    30
    Views
    442

    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. 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. Replies
    30
    Views
    442

    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. Replies
    10
    Views
    143

    Re: vba If condition help..

    Well in that case you would have found that it does not work. :eek:
  24. 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. Replies
    30
    Views
    442

    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 2 3 4