+ Post New Thread
Page 11 of 5613 FirstFirst ... 11 ...
Threads 501 to 550 of 280641

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

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

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

  3. Extract Duplicate values in range with criteria

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

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

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

  5. [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
    • 483
    AliGW
    03-29-2024, 04:51 AM Go to last post

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

  7. Condition Formula

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

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

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

  10. "Dynamize the list of names"

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

  11. [SOLVED] Conditional Format Formula

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

  12. [SOLVED] Excel 365 Check Register Calculation Question

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

  13. 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
    • 63
    Bernie Deitrick
    03-28-2024, 02:54 PM Go to last post

  14. =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
    • 166
    TMS
    03-28-2024, 02:39 PM Go to last post

  15. Formula Issue IF

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

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

  17. Random nonrepeating questions and answers for quiz show

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

  18. 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
    • 94
    scooter9
    03-28-2024, 12:33 PM Go to last post

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

  20. Calculate Percentile Based on Two Parameters in a Table

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

  21. Merging multiple tables based on unique id

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

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

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

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

  24. Calculate sum for selected entries in column c plus selected entries in column d.

    Started by ArkInv‎, 03-28-2024 09:19 AM
    column totals, summary formula
    • 2
    • 79
    JohnTopley
    03-28-2024, 10:02 AM Go to last post

  25. Dynamic Lookup code

    Started by abz2786‎, 03-27-2024 08:09 AM
    8 Attachment(s)
    • 18
    • 171
    Glenn Kennedy
    03-28-2024, 09:44 AM Go to last post

  26. [SOLVED] Formula(s) to populate cells based on several criteria

    Started by christopherparrish‎, 03-28-2024 08:33 AM
    consolidating, formulas 1 Attachment(s)
    • 5
    • 101
    AliGW
    03-28-2024, 08:53 AM Go to last post

  27. [SOLVED] sumproduct - TOO MUCH or LESS consider the new values if added

    Started by stefan.g‎, 03-27-2024 07:18 PM
    • 2
    • 134
    AliGW
    03-28-2024, 08:30 AM Go to last post

  28. [SOLVED] making a column invisible

    Started by Bailymaus‎, 03-25-2024 04:41 PM
    2 Attachment(s)
    • 11
    • 169
    wk9128
    03-28-2024, 08:21 AM Go to last post

  29. Conditional formatting number of days remaining

    Started by Wilkinson921‎, 03-28-2024 07:54 AM
    1 Attachment(s)
    • 1
    • 48
    AliGW
    03-28-2024, 07:55 AM Go to last post

  30. [SOLVED] How to add amounts of time

    Started by JT101‎, 03-28-2024 05:43 AM
    2 Attachment(s)
    • 9
    • 115
    AliGW
    03-28-2024, 07:20 AM Go to last post

  31. [SOLVED] Calculate Date Difference in Years, Months, Weeks and Days

    Started by KRIXXXX‎, 03-23-2024 03:39 PM
    3 Attachment(s)
    • 6
    • 217
    Glenn Kennedy
    03-28-2024, 04:01 AM Go to last post

  32. Angry Formulas Changing in Conditional Formatting After Pivot Refresh

    Started by idkcy‎, 03-27-2024 01:47 PM
    conditional formatiting, formula change, pivot refresh 2 Attachment(s)
    • 2
    • 94
    AliGW
    03-28-2024, 03:18 AM Go to last post

  33. [SOLVED] Excel Formula needed: Find Phone Number(s) in a string

    Started by Brisbanejez‎, 03-27-2024 10:58 PM
    4 Attachment(s)
    • 7
    • 138
    HansDouwe
    03-28-2024, 02:35 AM Go to last post

  34. Compare two rows in first column, having text value in same integer, add values of all row

    Started by shameem.s‎, 03-27-2024 11:02 PM
    1 Attachment(s)
    • 1
    • 85
    DJunqueira
    03-28-2024, 12:12 AM Go to last post

  35. If/XLOOKUP formulas creation assistance

    Started by slewis123‎, 03-27-2024 04:37 PM
    3 Attachment(s)
    • 3
    • 146
    slewis123
    03-27-2024, 05:44 PM Go to last post

  36. Rolling Stock Levels for Assembly Component Levels

    Started by Keith650‎, 03-27-2024 08:44 AM
    2 Attachment(s)
    • 3
    • 93
    Keebellah
    03-27-2024, 04:30 PM Go to last post

  37. Exclamation [SOLVED] I need help creating a formula that shows Arrival and Departure dates based on data set

    Started by NotaRobot10‎, 03-27-2024 01:13 PM
    3 Attachment(s)
    • 9
    • 122
    HansDouwe
    03-27-2024, 04:04 PM Go to last post

  38. Function to look up value based on two factors

    Started by oleg232000‎, 03-27-2024 03:10 PM
    2 Attachment(s)
    • 2
    • 83
    DJunqueira
    03-27-2024, 03:54 PM Go to last post

  39. Mass Conditional Formatting?

    Started by Glado‎, 03-20-2024 12:55 PM
    5 Attachment(s)
    • 8
    • 193
    Glado
    03-27-2024, 01:33 PM Go to last post

  40. Question [SOLVED] How can I enhance this SUMPRODUCT formula to only counts cells greater than zero?

    Started by schnide‎, 03-27-2024 05:36 AM
    sumproduct 4 Attachment(s)
    • 17
    • 156
    HansDouwe
    03-27-2024, 01:01 PM Go to last post

  41. Producing sales history on point of sale

    Started by sunboy‎, 03-27-2024 06:20 AM
    3 Attachment(s)
    • 8
    • 205
    JohnTopley
    03-27-2024, 12:23 PM Go to last post

  42. Help needed to create formula to display amts for specific months only

    Started by Fred Houck‎, 03-26-2024 01:04 PM
    2 Attachment(s)
    • 6
    • 142
    DJunqueira
    03-27-2024, 12:12 PM Go to last post

  43. Formula to find nth Value based on multiple criteria with duplicates

    Started by caitlinkeats1‎, 03-22-2024 05:17 PM
    4 Attachment(s)
    • 3
    • 151
    caitlinkeats1
    03-27-2024, 11:27 AM Go to last post

  44. Find and extract text from cell

    Started by jlausier‎, 03-27-2024 10:57 AM
    • 1
    • 47
    AliGW
    03-27-2024, 11:02 AM Go to last post

  45. [SOLVED] Trying to find a source segment of a formula

    Started by Marvo‎, 03-27-2024 08:53 AM
    • 7
    • 89
    Marvo
    03-27-2024, 10:42 AM Go to last post

  46. Question [SOLVED] Booking document need Help

    Started by DaWenj‎, 03-27-2024 06:17 AM
    booking, formula, how do i fix?, limitation, lock 2 Attachment(s)
    • 2
    • 88
    DaWenj
    03-27-2024, 10:33 AM Go to last post

  47. If I am combining functions to construct a big formula, how to determine its arrangements?

    Started by daliye‎, 03-27-2024 05:30 AM
    • 4
    • 130
    TMS
    03-27-2024, 08:13 AM Go to last post

  48. [SOLVED] SUM, FILTER using a dynamic range to calculate Year to date (YTD) data

    Started by dxfoxd‎, 03-26-2024 07:42 PM
    filter formula, offset formula, year from date, year to date 1 Attachment(s)
    • 3
    • 121
    dxfoxd
    03-27-2024, 06:19 AM Go to last post

  49. [SOLVED] Due Highlight Rules Replace Previous With Latest

    Started by billy60‎, 03-26-2024 07:14 PM
    2 Attachment(s)
    • 5
    • 178
    billy60
    03-27-2024, 05:52 AM Go to last post

  50. [SOLVED] List of customers with products ordered

    Started by chri1977‎, 03-26-2024 08:21 AM
    3 Attachment(s)
    • 9
    • 198
    chri1977
    03-27-2024, 05:36 AM Go to last post
+ Post New Thread
Page 11 of 5613 FirstFirst ... 11 ...

Forum Information and Options

Users Browsing this Forum

There are currently 87 users browsing this forum. (5 members & 82 guests)

  1. HansDouwe,
  2. krishnapg,
  3. Narbar_123,
  4. varbergt,
  5. weishida

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