+ Post New Thread
Page 1 of 5442 1 2 3 11 51 101 501 1001 ... LastLast
Threads 1 to 50 of 272085

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
    1 Attachment(s)
    • 19
    • 153,542
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. Searching and changing data when com[paring two tables....

    Started by dive1082‎, Today 09:00 AM
    1 Attachment(s)
    • 0
    • 3
    dive1082
    Today, 09:00 AM Go to last post

  2. Automatically change a cells reference cell at the start of every month?

    Started by DarkSoul‎, Today 08:58 AM
    1 Attachment(s)
    • 0
    • 1
    DarkSoul
    Today, 08:58 AM Go to last post

  3. Need help with INDEX formula

    Started by Tirrazo‎, 02-01-2023 01:37 PM
    7 Attachment(s)
    • 16
    • 133
    Tirrazo
    Today, 08:56 AM Go to last post

  4. How to calculate hours between 2 dates.

    Started by daithy‎, Today 08:49 AM
    • 0
    • 7
    daithy
    Today, 08:49 AM Go to last post

  5. Formula to get min and max with conditions

    Started by zeez36‎, Yesterday 06:59 AM
    2 Attachment(s)
    • 5
    • 86
    zeez36
    Today, 08:47 AM Go to last post

  6. Formula to put number in right place based on input

    Started by jokr10ae‎, 01-30-2023 06:52 AM
    2 Attachment(s)
    • 10
    • 107
    Pete_UK
    Today, 08:37 AM Go to last post

  7. Formula to count down x rows and return a value. Possible?

    Started by dance621‎, Today 06:10 AM
    • 3
    • 44
    TMS
    Today, 08:35 AM Go to last post

  8. Cool [SOLVED] Round up Custom [h]:mm;@ hours e.g. 55260:26 to 55261

    Started by Fionn Phelan‎, Today 07:22 AM
    1 Attachment(s)
    • 3
    • 23
    Pete_UK
    Today, 08:33 AM Go to last post

  9. Need Help finding top 10% of values for each date

    Started by LexingtonStanley‎, Today 08:25 AM
    conditional formatting, formulas & functions
    • 0
    • 7
    LexingtonStanley
    Today, 08:25 AM Go to last post

  10. Generate next IDs based on existing list

    Started by guillaume0314‎, Today 03:31 AM
    5 Attachment(s)
    • 7
    • 101
    Glenn Kennedy
    Today, 08:06 AM Go to last post

  11. [SOLVED] To extract number from string using excel formula

    Started by JaffarAhamed‎, 01-24-2023 09:18 AM
    1 Attachment(s)
    • 9
    • 135
    sandy666
    Today, 07:52 AM Go to last post

  12. Post Advanced Transposing

    Started by JPehrson‎, Today 02:22 AM
    transposing data 5 Attachment(s)
    • 7
    • 85
    JohnTopley
    Today, 07:31 AM Go to last post

  13. Rotating Overtime List

    Started by tamatha222‎, Today 07:12 AM
    1 Attachment(s)
    • 0
    • 33
    tamatha222
    Today, 07:12 AM Go to last post

  14. Splitting text into columns

    Started by Frick‎, Yesterday 06:07 PM
    • 3
    • 68
    sandy666
    Today, 07:05 AM Go to last post

  15. [SOLVED] Find max date with three conditions met

    Started by avk‎, Yesterday 09:08 AM
    max date 5 Attachment(s)
    • 6
    • 89
    CARACALLA
    Today, 06:59 AM Go to last post

  16. [SOLVED] #N/A and auto formula

    Started by El-Fidel‎, Today 12:22 AM
    2 Attachment(s)
    • 3
    • 51
    Glenn Kennedy
    Today, 06:58 AM Go to last post

  17. I need to hide certain rows in a sheet so it would seem like there's no data to show

    Started by rhonn‎, Yesterday 12:55 PM
    • 1
    • 54
    AskMeAboutExcel
    Today, 06:53 AM Go to last post

  18. Question Invoices issued (or planned to be issued) vs. collection (variable days per client)

    Started by LT1511‎, Yesterday 03:13 PM
    2 Attachment(s)
    • 6
    • 94
    LT1511
    Today, 06:07 AM Go to last post

  19. Complex unique count formula

    Started by Eustace07‎, 01-31-2023 03:57 PM
    3 Attachment(s)
    • 6
    • 204
    Eustace07
    Today, 05:58 AM Go to last post

  20. How to make a live tracker that updates other cells as data is entered

    Started by parkerryan‎, 02-01-2023 05:00 PM
    data validation, formula, function, quota, tracker 2 Attachment(s)
    • 3
    • 91
    AskMeAboutExcel
    Today, 05:58 AM Go to last post

  21. Can I use yyyy-mm-dd h:mm:ss date/time format to calculate the duration form two date

    Started by Andrevdhillcrest‎, Today 05:21 AM
    • 2
    • 45
    avk
    Today, 05:57 AM Go to last post

  22. Converting 15 minute interval data into Half hourly data

    Started by stadleybear‎, Yesterday 02:24 PM
    3 Attachment(s)
    • 4
    • 95
    stadleybear
    Today, 05:49 AM Go to last post

  23. How to make whole spreadsheet hard numbers and remove all formulas

    Started by paata01‎, Yesterday 07:15 PM
    hard numbers, hardcoded
    • 6
    • 82
    avk
    Today, 05:40 AM Go to last post

  24. Formula to Fill Series of Weekdays from a Starting Date

    Started by rehana402003‎, Today 04:04 AM
    2 Attachment(s)
    • 5
    • 60
    JohnTopley
    Today, 05:36 AM Go to last post

  25. Tracking inventory in and out from multiple sheets. Not sure how to write formula?

    Started by 3997bloom‎, Yesterday 02:37 PM
    • 1
    • 62
    muhammadridho30
    Today, 02:13 AM Go to last post

  26. Circular Formula

    Started by francoiscj1‎, Today 01:14 AM
    1 Attachment(s)
    • 2
    • 50
    avk
    Today, 01:53 AM Go to last post

  27. Choose cell value based on dropdown list but not choose that dropdown value

    Started by ballgnm‎, Today 01:26 AM
    dropdown list
    • 1
    • 39
    FDibbins
    Today, 01:43 AM Go to last post

  28. Adjusting formula with nested IF and/or functions

    Started by nmkl98‎, Yesterday 04:12 PM
    1 Attachment(s)
    • 1
    • 53
    muhammadridho30
    Today, 12:13 AM Go to last post

  29. Post Week Number (Thurs to Wed)

    Started by ChGatsby‎, Yesterday 10:22 PM
    • 1
    • 60
    Glenn Kennedy
    Yesterday, 11:04 PM Go to last post

  30. Splitting Row by values into multiple rows

    Started by subvtech‎, 01-27-2023 11:15 AM
    8 Attachment(s)
    • 19
    • 234
    6StringJazzer
    Yesterday, 10:45 PM Go to last post

  31. Randomise data from a column into another

    Started by k3v1n_23‎, Yesterday 07:31 PM
    3 Attachment(s)
    • 2
    • 57
    Glenn Kennedy
    Yesterday, 10:44 PM Go to last post

  32. Question [SOLVED] Multiple Date Format Conversion (with Text versions)

    Started by B.B‎, 02-01-2023 06:53 AM
    2 Attachment(s)
    • 5
    • 76
    Glenn Kennedy
    Yesterday, 09:54 PM Go to last post

  33. Allocating the most repeated text and sorting it in a specific cell

    Started by tumanovr‎, 02-01-2023 03:17 PM
    #filter, #table #formula, #top 3 4 Attachment(s)
    • 6
    • 100
    Glenn Kennedy
    Yesterday, 09:38 PM Go to last post

  34. [SOLVED] How to set referenced cell to empty instead of zero.

    Started by paata01‎, Yesterday 06:55 PM
    • 3
    • 60
    Pete_UK
    Yesterday, 09:36 PM Go to last post

  35. [SOLVED] Error Message: You've entered too many arguments for this function

    Started by nmkl98‎, Yesterday 01:03 PM
    • 3
    • 67
    Pete_UK
    Yesterday, 09:04 PM Go to last post

  36. [SOLVED] Calculate the volume based on the number of the tank

    Started by meonly123‎, 01-29-2023 02:06 PM
    6 Attachment(s)
    • 17
    • 224
    meonly123
    Yesterday, 07:43 PM Go to last post

  37. Index Match and minimum

    Started by ghol‎, Yesterday 06:48 PM
    2 Attachment(s)
    • 2
    • 60
    TMS
    Yesterday, 07:43 PM Go to last post

  38. Xlookup or Index/Match Confusion

    Started by jjward101‎, 02-01-2023 07:35 PM
    xlookup 2 Attachment(s)
    • 1
    • 90
    protonLeah
    Yesterday, 07:27 PM Go to last post

  39. Formula to lookup payment with payment amount and date

    Started by thematrix05‎, 02-01-2023 05:42 PM
    1 Attachment(s)
    • 3
    • 83
    wk9128
    Yesterday, 06:35 PM Go to last post

  40. I will pay if someone can make this Payroll Worksheet function (this is a 911 for me).

    Started by petrodataJAMES‎, Yesterday 04:55 PM
    1 Attachment(s)
    • 3
    • 59
    petrodataJAMES
    Yesterday, 06:04 PM Go to last post

  41. Excel Formula assuming an if then else formula?

    Started by CarolSic‎, Yesterday 04:12 PM
    excel formula, help a dummy 1 Attachment(s)
    • 1
    • 49
    TMS
    Yesterday, 05:52 PM Go to last post

  42. Set Cell Value based on Top Row (in viewport)

    Started by NewYears1978‎, Yesterday 05:13 PM
    1 Attachment(s)
    • 0
    • 52
    NewYears1978
    Yesterday, 05:13 PM Go to last post

  43. Vlookup and duplicates

    Started by Arejayy‎, Yesterday 02:50 PM
    2 Attachment(s)
    • 2
    • 69
    thenewkidd
    Yesterday, 05:08 PM Go to last post

  44. Populate table in one tab by retrieving data from another tab

    Started by caamfin‎, Yesterday 04:20 PM
    1 Attachment(s)
    • 0
    • 45
    caamfin
    Yesterday, 04:20 PM Go to last post

  45. Question How to add a fixed value to ANY cell in a chart based on a fixed condition

    Started by achaudhri‎, 02-01-2023 05:55 PM
    condition formula 2 Attachment(s)
    • 1
    • 60
    dflak
    Yesterday, 04:03 PM Go to last post

  46. Formula to calculate new worth based on today's date

    Started by thematrix05‎, 02-01-2023 05:54 PM
    3 Attachment(s)
    • 2
    • 77
    JohnTopley
    Yesterday, 03:57 PM Go to last post

  47. Lookup Array in a Match function

    Started by grkchakri‎, Yesterday 02:25 PM
    1 Attachment(s)
    • 1
    • 52
    JohnTopley
    Yesterday, 03:19 PM Go to last post

  48. Pivot calculation error when adding another level

    Started by jamesharris123‎, 01-31-2023 09:51 PM
    2 Attachment(s)
    • 1
    • 67
    dflak
    Yesterday, 02:48 PM Go to last post

  49. [SOLVED] Calculating a "total" when a cost changes between ranges

    Started by ckhan84‎, Yesterday 11:05 AM
    2 Attachment(s)
    • 3
    • 78
    JohnTopley
    Yesterday, 02:31 PM Go to last post

  50. [SOLVED] Help, Countif

    Started by Miche1e38‎, Yesterday 01:09 PM
    1 Attachment(s)
    • 4
    • 64
    Pete_UK
    Yesterday, 02:08 PM Go to last post
+ Post New Thread
Page 1 of 5442 1 2 3 11 51 101 501 1001 ... LastLast

Forum Information and Options

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