Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.23 seconds.

  1. Replies
    1
    Views
    64

    Re: summing workhours of weeks

    Hi, sounds like you want SUMIFS() - 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:...
  2. Replies
    4
    Views
    72

    Re: How to solve a issue with three criterias

    Hi, I get a different result for row 6 than you expect - but maybe you can try:

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

    Re: Adding st, nd, rd, th to ranked values

    I think you can also use the unicode superscript characters in the custom number format :)
  4. Replies
    15
    Views
    216

    Re: Adding st, nd, rd, th to ranked values

    You could also make use of the unicode superscript characters - using Rick's formula, if you copy this directly from the forum the ordinals should be superscript.
    ...
  5. Re: Can someone help me with this? Probably a beginner level formula.

    That exact formula, with that exact sample data returns 2000 (as expected) for me :confused: .

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color:...
  6. Re: Can someone help me with this? Probably a beginner level formula.

    If you want to progress with this can you post the exact formula you ended up using and a small set of sample data that demonstrates the problem.



    This sounds like a good way forward to me,...
  7. Re: Can someone help me with this? Probably a beginner level formula.

    Hi, you can do it 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:...
  8. Replies
    4
    Views
    198

    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...
  9. Replies
    4
    Views
    198

    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:...
  10. 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;...
  11. Replies
    2
    Views
    55

    Re: Cell contails specific text

    Hi, you could try like this:

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

    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.
  13. Replies
    6
    Views
    213

    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;...
  14. Replies
    2
    Views
    106

    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:...
  15. Thread: Date & Quarters

    by FormR
    Replies
    12
    Views
    600

    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;...
  16. Replies
    3
    Views
    125

    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:...
  17. Replies
    3
    Views
    125

    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:...
  18. Replies
    12
    Views
    380

    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")
    ...
  19. 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?
    ...
  20. Replies
    12
    Views
    380

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

    Maybe you could change it to an actual table?
  21. Replies
    16
    Views
    435

    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;...
  22. Replies
    12
    Views
    380

    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
  23. Re: IF any of 10 columns equals any of 4 other columns

    Hi, why not try it and let us know ;)
  24. 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...
  25. 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
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4