+ Post New Thread
Page 11 of 5614 FirstFirst ... 11 ...
Threads 501 to 550 of 280668

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

  1. Moved: max value in a column and data to the left ... then calculate next grouping

    Started by Writingformulas‎, 03-31-2024 07:32 AM
    •  
    •  

  2. [SOLVED] Formulas to Create Time Duration Sequence by Selections

    Started by billy60‎, 03-31-2024 05:42 AM
    2 Attachment(s)
    • 4
    • 103
    AliGW
    03-31-2024, 06:08 AM Go to last post

  3. Smile [SOLVED] last entry by year and #spill error for xlookup

    Started by rafcaf‎, 03-31-2024 12:17 AM
    2 Attachment(s)
    • 1
    • 92
    HansDouwe
    03-31-2024, 01:11 AM Go to last post

  4. [SOLVED] =IF(ISNUMBER(SEARCH to Exclude Similar Values

    Started by BigErnKingpin‎, 03-29-2024 10:12 AM
    =if(isnumber(search 2 Attachment(s)
    • 6
    • 181
    BigErnKingpin
    03-30-2024, 03:04 PM Go to last post

  5. TEXTBEFORE not supported

    Started by andywolfy‎, 03-30-2024 02:42 PM
    • 3
    • 135
    AliGW
    03-30-2024, 02:58 PM Go to last post

  6. [SOLVED] Pass array of data to the excel formula.

    Started by anavarathan‎, 03-30-2024 08:01 AM
    excel array, excel formula 3 Attachment(s)
    • 14
    • 198
    AliGW
    03-30-2024, 02:21 PM Go to last post

  7. [SOLVED] rank order by up to 4 progressive criteria

    Started by geemacmcm‎, 03-28-2024 08:07 AM
    countifs, rank 3 Attachment(s)
    • 6
    • 118
    AliGW
    03-30-2024, 12:57 PM Go to last post

  8. XLOOKUP function results #VALUE! or #N/A

    Started by Medoweb‎, 03-29-2024 04:29 PM
    2 Attachment(s)
    • 5
    • 163
    AliGW
    03-30-2024, 07:48 AM Go to last post

  9. COUNTIFS is not able to solve the task

    Started by vilipec‎, 03-23-2024 06:22 AM
    countifs, multiple columns, time value 5 Attachment(s)
    • 17
    • 242
    AliGW
    03-30-2024, 05:40 AM Go to last post

  10. [SOLVED] MAX Value (COL A) Where Value (COL B) <> Blank

    Started by skydivetom‎, 03-30-2024 12:03 AM
    1 Attachment(s)
    • 4
    • 113
    AliGW
    03-30-2024, 03:27 AM Go to last post

  11. [SOLVED] Win average formula

    Started by makinmomb‎, 03-30-2024 01:06 AM
    2 Attachment(s)
    • 11
    • 109
    josephteh
    03-30-2024, 03:09 AM Go to last post

  12. [SOLVED] If And statements

    Started by allstarparty‎, 03-29-2024 04:34 PM
    • 3
    • 86
    RodyMcAmp
    03-30-2024, 02:10 AM Go to last post

  13. Question Need few tweaks and beautify my excel kpi dashboard.

    Started by xefati652‎, 03-29-2024 10:19 PM
    kpi dashboard, question 1 Attachment(s)
    • 1
    • 111
    AliGW
    03-30-2024, 01:21 AM Go to last post

  14. Finding completion date from a waterfall production schedule

    Started by skagit07‎, 03-28-2024 01:08 PM
    2 Attachment(s)
    • 4
    • 90
    Estevaoba
    03-29-2024, 10:44 PM Go to last post

  15. [SOLVED] Help with a array formula to output results

    Started by KenV15‎, 03-27-2024 08:18 PM
    3 Attachment(s)
    • 17
    • 182
    josephteh
    03-29-2024, 10:15 PM Go to last post

  16. [SOLVED] Array formula but with different formula inbetween column

    Started by FT00‎, 03-27-2024 10:44 PM
    3 Attachment(s)
    • 3
    • 154
    FT00
    03-29-2024, 09:23 PM Go to last post

  17. [SOLVED] Excel formula dynamically auto fill with reference column

    Started by anavarathan‎, 03-29-2024 02:00 PM
    3 Attachment(s)
    • 6
    • 116
    Fluff13
    03-29-2024, 02:44 PM Go to last post

  18. Summing Time into Hours

    Started by Janie‎, 03-29-2024 11:56 AM
    2 Attachment(s)
    • 5
    • 69
    AliGW
    03-29-2024, 02:03 PM Go to last post

  19. Question about conditional formatting

    Started by xraymiller‎, 03-28-2024 01:26 PM
    1 Attachment(s)
    • 7
    • 103
    CarissaKirby
    03-29-2024, 01:56 PM Go to last post

  20. Question IFERROR formula combined with left function

    Started by mannyz8‎, 03-28-2024 05:08 PM
    1 Attachment(s)
    • 7
    • 139
    mannyz8
    03-29-2024, 01:42 PM Go to last post

  21. Conditional Formatting with IF command

    Started by harrylucas‎, 03-29-2024 11:16 AM
    3 Attachment(s)
    • 5
    • 76
    AliGW
    03-29-2024, 12:20 PM Go to last post

  22. [SOLVED] INDEX/MATCH reversed (need to find the value in column A)

    Started by Sybille‎, 03-27-2024 04:00 PM
    6 Attachment(s)
    • 7
    • 205
    Fluff13
    03-29-2024, 10:31 AM Go to last post

  23. Excel calculations on dates

    Started by misjonarka‎, 03-26-2024 10:40 AM
    3 Attachment(s)
    • 9
    • 212
    JeteMc
    03-29-2024, 09:54 AM Go to last post

  24. Question [SOLVED] Color scale conditional formatting based on another cell's value

    Started by dtrimble‎, 12-11-2013 06:34 PM
    • 8
    • 27,802
    AliGW
    03-29-2024, 09:49 AM Go to last post

  25. [SOLVED] How to verify if all values in specific cells match with other cells using a formula?

    Started by rizwanulhasan‎, 12-24-2023 06:33 AM
    15 Attachment(s)
    • 51
    • 1,335
    rizwanulhasan
    03-29-2024, 09:44 AM Go to last post

  26. [SOLVED] XLOOKUP for specific value

    Started by ExcelDavid5‎, 03-29-2024 08:12 AM
    • 7
    • 143
    AliGW
    03-29-2024, 09:32 AM Go to last post

  27. [SOLVED] Nested XLOOKUP help

    Started by ExcelDavid5‎, 03-28-2024 02:31 PM
    nested xlookup 3 Attachment(s)
    • 11
    • 201
    Gregb11
    03-29-2024, 08:30 AM Go to last post

  28. [SOLVED] 3 consecutive vowels categorise

    Started by makinmomb‎, 03-29-2024 03:48 AM
    6 Attachment(s)
    • 10
    • 119
    windknife
    03-29-2024, 07:53 AM Go to last post

  29. Workday and Networkday - Cascading dependencies

    Started by tails1‎, 03-28-2024 10:51 AM
    1 Attachment(s)
    • 6
    • 113
    tails1
    03-29-2024, 07:50 AM Go to last post

  30. Extract Duplicate values in range with criteria

    Started by Spasm752‎, 03-29-2024 02:25 AM
    3 Attachment(s)
    • 7
    • 117
    AliGW
    03-29-2024, 05:26 AM Go to last post

  31. [SOLVED] Indexing correct match using LARGE formula with criteria

    Started by Gochix2018‎, 03-29-2024 04:04 AM
    10 Attachment(s)
    • 16
    • 135
    AliGW
    03-29-2024, 05:25 AM Go to last post

  32. [SOLVED] IF cell Blank return the value to on or another cell

    Started by stefan.g‎, 04-03-2023 09:00 AM
    5 Attachment(s)
    • 21
    • 484
    AliGW
    03-29-2024, 04:51 AM Go to last post

  33. Post The solution for displaying several different descriptions and codes of the same part numb

    Started by Đole1970‎, 03-27-2024 12:44 PM
    2 Attachment(s)
    • 4
    • 155
    Đole1970
    03-29-2024, 04:20 AM Go to last post

  34. Condition Formula

    Started by munaaba‎, 03-29-2024 01:03 AM
    3 Attachment(s)
    • 3
    • 151
    ORoos
    03-29-2024, 02:07 AM Go to last post

  35. Trying to Rank positive numbers in ascending order & negative numbers in descending order

    Started by degiulioh‎, 03-29-2024 01:25 AM
    • 1
    • 93
    windknife
    03-29-2024, 01:54 AM Go to last post

  36. [SOLVED] How to Summarize the counts based on 4 fields? Is xlookup or spill is better for drop down

    Started by mls_newbee‎, 03-26-2024 09:59 PM
    6 Attachment(s)
    • 17
    • 174
    AliGW
    03-29-2024, 01:41 AM Go to last post

  37. "Dynamize the list of names"

    Started by GrabberHackman‎, 03-27-2024 07:15 AM
    7 Attachment(s)
    • 13
    • 439
    GrabberHackman
    03-28-2024, 07:16 PM Go to last post

  38. [SOLVED] Conditional Format Formula

    Started by jlo33‎, 03-28-2024 03:15 PM
    1 Attachment(s)
    • 4
    • 69
    jlo33
    03-28-2024, 03:57 PM Go to last post

  39. [SOLVED] Excel 365 Check Register Calculation Question

    Started by slimpickinz‎, 03-27-2024 11:05 PM
    2 Attachment(s)
    • 5
    • 111
    DJunqueira
    03-28-2024, 03:03 PM Go to last post

  40. Xlookup Help to produce a number if not found on prior tab

    Started by atoice‎, 03-28-2024 02:34 PM
    calculation, max, xlookup 1 Attachment(s)
    • 1
    • 65
    Bernie Deitrick
    03-28-2024, 02:54 PM Go to last post

  41. =max(a1:b1) only returns 0 in empty b1 cell and not number in a1

    Started by easygoingdave‎, 03-28-2024 10:22 AM
    • 8
    • 168
    TMS
    03-28-2024, 02:39 PM Go to last post

  42. Formula Issue IF

    Started by Depressedcorporate‎, 03-28-2024 01:18 PM
    • 5
    • 89
    popipipo
    03-28-2024, 02:03 PM Go to last post

  43. OLE DB Database Files

    Started by CWilson7264‎, 03-27-2024 02:51 PM
    2 Attachment(s)
    • 3
    • 109
    ByteMarks
    03-28-2024, 01:15 PM Go to last post

  44. Random nonrepeating questions and answers for quiz show

    Started by ATCS‎, 03-26-2024 11:19 AM
    2 Attachment(s)
    • 3
    • 104
    ByteMarks
    03-28-2024, 01:13 PM Go to last post

  45. How do I lock in the match lookup value so I can drag a formula to adjacent columns?

    Started by scooter9‎, 03-28-2024 11:36 AM
    1 Attachment(s)
    • 6
    • 95
    scooter9
    03-28-2024, 12:33 PM Go to last post

  46. [SOLVED] Index Match Horizontal Dates

    Started by TimLevs‎, 03-28-2024 10:21 AM
    1 Attachment(s)
    • 6
    • 68
    CARACALLA
    03-28-2024, 11:50 AM Go to last post

  47. Calculate Percentile Based on Two Parameters in a Table

    Started by mklein4902‎, 03-25-2024 05:20 PM
    4 Attachment(s)
    • 7
    • 169
    DJunqueira
    03-28-2024, 11:36 AM Go to last post

  48. Merging multiple tables based on unique id

    Started by siddiqsh‎, 03-28-2024 01:59 AM
    power query 5 Attachment(s)
    • 5
    • 168
    josephteh
    03-28-2024, 10:50 AM Go to last post

  49. [SOLVED] Text in a formula represents a number

    Started by sween123‎, 03-27-2024 05:03 PM
    1 Attachment(s)
    • 6
    • 106
    AliGW
    03-28-2024, 10:43 AM Go to last post

  50. [SOLVED] Count true / false contunuesly from down to up

    Started by sbvaram‎, 03-28-2024 06:43 AM
    6 Attachment(s)
    • 17
    • 181
    Pete_UK
    03-28-2024, 10:09 AM Go to last post
+ Post New Thread
Page 11 of 5614 FirstFirst ... 11 ...

Forum Information and Options

Users Browsing this Forum

There are currently 78 users browsing this forum. (6 members & 72 guests)

  1. etaf,
  2. Howardc1001,
  3. Magalela,
  4. Pete_UK,
  5. tweacle

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