Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.79 seconds.

  1. Thread: Collections

    by pgc01
    Replies
    5
    Views
    85

    Re: Collections

    We all do. :)
  2. Thread: Collections

    by pgc01
    Replies
    5
    Views
    85

    Re: Collections

    [/LEFT]
    [/FONT][/COLOR]
    [/LEFT]
    [/FONT] Hi

    I guess you did not read the help carefully. :)



    Check here:
  3. Re: VBA - Replacing cell values based on specific range

    Not sure what that means. 100 where?


    This is exactly what I did in my test:

    I started with the table you posted. Used in C3 the formula I posted:
    ...
  4. Re: VBA - Replacing cell values based on specific range

    Hi

    You can find the first line with "Total" after the current cell row and use that value, like with your example:

    =B3/INDEX(INDEX(B3,1):$B$1000,MATCH("Total",INDEX(A3,1):$A$1000,0))*100

    At...
  5. Replies
    1
    Views
    48

    Re: Indirect within sumproduct

    Hi Stephen

    You mistyped GANTT in the second formula.
  6. Replies
    2
    Views
    388

    Re: Multiply previous columns

    Sorry, didn't see it was the BI forum. Disregard my answer.
  7. Replies
    2
    Views
    388

    Re: Multiply previous columns

    Hi Dorin

    Assuming column D empty, like in the table you posted, in H2:

    =PRODUCT(IF($A$2:$A$19=E2,IF($B$2:$B$19<=F2,IF($B$2:$B$19>=G2,$C$2:$C$19,1))))

    This is an array formula, you have to...
  8. Replies
    26
    Views
    25,890

    Re: Convert String to MD5 Hash

    I'm glad it helped Thanks for the feedback and thank you for the offer.
  9. Replies
    5
    Views
    214

    Re: Declaring variable types within an array

    Hi

    If you really want/need to have each column with a specific type you could use an array of arrays, like



    Sub Test()
    Dim a(1 To 100) As String, d(1 To 100) As String
    Dim b(1 To 100) As...
  10. Replies
    26
    Views
    25,890

    Re: Convert String to MD5 Hash

    Hi

    You just missed it in the code of the encoding function:


    ' encode a string as utf8, set reference to Microsoft ActiveX Data Objects 6.1 Library
  11. Replies
    26
    Views
    25,890

    Re: Convert String to MD5 Hash

    I had a little time now and did some testing.

    I tried to get the code to return the same result as what the online md5 encoders return.

    To test I used:
    Some japanese: "お名前は?" "(What's your)...
  12. Replies
    1
    Views
    79

    Re: Count Formulaes x 5

    Hi

    For ex:

    =SUM(COUNTIF(B1:K1,{2,3,4}))
  13. Replies
    26
    Views
    25,890

    Re: Convert String to MD5 Hash

    Well, I don't have much time now to test, but I just tried with the code in this thread for the character you want (character 287: ğ) and it worked with no problem.
    I used the usual utf8...
  14. Replies
    26
    Views
    25,890

    Re: Convert String to MD5 Hash

    Hi

    I looked for online MD5 Hash Generators and the first 5 I found in google were:

    http://www.md5.cz/
    https://www.md5online.org/
    https://www.md5hashgenerator.com/...
  15. Replies
    11
    Views
    386

    Re: Dynamic unique lists

    You're welcome. Thanks for the feedback.
  16. Replies
    26
    Views
    25,890

    Re: Convert String to MD5 Hash

    Hi

    Like I said I don't know the object, but maybe you can post some examples with input and expect output strings. This way, someone that wants to try it has a way to check the results.
  17. Replies
    11
    Views
    386

    Re: Dynamic unique lists

    Hi
    If I understood correctly you just have to add another IF().

    Ex., in F3:
    ...
  18. Replies
    3
    Views
    171

    Re: Frequency Formula

    Not clear to me what you want.

    You did not post the result you expect so I'm going to guess.
    Do you mean you want how many days in a row since today going backwards?

    For ex., with "w" for a...
  19. Replies
    11
    Views
    386

    Re: Dynamic unique lists

    Hi

    Another formula solution, without repeating values. In D2 (using a table with DanteAmor's layout):
    ...
  20. Replies
    3
    Views
    216

    Re: Arranging in order

    The usual question with sorting is to build a good key.

    In this case I'd use an auxiliary row, for ex. just below the Total, where I'd build a key for each column.
    Since you want identical...
  21. Re: Trying to sort dynamic table in order of number value of first column (this column contains duplicate values)

    You're welcome. Thanks for the feedback.
  22. Re: Trying to sort dynamic table in order of number value of first column (this column contains duplicate values)

    Hi

    You can use an auxiliary column with a rank and use it to build the sorted table.

    Ex.

    In D2:
    =COUNTIF($A$2:$A$10,"<"&A2)+COUNTIFS($A$2:A2,A2)
    Copy down
  23. Re: Trying to sort dynamic table in order of number value of first column (this column contains duplicate values)

    Hi

    Your result also shows column C sorted. Was that a coincidence and you just want to sort on column A or do you also want to sort on column C?


    Remark: I assumed column B doesn't matter...
  24. Replies
    3
    Views
    216

    Re: Arranging in order

    Hi

    Not sure I understand correctly. It would be clearer if you had posted the result you expect from your example.

    What I understood is that
    - you first want the columns ordered by total
    -...
  25. Replies
    1
    Views
    108

    Re: Print area using table/range of cells

    Hi

    Insert page breaks.

    For ex. if table 3 starts in A31 then select A30 and insert one page break, this will force a new page after row 30.

    Add other page breaks before the other tables.
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4