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

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

  1. Calculate Percentile Based on Two Parameters in a Table

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

  2. Merging multiple tables based on unique id

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

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

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

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

  5. 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
    • 78
    JohnTopley
    03-28-2024, 10:02 AM Go to last post

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

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

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

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

  9. [SOLVED] making a column invisible

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

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

  11. [SOLVED] How to add amounts of time

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

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

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

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

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

  15. 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
    • 83
    DJunqueira
    03-28-2024, 12:12 AM Go to last post

  16. If/XLOOKUP formulas creation assistance

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

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

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

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

  20. Mass Conditional Formatting?

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

  21. 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
    • 155
    HansDouwe
    03-27-2024, 01:01 PM Go to last post

  22. Producing sales history on point of sale

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

  23. 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
    • 139
    DJunqueira
    03-27-2024, 12:12 PM Go to last post

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

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

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

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

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

  27. 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
    • 87
    DaWenj
    03-27-2024, 10:33 AM Go to last post

  28. 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
    • 129
    TMS
    03-27-2024, 08:13 AM Go to last post

  29. [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
    • 117
    dxfoxd
    03-27-2024, 06:19 AM Go to last post

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

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

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

  32. [SOLVED] VLOOKUP keeps looking through 0/blank values

    Started by Catsonheat‎, 03-24-2024 08:51 AM
    2 Attachment(s)
    • 11
    • 145
    Glenn Kennedy
    03-27-2024, 05:19 AM Go to last post

  33. Data not being shown correctly from scanned QR code

    Started by aphrogirl2002‎, 03-13-2024 04:45 PM
    3 Attachment(s)
    • 4
    • 157
    Kaper
    03-27-2024, 03:27 AM Go to last post

  34. Calculating time based on event formula help

    Started by scorpain‎, 03-20-2024 08:10 AM
    8 Attachment(s)
    • 17
    • 299
    AliGW
    03-27-2024, 01:22 AM Go to last post

  35. [SOLVED] Trying to combine an =MIN(IF___) with =MAX(IF_____) into 1 formula.

    Started by KMDRR‎, 03-25-2024 09:48 PM
    5 Attachment(s)
    • 19
    • 356
    AliGW
    03-27-2024, 01:17 AM Go to last post

  36. year keep showing as 1905

    Started by kratos2004‎, 03-26-2024 08:40 PM
    1 Attachment(s)
    • 2
    • 97
    teb21
    03-26-2024, 09:27 PM Go to last post

  37. Analysis of student exam results, determining pass or fail

    Started by mfhaq77‎, 03-26-2024 04:33 PM
    • 1
    • 89
    alansidman
    03-26-2024, 08:32 PM Go to last post

  38. [SOLVED] Allocation of patient volumes creating a spread issue due to rounding

    Started by LVHNJames‎, 03-21-2024 12:43 PM
    4 Attachment(s)
    • 6
    • 320
    DJunqueira
    03-26-2024, 07:47 PM Go to last post

  39. Question I need to count employees active at a certain time based on start and end dates

    Started by monsterboogie‎, 07-31-2023 05:59 PM
    5 Attachment(s)
    • 10
    • 1,114
    HansDouwe
    03-26-2024, 07:36 PM Go to last post

  40. Calculating bonus value based on percentage of goal met

    Started by embailey‎, 03-26-2024 04:22 PM
    1 Attachment(s)
    • 1
    • 72
    dosydos
    03-26-2024, 04:37 PM Go to last post

  41. [SOLVED] create running total by year inside a table

    Started by rafcaf‎, 03-25-2024 11:45 PM
    3 Attachment(s)
    • 9
    • 138
    JohnTopley
    03-26-2024, 03:28 PM Go to last post

  42. Conditional Formatting for cells that refer to other cells

    Started by Max16hr‎, 03-25-2024 01:25 PM
    cell, conditional formatting, formulatext, reference 1 Attachment(s)
    • 3
    • 109
    dosydos
    03-26-2024, 02:41 PM Go to last post

  43. Splitting the content of one cell into individual cells and combining cells afterwards

    Started by Jean_Sibelius‎, 03-24-2024 12:47 PM
    1 Attachment(s)
    • 7
    • 143
    JohnTopley
    03-26-2024, 02:30 PM Go to last post

  44. [SOLVED] Need Help Split Text If Possible with specific condition

    Started by ZANDRY10085‎, 03-26-2024 06:59 AM
    5 Attachment(s)
    • 21
    • 157
    TMS
    03-26-2024, 02:16 PM Go to last post

  45. [SOLVED] Formula Name Errors

    Started by billy60‎, 03-26-2024 08:45 AM
    2 Attachment(s)
    • 4
    • 68
    6StringJazzer
    03-26-2024, 02:00 PM Go to last post

  46. Need formula to show which ever category has the highest value, it will show the name

    Started by Depressedcorporate‎, 03-26-2024 01:51 PM
    • 1
    • 61
    Bernie Deitrick
    03-26-2024, 01:58 PM Go to last post

  47. [SOLVED] Sorting names by Surname Alphabetically without using two columns

    Started by Marvo‎, 03-25-2024 07:42 PM
    6 Attachment(s)
    • 18
    • 238
    Marvo
    03-26-2024, 01:42 PM Go to last post

  48. [SOLVED] Formulas for Vehicle Service Overview sheet

    Started by billy60‎, 03-26-2024 11:04 AM
    4 Attachment(s)
    • 5
    • 76
    DJunqueira
    03-26-2024, 12:18 PM Go to last post

  49. Need Help to Show Duplicate Values and Count It (With or Without Specific Criteria)

    Started by ZANDRY10085‎, 03-26-2024 09:11 AM
    3 Attachment(s)
    • 3
    • 93
    Bernie Deitrick
    03-26-2024, 11:25 AM Go to last post

  50. Trying to extract Year and Day out of a table

    Started by boynejs‎, 03-26-2024 10:32 AM
    3 Attachment(s)
    • 4
    • 75
    Glenn Kennedy
    03-26-2024, 10:43 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 66 users browsing this forum. (6 members & 60 guests)

  1. cocoybubu,
  2. D2S,
  3. HansDouwe,
  4. Jordon R,
  5. samba_ravi,
  6. Sultan1994

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