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

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

  1. [SOLVED] sumif with <> in criteria

    Started by yllew‎, 02-28-2024 02:41 AM
    2 Attachment(s)
    • 5
    • 226
    yllew
    04-01-2024, 09:11 AM Go to last post

  2. Drawdown- calculate size and length of multiple drawdown phases (non-VBA)

    Started by chipps24‎, 02-02-2015 07:44 AM
    3 Attachment(s)
    • 20
    • 18,961
    AliGW
    04-01-2024, 09:06 AM Go to last post

  3. [SOLVED] Problems getting a column to SPILL down

    Started by Marvo‎, 04-01-2024 07:53 AM
    1 Attachment(s)
    • 6
    • 68
    Fluff13
    04-01-2024, 08:19 AM Go to last post

  4. [SOLVED] Conditional formatting to highlight percentages

    Started by viewotst‎, 03-29-2024 09:43 AM
    9 Attachment(s)
    • 13
    • 185
    viewotst
    04-01-2024, 08:15 AM Go to last post

  5. [SOLVED] Extract Text and Value from Cells to total

    Started by WAULKMILLFH‎, 03-25-2024 10:45 AM
    11 Attachment(s)
    • 23
    • 253
    WAULKMILLFH
    04-01-2024, 04:37 AM Go to last post

  6. How to assign values

    Started by maiykl‎, 03-27-2024 10:27 PM
    3 Attachment(s)
    • 8
    • 141
    azumi
    04-01-2024, 12:43 AM Go to last post

  7. [SOLVED] XLOOKUP not working with LEFT RIGHT.

    Started by Ochimus‎, 03-31-2024 12:24 PM
    2 Attachment(s)
    • 5
    • 95
    AliGW
    03-31-2024, 04:50 PM Go to last post

  8. [SOLVED] Sumproduct of every Nth column changing every 9 columns

    Started by stefan.g‎, 03-20-2023 03:45 PM
    15 Attachment(s)
    • 40
    • 638
    stefan.g
    03-31-2024, 01:08 PM Go to last post

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

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

  10. [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

  11. 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

  12. [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

  13. 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

  14. [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
    • 199
    AliGW
    03-30-2024, 02:21 PM Go to last post

  15. [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

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

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

  17. 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

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

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

  19. [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

  20. [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

  21. 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

  22. 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

  23. [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

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

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

  25. [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

  26. 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

  27. 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

  28. Question IFERROR formula combined with left function

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

  29. 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

  30. [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
    • 206
    Fluff13
    03-29-2024, 10:31 AM Go to last post

  31. Excel calculations on dates

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

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

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

  33. [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

  34. [SOLVED] XLOOKUP for specific value

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

  35. [SOLVED] Nested XLOOKUP help

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

  36. [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

  37. 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

  38. 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

  39. [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

  40. [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

  41. 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

  42. Condition Formula

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

  43. 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

  44. [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
    • 175
    AliGW
    03-29-2024, 01:41 AM Go to last post

  45. "Dynamize the list of names"

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

  46. [SOLVED] Conditional Format Formula

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

  47. [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

  48. 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

  49. =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

  50. Formula Issue IF

    Started by Depressedcorporate‎, 03-28-2024 01:18 PM
    • 5
    • 90
    popipipo
    03-28-2024, 02:03 PM Go to last post
+ Post New Thread
Page 11 of 5614 FirstFirst ... 11 ...

Forum Information and Options

Users Browsing this Forum

There are currently 83 users browsing this forum. (5 members & 78 guests)

  1. CARCHER05,
  2. fadeze,
  3. Ravana,
  4. tungten9x

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