Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.69 seconds.

  1. Replies
    1
    Views
    85

    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
    -...
  2. Replies
    1
    Views
    75

    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.
    ...
  3. Replies
    9
    Views
    170

    Re: Data validation and numbers + hyphens

    Yes, it seems it to also work ok.
  4. Replies
    4
    Views
    120

    Re: Regex: replace the 3rd occurrence

    You're welcome



    As a side note:

    You could use your "b" if the ms regex implementation was more up to date with regard to the lookaround features. We can use lookaheads but we cannot yet use...
  5. Replies
    9
    Views
    170

    Re: Data validation and numbers + hyphens

    Hi Mike

    In the case of your formula you can trick Value() with the exponential

    Try:

    123456-e7
    1.23e8-11
  6. Replies
    9
    Views
    170

    Re: Data validation and numbers + hyphens

    Can't test it now (because my eyes are closing) but seems a great solution. Much simpler than mine.
  7. Replies
    9
    Views
    170

    Re: Data validation and numbers + hyphens

    Hi Scott

    I think that will work for most of the values that the user might try, but to be sure that the pattern is respected I believe you have to check each character separately.

    Your formula...
  8. Re: Looking for a more elegant way to write the following countifs formula

    What you are saying is that you want

    'WO Report'!$S:$S

    to be equal to $B$12 AND to be equal to $C$12 AND to be equal to $D$12

    and I think you want OR, not AND

    Try instead:
  9. Replies
    9
    Views
    170

    Re: Data validation and numbers + hyphens

    Hi
    Welocome to the board

    For ex., for B2:

    =AND(LEN(B2)=9,ISNUMBER(-MID(B2,ROW(INDIRECT("1:6")),1)),MID(B2,7,1)="-",ISNUMBER(-MID(B2,8,1)),ISNUMBER(-MID(B2,9,1)))
  10. Replies
    4
    Views
    120

    Re: Regex: replace the 3rd occurrence

    simpler, if all in the same line:


    .Pattern = "(^.*?a.*?a.*?)a"
  11. Replies
    4
    Views
    120

    Re: Regex: replace the 3rd occurrence

    Hi

    Try:



    Sub substitute()

    Dim Rng As Range, rC As Range
    Dim regex As Object
  12. Replies
    3
    Views
    123

    Re: SUM i to n without Using Cell References

    You can use

    =SUM(PV(3%, {3,6,9,12},, 100))

    or, since you have an arithmetic progression with common difference of 3 also

    =SUM(PV(3%, 3*{1,2,3,4},, 100))

    which makes it easier to adapt if...
  13. Replies
    3
    Views
    123

    Re: SUM i to n without Using Cell References

    Hi

    Not clear to me

    You mean you want add the PV values using a sequence of n's, something like

    =PV(3%, 1,, 100)+PV(3%, 2,, 100)+PV(3%, 3,, 100)+ ... + PV(3%, 10,, 100)

    ?
  14. Replies
    6
    Views
    125

    Re: Function arguments

    Hi

    Not sure I understand correctly, check this that covers both cases



    If Target.Row < 7 Or Target.Row > 37 Then Exit Sub
    If Target.Column < 8 Or Target.Column > 1087 Then Exit Sub
    If...
  15. Replies
    6
    Views
    125

    Re: Function arguments

    You're welcome. Thanks for the feedback.
  16. Replies
    6
    Views
    125

    Re: Function arguments

    Hi

    If I unserstand correctly you have 180 groups of 6 columns for which you are intersted in the first 2 columns of each group.

    The columns are 8:1087(13+179*6)
    The rows you want are 7:37

    ...
  17. Replies
    1
    Views
    95

    Re: Moving code to a function - not working

    Hi

    I don't have excel here but I don't remember a method IF in the WorksheetFunction object.

    I've just checked the help here and I don't see it.
    ...
  18. Re: Splitting a cell by delimiter with formula. Warning: 312 splits needed for this.

    Hi

    Please clarify.

    The numbers you posted do not match with the ones in the image.

    To be clear,

    - you have all the numbers you posted in just 1 cell separated by spaces
    - you want to...
  19. Replies
    3
    Views
    235

    Re: MsoType for converted Smartshape Rectangles

    I'm glad it helped.



    Oh! Well, the answer to the Recrangles question was easy. For the Rectangles question I'll need more time. :)
  20. Replies
    3
    Views
    235

    Re: MsoType for converted Smartshape Recrangles

    Hi

    They are MsoFreeform. You get them when you draw a polyline.
    In the Ribbon->Insert->Shapes you can click on the symbol that has the tooltip Freeform.
    You just click on vertices and the tool...
  21. Re: Conditional Formatting Referencing Color of Another Cell

    In that case I'll repeat what Fluff said: Not with conditional formatting, I'm afraid. :(
  22. Re: Conditional Formatting Referencing Color of Another Cell

    Is the background colour in A2 random or is there some logic to it? If the latter is true you can use the same logic.
  23. Replies
    5
    Views
    119

    Re: Array formula with criteria

    You're welcome. Thanks for the feedback.
  24. Replies
    5
    Views
    119

    Re: Array formula with criteria

    That would mean that the result of the product is zero, which is the case because you set the default value to zero. If you multiply by zero you get zero.

    Try 1 or nothing,
    ...
  25. Replies
    5
    Views
    119

    Re: Array formula with criteria

    Hi

    I think you misplaced a parenthesis.

    I guess you meant

    ... ,YEAR(DateExample)=D8,
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4