+ Post New Thread
Page 1009 of 5614 FirstFirst ... 1009 ...
Threads 50401 to 50450 of 280699

Forum: Excel Formulas & Functions

Post and discuss Excel Formulas & functions.

  1. Thumbs up Sticky Thread Sticky: Excel Useful Links (see last post for new additions)

    Started by gopi_excel‎, 12-22-2006 08:14 PM
    • 19
    • 156,905
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. Combining an Array Formula and Another Non-Array Formula

    Started by MontgomeryBrea‎, 02-10-2019 01:40 PM
    array formula, formulas & functions, vba, visual basic 1 Attachment(s)
    • 4
    • 1,515
    Pete_UK
    02-10-2019, 02:50 PM Go to last post

  2. [SOLVED] Concatenating (?) words from an MSAccess crosstab query

    Started by roxdrob01‎, 02-09-2019 10:28 PM
    2 Attachment(s)
    • 3
    • 348
    Greg M
    02-10-2019, 02:50 PM Go to last post

  3. Choose formula - reference a formula to use

    Started by Gregb11‎, 02-10-2019 11:23 AM
    1 Attachment(s)
    • 4
    • 361
    Gregb11
    02-10-2019, 01:30 PM Go to last post

  4. [SOLVED] Create List - Index Match or Index Aggregate or other?

    Started by bambamclint‎, 02-08-2019 05:54 PM
    6 Attachment(s)
    • 14
    • 1,378
    bambamclint
    02-10-2019, 01:30 PM Go to last post

  5. [SOLVED] Calculating simple daily interest between two dates

    Started by Guitargaton‎, 02-10-2019 06:21 AM
    • 4
    • 5,709
    Guitargaton
    02-10-2019, 01:29 PM Go to last post

  6. [SOLVED] Compairing periods to periods

    Started by DHDan‎, 02-10-2019 11:53 AM
    excel, formula 1 Attachment(s)
    • 1
    • 315
    Pepe Le Mokko
    02-10-2019, 11:53 AM Go to last post

  7. getting excel to recognize a complex date and time text as a date value

    Started by CloudForest‎, 02-10-2019 09:26 AM
    • 2
    • 253
    CloudForest
    02-10-2019, 09:52 AM Go to last post

  8. CONCAT/TEXTJOIN on Variable Number of Cells

    Started by OlYeller21‎, 02-08-2019 05:39 PM
    3 Attachment(s)
    • 10
    • 1,910
    AliGW
    02-10-2019, 06:29 AM Go to last post

  9. How can i use countif to count until the last row with data

    Started by jdcortez‎, 02-09-2019 10:34 PM
    • 4
    • 515
    FDibbins
    02-10-2019, 03:45 AM Go to last post

  10. [SOLVED] Advanced formula needed - Rostering statistics

    Started by Almont‎, 02-09-2019 05:41 AM
    formula assistance, help excel 4 Attachment(s)
    • 9
    • 545
    Almont
    02-10-2019, 02:02 AM Go to last post

  11. search function returns "#value!"

    Started by seraphin‎, 02-10-2019 12:11 AM
    • 1
    • 331
    FDibbins
    02-10-2019, 01:18 AM Go to last post

  12. [SOLVED] H:MM to text

    Started by Beh162‎, 02-09-2019 07:01 PM
    • 3
    • 384
    Beh162
    02-09-2019, 07:47 PM Go to last post

  13. Sum of Multiple Rows and Columns Based on Data in a Cell

    Started by mehwishm88‎, 02-08-2019 09:51 PM
    1 Attachment(s)
    • 3
    • 315
    mehwishm88
    02-09-2019, 06:36 PM Go to last post

  14. [SOLVED] data validation list without blanks

    Started by thedunna‎, 02-09-2019 03:35 PM
    • 2
    • 1,895
    thedunna
    02-09-2019, 04:34 PM Go to last post

  15. Part Number, Replacement, All References to Replacements and Active

    Started by dmcbrier‎, 02-06-2019 01:45 PM
    4 Attachment(s)
    • 4
    • 268
    dflak
    02-09-2019, 02:30 PM Go to last post

  16. Conditional Formatting to Highlight Rows Where Columns C to G Contain Text

    Started by sporenboss‎, 02-09-2019 11:39 AM
    2 Attachment(s)
    • 5
    • 382
    Fluff13
    02-09-2019, 01:54 PM Go to last post

  17. [SOLVED] Can't make countif return the value I want.

    Started by cayuga306‎, 02-09-2019 12:27 PM
    countif 1 Attachment(s)
    • 8
    • 473
    AliGW
    02-09-2019, 01:00 PM Go to last post

  18. Count Function Help

    Started by bowlerjp‎, 02-09-2019 06:43 AM
    4 Attachment(s)
    • 19
    • 465
    bowlerjp
    02-09-2019, 12:54 PM Go to last post

  19. Too complex for me Time formula

    Started by crazy_brit‎, 01-31-2019 08:18 AM
    1 Attachment(s)
    • 9
    • 323
    JeteMc
    02-09-2019, 12:11 PM Go to last post

  20. [SOLVED] Finding First X Weekday of the Year (I Know Formula, but can't adapt)

    Started by ClwnMan76‎, 02-03-2019 03:13 PM
    • 8
    • 562
    ClwnMan76
    02-09-2019, 10:24 AM Go to last post

  21. [SOLVED] Formula for extracting data, lookup value in noncontinuous layout

    Started by GAURAVVOHRA‎, 02-06-2019 10:51 AM
    4 Attachment(s)
    • 8
    • 321
    GAURAVVOHRA
    02-09-2019, 10:19 AM Go to last post

  22. Moved: Need help combining Countifs with sumproduct

    Started by kartikoli‎, 02-09-2019 10:09 AM
    •  
    •  

  23. Multiple if And conditions

    Started by Pranav9940‎, 02-09-2019 07:38 AM
    2 Attachment(s)
    • 3
    • 372
    Ghozi Alkatiri
    02-09-2019, 08:14 AM Go to last post

  24. Set monthly reminder

    Started by Kal_ELf‎, 02-09-2019 04:56 AM
    • 3
    • 291
    KOKOSEK
    02-09-2019, 07:42 AM Go to last post

  25. If sumproduct returns a negative change to 0 (zero)

    Started by sipa‎, 02-09-2019 06:34 AM
    • 1
    • 242
    jason.b75
    02-09-2019, 06:49 AM Go to last post

  26. [SOLVED] Rounding up time

    Started by ladypickers‎, 02-07-2019 10:38 AM
    3 Attachment(s)
    • 18
    • 709
    ladypickers
    02-09-2019, 05:16 AM Go to last post

  27. Text Formula Not working

    Started by hawkinsr86‎, 02-08-2019 12:53 PM
    formulas, text
    • 4
    • 3,618
    jason.b75
    02-09-2019, 04:12 AM Go to last post

  28. excel sumif off combo text criteria

    Started by tilteed‎, 02-08-2019 04:22 PM
    • 2
    • 332
    FDibbins
    02-09-2019, 03:14 AM Go to last post

  29. [SOLVED] Conditional Formatting Formula Based on Cell to Left

    Started by Catsonheat‎, 02-08-2019 04:34 AM
    • 5
    • 675
    FDibbins
    02-09-2019, 02:48 AM Go to last post

  30. Combining multiple formulas

    Started by meanpplsuk‎, 02-09-2019 12:11 AM
    1 Attachment(s)
    • 2
    • 404
    FDibbins
    02-09-2019, 02:41 AM Go to last post

  31. If Except Or And

    Started by jeremy.wood‎, 02-01-2019 04:41 PM
    conditions, evaluation, formula, if statement 5 Attachment(s)
    • 16
    • 1,249
    AliGW
    02-09-2019, 01:55 AM Go to last post

  32. [SOLVED] COUNTIFS formula excluding specific text values

    Started by Jnehra‎, 02-08-2019 01:14 PM
    1 Attachment(s)
    • 4
    • 8,471
    Bo_Ry
    02-08-2019, 11:32 PM Go to last post

  33. Exclamation Filters in pivot table not working. :(

    Started by Mauricio Vallejo‎, 02-08-2019 05:21 PM
    pivottable filtering 1 Attachment(s)
    • 1
    • 7,609
    dflak
    02-08-2019, 06:24 PM Go to last post

  34. Sum the maximum values based on criteria

    Started by Olivebel‎, 02-08-2019 04:42 PM
    1 Attachment(s)
    • 3
    • 296
    dflak
    02-08-2019, 06:09 PM Go to last post

  35. Running Average-if possible

    Started by jarvan‎, 02-06-2019 07:06 PM
    2 Attachment(s)
    • 4
    • 300
    jarvan
    02-08-2019, 05:42 PM Go to last post

  36. Get Total of Items From Single Letters W/in a Cell

    Started by FingDragons‎, 02-07-2019 05:04 PM
    5 Attachment(s)
    • 3
    • 251
    FingDragons
    02-08-2019, 05:16 PM Go to last post

  37. [SOLVED] How to capture a max value in a dynamic cell

    Started by toughy1‎, 02-08-2019 02:13 PM
    • 5
    • 4,989
    toughy1
    02-08-2019, 04:38 PM Go to last post

  38. How to Extract data from a list that are between two dates

    Started by JerryA‎, 02-07-2019 03:51 PM
    1 Attachment(s)
    • 3
    • 1,373
    JerryA
    02-08-2019, 03:38 PM Go to last post

  39. Copy Range from one sheet to another and sort

    Started by DethanB‎, 02-06-2019 12:57 PM
    blanks, copy, sheet, sort 1 Attachment(s)
    • 2
    • 533
    DethanB
    02-08-2019, 03:36 PM Go to last post

  40. If statement across multiple sheets for specific value (v-lookup?)

    Started by v-lata‎, 02-08-2019 01:56 PM
    2 Attachment(s)
    • 2
    • 288
    v-lata
    02-08-2019, 03:16 PM Go to last post

  41. [SOLVED] Dynamic "table_array" in VLOOKUP function

    Started by TheRox‎, 02-08-2019 07:07 AM
    2 Attachment(s)
    • 2
    • 398
    TheRox
    02-08-2019, 03:07 PM Go to last post

  42. [SOLVED] 2 cell text lookup in text string to return data from separate column

    Started by Zivhodiva‎, 02-07-2019 09:30 PM
    4 Attachment(s)
    • 6
    • 517
    Zivhodiva
    02-08-2019, 03:03 PM Go to last post

  43. Formula returning a value related to a date

    Started by tureatan‎, 02-07-2019 05:55 PM
    1 Attachment(s)
    • 3
    • 276
    EchoPassenger
    02-08-2019, 02:35 PM Go to last post

  44. Reached character limit in excel formula? any tips?

    Started by ADzimmerman‎, 02-07-2019 06:40 PM
    1 Attachment(s)
    • 8
    • 351
    ADzimmerman
    02-08-2019, 01:08 PM Go to last post

  45. [SOLVED] Production Calculator... work out time to produce and how many machines

    Started by pmw19800‎, 02-08-2019 10:10 AM
    2 Attachment(s)
    • 2
    • 420
    pmw19800
    02-08-2019, 12:21 PM Go to last post

  46. Help with IFS formula with multiple conditions

    Started by jambog‎, 02-08-2019 11:59 AM
    ifs, ifs formula
    • 1
    • 339
    KOKOSEK
    02-08-2019, 12:07 PM Go to last post

  47. calculating average of dates in new sheet

    Started by skyhonor‎, 02-05-2019 05:07 PM
    6 Attachment(s)
    • 18
    • 548
    shg
    02-08-2019, 11:32 AM Go to last post

  48. Weighted Average IF

    Started by dam00000007‎, 02-07-2019 11:40 AM
    weighted averageif 2 Attachment(s)
    • 12
    • 970
    Bernie Deitrick
    02-08-2019, 11:11 AM Go to last post

  49. Solution Required for calculating sum based on different criteria

    Started by Gazsim‎, 02-08-2019 10:24 AM
    1 Attachment(s)
    • 2
    • 246
    AliGW
    02-08-2019, 11:09 AM Go to last post

  50. Status update automatically according the crietria

    Started by AaruJaan‎, 02-08-2019 10:40 AM
    between values, greater than, less than 1 Attachment(s)
    • 2
    • 396
    MarvinP
    02-08-2019, 11:05 AM Go to last post
+ Post New Thread
Page 1009 of 5614 FirstFirst ... 1009 ...

Forum Information and Options

Users Browsing this Forum

There are currently 67 users browsing this forum. (5 members & 62 guests)

  1. AliGW,
  2. jhonnyFreq,
  3. Penguinton,
  4. td3201,
  5. viewotst

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1