Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.24 seconds.

  1. Replies
    4
    Views
    141

    Re: Get Cell Reference From Cell Address ?

    Hi Jaafar, no - it takes a string and returns a range reference.

    In my example I put the string in a cell, but you don't need to do that, for example.

    <b>Excel 2013/2016</b><table...
  2. Replies
    4
    Views
    141

    Re: Get Cell Reference From Cell Address ?

    Hi Jaafar,

    Take a look at INDIRECT() - for example.

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse:...
  3. Re: SUMIFS with array that counts number of valid days within a date range

    Hi, here is an option that you can try:

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  4. Replies
    2
    Views
    51

    Re: Cell contails specific text

    Hi, you could try like this:

    =IF(E38="Blue",SUMIFS(F38:X38, F39:X39, "<>*~**"), 0)
  5. Replies
    6
    Views
    193

    Re: VBA countdown timer

    Hi, you can force Excel to recalculate by pressing F9.

    I suppose you could use On Timer in VBA to schedule a macro to do the re-calculation periodically.
  6. Replies
    6
    Views
    193

    Re: VBA countdown timer

    Hi, maybe you could consider using formulas:

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  7. Replies
    2
    Views
    98

    Re: look for values base on =Today()

    Hi, assuming the month names in J1:N1 are text and include the full stop / period, you can try..

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color:...
  8. Thread: Date & Quarters

    by FormR
    Replies
    12
    Views
    592

    Re: Date & Quarters

    Hi, here is one option you can try:

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  9. Replies
    3
    Views
    112

    Re: Sum range data in current month

    Hi, something like this maybe:

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  10. Replies
    3
    Views
    112

    Re: Sum range data in current month

    Hi, here is one option:

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  11. Replies
    12
    Views
    372

    Re: Button to add column to the end of a table

    Hi, you could try this to copy the formatting of the cells outside of the table.



    Private Sub CommandButton2_Click()
    With Sheets("Competitor Overview Data").ListObjects("CompTable")
    ...
  12. Re: IF any of 10 columns equals any of 4 other columns

    Hi, as Eric has suggested, you need to make sure the values are exactly the same. You could test with a simple formula to help diagnose - i.e. does the formula:

    =AD3=AQ3

    Return TRUE?
    ...
  13. Replies
    12
    Views
    372

    Re: Button to add column to the end of a table

    Maybe you could change it to an actual table?
  14. Replies
    16
    Views
    426

    Re: Sum numbers between two specific cells

    Hi, here is a formula based option you can try.

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  15. Replies
    12
    Views
    372

    Re: Button to add column to the end of a table

    Hi, you could try:



    Sub addtablecolumn()
    With Sheets("Competitor Overview Data").ListObjects("CompTable")
    .ListColumns.Add (.ListColumns.Count + 1)
    End With
    End Sub
  16. Re: IF any of 10 columns equals any of 4 other columns

    Hi, why not try it and let us know ;)
  17. Re: IF any of 10 columns equals any of 4 other columns

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  18. Re: IF any of 10 columns equals any of 4 other columns

    Hi, here is one option you can try:

    =SUMPRODUCT(COUNTIFS(AD3:AG3,"<>0",AD3:AG3,CHOOSE({1,2,3,4,5,6,7,8,9},AQ3,AS3,AU3,AW3,AY3,BC3,BE3,BG3,BI3)))>0
  19. Replies
    5
    Views
    110

    Re: VBA: Set column widths

    Hi, you could try something like this..



    Sub cw()


    Dim c As Variant
    Dim cnt As Integer
  20. Replies
    7
    Views
    212

    Re: BuiltIn Dialog Boxes

    Hi, have you removed the quotes highlighted red below to match the code in post 3
  21. Replies
    3
    Views
    142

    Re: Round Value Based On Criteria

    Hi, welcome to your first post!

    This makes the assumption that items with an "each" description will only appear once in the criteria list.

    <b>Excel 2013/2016</b><table cellpadding="2.5px"...
  22. Replies
    16
    Views
    426

    Re: Sum numbers between two specific cells

    Hi, something like this?

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  23. Replies
    2
    Views
    79

    Re: Worksheet name from list

    Hi, how about copying a "master" sheet that already has the layout, formulas etc rather than creating new sheets and back applying.

    Something like this, where, for example, the name of the...
  24. Replies
    14
    Views
    3,598

    Re: VLOOKUP multiple results (Custom Function)

    Hi, I think the limitation is the length of the string being returned (32767 chars) versus the number of cells being concatenated.
    ...
  25. Re: Hyperlink to cell in sheet based off of list of values

    Great, although I missed the match_type parameter of the match() function - for robustness you should include the addition in red below:
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4