+ Post New Thread
Page 110 of 5615 FirstFirst ... 110 ...
Threads 5451 to 5500 of 280710

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,909
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. [SOLVED] Excel Formula for Counting consecutive larger than zeros (>0) on a yearly basic

    Started by uqls‎, 07-17-2023 03:20 PM
    1 Attachment(s)
    • 5
    • 189
    Fluff13
    07-17-2023, 03:59 PM Go to last post

  2. Determining whether date ranges overlap/are included in other date range columns

    Started by GRNEYEDDVL‎, 07-14-2023 02:28 PM
    2 Attachment(s)
    • 2
    • 330
    GRNEYEDDVL
    07-17-2023, 03:56 PM Go to last post

  3. Formula to calculate number of years in a year

    Started by shiva_reshs‎, 07-17-2023 03:48 PM
    • 2
    • 135
    Sam Capricci
    07-17-2023, 03:52 PM Go to last post

  4. [SOLVED] Cannot remove trailing spaces

    Started by Spitfire147‎, 07-17-2023 12:04 PM
    2 Attachment(s)
    • 11
    • 321
    TMS
    07-17-2023, 03:15 PM Go to last post

  5. How to compare two list to find the missing package number?

    Started by Manith‎, 07-17-2023 01:18 PM
    2 Attachment(s)
    • 6
    • 218
    PeteABC123
    07-17-2023, 02:14 PM Go to last post

  6. Non-volatile Month To Date Number of Days

    Started by brausten‎, 07-17-2023 01:20 PM
    date, days, excel, mtd, volatile
    • 4
    • 298
    Glenn Kennedy
    07-17-2023, 02:11 PM Go to last post

  7. Combining Formulas

    Started by angel4‎, 07-14-2023 12:43 PM
    4 Attachment(s)
    • 5
    • 314
    JeteMc
    07-17-2023, 01:53 PM Go to last post

  8. Smile [SOLVED] Combining IF Formulas

    Started by Miggy2021‎, 07-17-2023 12:07 PM
    • 3
    • 161
    AliGW
    07-17-2023, 12:28 PM Go to last post

  9. [SOLVED] Find True

    Started by Mxmaarten‎, 07-17-2023 10:37 AM
    5 Attachment(s)
    • 12
    • 253
    TMS
    07-17-2023, 11:31 AM Go to last post

  10. Question [SOLVED] Automatic Top 10 Ranking by Date Reference

    Started by samanthahernandez‎, 07-17-2023 08:59 AM
    5 Attachment(s)
    • 20
    • 318
    AliGW
    07-17-2023, 11:25 AM Go to last post

  11. Pivot table calculated field formula assistance

    Started by JmyCrikitt‎, 07-14-2023 08:47 PM
    • 3
    • 337
    AliGW
    07-17-2023, 10:32 AM Go to last post

  12. [SOLVED] Help with Combination of VLookUp and SumIfs

    Started by massi1234‎, 07-17-2023 09:35 AM
    1 Attachment(s)
    • 7
    • 214
    massi1234
    07-17-2023, 10:06 AM Go to last post

  13. Question Combination COUNTIFS / SUMIFS ?

    Started by jimbo_actual‎, 07-12-2023 06:01 PM
    2 Attachment(s)
    • 5
    • 325
    jimbo_actual
    07-17-2023, 09:57 AM Go to last post

  14. [SOLVED] Search multiple values and return multiple results

    Started by Mxmaarten‎, 07-17-2023 09:27 AM
    2 Attachment(s)
    • 3
    • 201
    AliGW
    07-17-2023, 09:44 AM Go to last post

  15. [SOLVED] create formula in pivot

    Started by kimudao‎, 07-14-2023 06:44 AM
    3 Attachment(s)
    • 7
    • 266
    JeteMc
    07-17-2023, 08:19 AM Go to last post

  16. [SOLVED] Auto-Populate help

    Started by Grant T‎, 07-17-2023 07:32 AM
    2 Attachment(s)
    • 6
    • 176
    AliGW
    07-17-2023, 08:02 AM Go to last post

  17. Countif format

    Started by pugs69‎, 07-16-2023 05:36 PM
    • 3
    • 181
    Fluff13
    07-17-2023, 07:02 AM Go to last post

  18. [SOLVED] Using index formula to summarise training database

    Started by wanmuhd‎, 07-10-2023 02:33 AM
    6 Attachment(s)
    • 10
    • 402
    wanmuhd
    07-17-2023, 05:23 AM Go to last post

  19. Countif formula for non text and short values

    Started by Livelife23‎, 07-17-2023 04:36 AM
    • 7
    • 198
    Glenn Kennedy
    07-17-2023, 05:21 AM Go to last post

  20. Unhappy [SOLVED] Cond. Formatting rule works differently than And statement with multiple conditions

    Started by lOYvEpi6M87nEoIF0ul8‎, 07-16-2023 05:05 PM
    and function, conditional formatting, different results, multiple conditions, not matching 1 Attachment(s)
    • 3
    • 261
    Pete_UK
    07-17-2023, 04:44 AM Go to last post

  21. Create a new column that renames top 6 ranks

    Started by hkucumb11‎, 07-12-2023 11:14 PM
    4 Attachment(s)
    • 10
    • 381
    windknife
    07-17-2023, 03:40 AM Go to last post

  22. [SOLVED] Rank multiple criteria, not repeating

    Started by franztupaz‎, 07-11-2023 12:50 AM
    6 Attachment(s)
    • 12
    • 357
    HansDouwe
    07-17-2023, 02:02 AM Go to last post

  23. SUM - Formula Error

    Started by angela_n88‎, 07-17-2023 12:53 AM
    1 Attachment(s)
    • 3
    • 181
    FDibbins
    07-17-2023, 01:06 AM Go to last post

  24. [SOLVED] Formula to create similar function to a pivot table

    Started by zz_zz11‎, 07-15-2023 08:16 PM
    2 Attachment(s)
    • 4
    • 354
    AliGW
    07-17-2023, 12:32 AM Go to last post

  25. Moved: Need help on COUNTIFS, INDEX and MATCH

    Started by Monteverdi‎, 07-16-2023 10:55 PM
    •  
    •  

  26. Wink [SOLVED] Scoring a data using formula

    Started by Sultan1994‎, 07-14-2023 11:50 PM
    #excel, #formula, #if #vlookup, #range 2 Attachment(s)
    • 7
    • 352
    Sultan1994
    07-16-2023, 09:47 PM Go to last post

  27. Smile Roulette counting how many colored cells are between

    Started by bcvcv‎, 07-16-2023 08:02 AM
    count by color, counting cell colors, roulette 5 Attachment(s)
    • 12
    • 747
    HansDouwe
    07-16-2023, 02:58 PM Go to last post

  28. Helper-free, non-volatile, pre-O365 selecting VISIBLE cells for other functions

    Started by Glenn Kennedy‎, 07-16-2023 01:08 PM
    1 Attachment(s)
    • 4
    • 186
    Glenn Kennedy
    07-16-2023, 01:55 PM Go to last post

  29. [SOLVED] Counting cells based on colour

    Started by waterstride‎, 07-16-2023 01:09 AM
    7 Attachment(s)
    • 31
    • 480
    HansDouwe
    07-16-2023, 10:32 AM Go to last post

  30. Question Percentage value shown in thousands upon progress calculation based on dates

    Started by marmanlive‎, 06-30-2023 06:18 AM
    percentage calclations, percentage in thousands, progress in percentage 1 Attachment(s)
    • 4
    • 222
    TMS
    07-16-2023, 07:12 AM Go to last post

  31. [SOLVED] How easely prevent problems with MATCH on a array with one value

    Started by HansDouwe‎, 07-15-2023 04:47 PM
    1 Attachment(s)
    • 14
    • 326
    HansDouwe
    07-16-2023, 04:21 AM Go to last post

  32. [SOLVED] Conditional formatting or excel formula to identify columns where sums diff is 1

    Started by lar9149‎, 07-13-2023 06:57 PM
    2 Attachment(s)
    • 5
    • 273
    lar9149
    07-16-2023, 01:08 AM Go to last post

  33. Protect IF statement AND allow data entry

    Started by stilton‎, 07-05-2006 04:53 PM
    • 5
    • 1,030
    AliGW
    07-16-2023, 12:52 AM Go to last post

  34. [SOLVED] Binary search and return all matches as an array

    Started by revs92‎, 07-15-2023 10:17 AM
    array, binary search, lookup, xlookup
    • 5
    • 396
    HansDouwe
    07-15-2023, 09:10 PM Go to last post

  35. payments allocation to bills in fifo basis

    Started by harshit8999‎, 07-13-2023 02:04 AM
    allocation, bills, fifo, payments, payments applied 5 Attachment(s)
    • 6
    • 409
    JeteMc
    07-15-2023, 01:58 PM Go to last post

  36. Why do different areas on a worksheet behave diffferently

    Started by Osprey3‎, 07-15-2023 11:43 AM
    • 1
    • 123
    TMS
    07-15-2023, 12:53 PM Go to last post

  37. Index Match Using MULTIPLE CRITERIA

    Started by jackoooooo‎, 07-15-2023 11:06 AM
    1 Attachment(s)
    • 4
    • 295
    windknife
    07-15-2023, 11:42 AM Go to last post

  38. How do I write a formula to count specific data for current month?

    Started by Fred Houck‎, 07-07-2023 08:38 AM
    1 Attachment(s)
    • 4
    • 212
    AliGW
    07-15-2023, 11:39 AM Go to last post

  39. Drop down menu with totals

    Started by fgef‎, 07-14-2023 02:49 PM
    1 Attachment(s)
    • 3
    • 294
    JeteMc
    07-15-2023, 11:05 AM Go to last post

  40. [SOLVED] How to rank data with multi criteria without duplicate? And Sum by group?

    Started by Manith‎, 07-13-2023 02:16 PM
    1 Attachment(s)
    • 4
    • 214
    Manith
    07-15-2023, 10:30 AM Go to last post

  41. [SOLVED] Extract value from Range Column ignoring blank cells

    Started by d_shaun83‎, 07-15-2023 08:18 AM
    2 Attachment(s)
    • 3
    • 379
    Glenn Kennedy
    07-15-2023, 08:41 AM Go to last post

  42. [SOLVED] Display corresponding name for same number

    Started by kench‎, 09-15-2018 11:56 PM
    1 Attachment(s)
    • 11
    • 1,845
    AliGW
    07-15-2023, 08:38 AM Go to last post

  43. [SOLVED] Sum If when using data with a timestamp

    Started by gemmac‎, 07-15-2023 06:20 AM
    2 Attachment(s)
    • 6
    • 217
    CARACALLA
    07-15-2023, 08:21 AM Go to last post

  44. [SOLVED] conditional formatting that will color all cells with a formula

    Started by Pacho‎, 07-15-2023 05:17 AM
    1 Attachment(s)
    • 4
    • 183
    AliGW
    07-15-2023, 07:51 AM Go to last post

  45. how to parametrise file name in VLOOKUP external link

    Started by Pacho‎, 07-13-2023 07:26 AM
    • 4
    • 296
    Pacho
    07-15-2023, 05:11 AM Go to last post

  46. Icon Sets

    Started by AJAX288‎, 07-14-2023 03:00 PM
    • 1
    • 218
    Andy Pope
    07-15-2023, 04:19 AM Go to last post

  47. [SOLVED] IFERROR(VLOOKUP()) with an IF(ISNA()) condition?

    Started by ckhan84‎, 07-13-2023 09:45 AM
    4 Attachment(s)
    • 17
    • 548
    TMS
    07-15-2023, 02:43 AM Go to last post

  48. Moved: Help calculate progress towards weight loss goal.

    Started by nkkhan‎, 07-14-2023 11:36 PM
    •  
    •  

  49. Pivot Table Conditional Formatting Based on Item and Qty

    Started by Keybler‎, 07-13-2023 09:22 AM
    1 Attachment(s)
    • 3
    • 264
    JeteMc
    07-14-2023, 10:22 PM Go to last post

  50. [SOLVED] Finding most-often (frequency) works or gives REF error

    Started by akedm‎, 07-14-2023 03:42 AM
    4 Attachment(s)
    • 6
    • 326
    windknife
    07-14-2023, 09:09 PM Go to last post
+ Post New Thread
Page 110 of 5615 FirstFirst ... 110 ...

Forum Information and Options

Users Browsing this Forum

There are currently 123 users browsing this forum. (5 members & 118 guests)

  1. goodboy,
  2. NelNeliNelida,
  3. pasha2u,
  4. Phuocam,
  5. swdude12

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