+ Post New Thread
Page 101 of 5610 FirstFirst ... 101 ...
Threads 5001 to 5050 of 280481

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

  1. [SOLVED] Formula to calculate a list of all the possible combinations

    Started by The_Snook‎, 07-27-2023 07:26 AM
    2 Attachment(s)
    • 14
    • 255
    HansDouwe
    07-27-2023, 12:37 PM Go to last post

  2. Match a name with two columns, then displaying the most RECENT number

    Started by smartangel‎, 07-23-2023 11:57 PM
    6 Attachment(s)
    • 14
    • 451
    smartangel
    07-27-2023, 12:30 PM Go to last post

  3. How can I find a cell higher than x and replace it with x/y?

    Started by Druss1965‎, 07-27-2023 11:55 AM
    • 2
    • 154
    Druss1965
    07-27-2023, 12:00 PM Go to last post

  4. One Formula for Different Cases

    Started by RUPESHRH‎, 07-27-2023 10:21 AM
    1 Attachment(s)
    • 6
    • 159
    AliGW
    07-27-2023, 11:32 AM Go to last post

  5. [SOLVED] Unable to Vlookup with Textsplit function

    Started by rakul_rakul‎, 07-27-2023 09:31 AM
    3 Attachment(s)
    • 4
    • 1,114
    Fluff13
    07-27-2023, 11:16 AM Go to last post

  6. [SOLVED] Formula to add Values based on Criteria as month, Quarter and Yeartodate. Exclude colored

    Started by haroonkhurshid‎, 07-26-2023 03:16 PM
    add, criteria, highlighted, sum, sumifs 2 Attachment(s)
    • 6
    • 242
    haroonkhurshid
    07-27-2023, 10:59 AM Go to last post

  7. [SOLVED] Lookup newest value from a column in another workbook

    Started by OilfieldTim‎, 07-27-2023 09:27 AM
    lookup, multiple work books, vlookup
    • 4
    • 210
    AliGW
    07-27-2023, 10:37 AM Go to last post

  8. Filtering Rows by criteria

    Started by Grant T‎, 07-27-2023 09:48 AM
    1 Attachment(s)
    • 1
    • 132
    AliGW
    07-27-2023, 09:55 AM Go to last post

  9. Array formula division help needed

    Started by katexcel93‎, 07-27-2023 07:23 AM
    2 Attachment(s)
    • 7
    • 329
    Fluff13
    07-27-2023, 09:46 AM Go to last post

  10. Lookup Last Values from List

    Started by Captain_Ahab‎, 07-27-2023 08:13 AM
    1 Attachment(s)
    • 1
    • 176
    Fluff13
    07-27-2023, 08:15 AM Go to last post

  11. Conditional page breaks

    Started by jp9669‎, 07-24-2023 05:19 PM
    1 Attachment(s)
    • 4
    • 216
    tanasedn
    07-27-2023, 06:01 AM Go to last post

  12. Smile [SOLVED] Highest most frequent value in a column

    Started by Miggy2021‎, 07-27-2023 03:40 AM
    4 Attachment(s)
    • 15
    • 353
    HansDouwe
    07-27-2023, 05:54 AM Go to last post

  13. [SOLVED] Use Conditional Formatting to Highlight Variance Between Hours Worked and Hours Booked

    Started by Sritcho‎, 07-27-2023 05:00 AM
    2 Attachment(s)
    • 5
    • 139
    Sritcho
    07-27-2023, 05:48 AM Go to last post

  14. [SOLVED] Converting year in fascial year format into a full date in fascial year format

    Started by uqls‎, 07-27-2023 02:45 AM
    1 Attachment(s)
    • 6
    • 151
    AliGW
    07-27-2023, 05:46 AM Go to last post

  15. [SOLVED] Remove blank in front and back of text , number

    Started by kimudao‎, 07-27-2023 02:57 AM
    4 Attachment(s)
    • 17
    • 306
    kimudao
    07-27-2023, 05:07 AM Go to last post

  16. [SOLVED] Want to extract a data from two sheets by comparing column values

    Started by MAKRUMAHESH‎, 07-27-2023 03:05 AM
    2 Attachment(s)
    • 12
    • 264
    AliGW
    07-27-2023, 04:21 AM Go to last post

  17. how to stop my vlookup auto populate the rest of the cell below.

    Started by iwanttoexcelinexcel‎, 07-27-2023 03:09 AM
    1 Attachment(s)
    • 1
    • 155
    AliGW
    07-27-2023, 03:14 AM Go to last post

  18. [SOLVED] Calculate the estimated date and Time to complete the operation

    Started by meonly123‎, 07-26-2023 03:09 PM
    3 Attachment(s)
    • 7
    • 269
    HansDouwe
    07-27-2023, 02:58 AM Go to last post

  19. [SOLVED] Date Difference Between Today and 6th. of each Month

    Started by skywriter‎, 07-26-2023 04:14 PM
    • 6
    • 188
    AliGW
    07-27-2023, 02:40 AM Go to last post

  20. Creating template file, data is mismatch in rows.

    Started by Paulie752‎, 07-26-2023 04:55 PM
    1 Attachment(s)
    • 3
    • 149
    AliGW
    07-27-2023, 02:12 AM Go to last post

  21. Create unique combinations

    Started by zz_zz11‎, 07-27-2023 01:48 AM
    1 Attachment(s)
    • 1
    • 145
    AliGW
    07-27-2023, 02:06 AM Go to last post

  22. Stock Balance (Pivot Table and/or Formula Solution Required)

    Started by john555‎, 07-18-2023 04:58 AM
    3 Attachment(s)
    • 13
    • 461
    JeteMc
    07-26-2023, 10:53 PM Go to last post

  23. [SOLVED] Return Maximum Value from Next column

    Started by Micfree1‎, 07-26-2023 12:19 PM
    2 Attachment(s)
    • 15
    • 340
    FlameRetired
    07-26-2023, 10:07 PM Go to last post

  24. Look Up if t cells Match

    Started by babylock99‎, 07-26-2023 05:59 PM
    formula 1 Attachment(s)
    • 3
    • 184
    ExceLogan
    07-26-2023, 09:55 PM Go to last post

  25. Calculated Result Based On Matching Rows?

    Started by MojoGene‎, 07-26-2023 02:28 PM
    2 Attachment(s)
    • 9
    • 247
    MojoGene
    07-26-2023, 05:05 PM Go to last post

  26. Running Totals for Bank Balances

    Started by Captain_Ahab‎, 01-13-2023 09:42 AM
    2 Attachment(s)
    • 7
    • 323
    alansidman
    07-26-2023, 01:49 PM Go to last post

  27. Smile [SOLVED] count items in column chosen by column heading

    Started by ab0ajh‎, 07-26-2023 11:24 AM
    2 Attachment(s)
    • 7
    • 226
    Pete_UK
    07-26-2023, 01:17 PM Go to last post

  28. [SOLVED] Insert TEXT in same cell when color of the cell goes to change

    Started by RUPESHRH‎, 07-26-2023 09:32 AM
    4 Attachment(s)
    • 12
    • 326
    Pete_UK
    07-26-2023, 01:10 PM Go to last post

  29. [SOLVED] Formula to Calculate Betting Odds for Horse Races

    Started by JN831‎, 07-25-2023 09:24 PM
    3 Attachment(s)
    • 31
    • 2,596
    HansDouwe
    07-26-2023, 12:45 PM Go to last post

  30. Incorporating a column letter listed in another cell for a referring formula

    Started by Andrewstupendo‎, 07-26-2023 10:22 AM
    3 Attachment(s)
    • 6
    • 344
    Glenn Kennedy
    07-26-2023, 12:10 PM Go to last post

  31. [SOLVED] Averageifs: average a data set if cell next to it is between 100 and 120

    Started by TheSeventhCrow‎, 07-26-2023 11:00 AM
    • 6
    • 174
    AliGW
    07-26-2023, 11:19 AM Go to last post

  32. Question [SOLVED] Averageifs: average a data set if cell next to it is equal to 120

    Started by TheSeventhCrow‎, 07-25-2023 01:08 PM
    1 Attachment(s)
    • 11
    • 239
    AliGW
    07-26-2023, 10:49 AM Go to last post

  33. [SOLVED] Countifs across mutliple sheets

    Started by JaySanctuary‎, 07-26-2023 07:30 AM
    2 Attachment(s)
    • 5
    • 265
    AliGW
    07-26-2023, 10:48 AM Go to last post

  34. Copy a function to a whole column

    Started by Nimad9‎, 07-14-2023 08:43 AM
    4 Attachment(s)
    • 12
    • 503
    JeteMc
    07-26-2023, 10:05 AM Go to last post

  35. Grace Period

    Started by mafify‎, 07-25-2023 12:59 PM
    2 Attachment(s)
    • 4
    • 332
    Pete_UK
    07-26-2023, 09:13 AM Go to last post

  36. [SOLVED] If condition based on the values

    Started by arun.sj‎, 07-26-2023 07:52 AM
    formula and if statement, if condition, if condition in excel, if conditions, if formula excel
    • 6
    • 250
    HansDouwe
    07-26-2023, 08:59 AM Go to last post

  37. [SOLVED] Calculating values between date ranges

    Started by ravage509‎, 07-26-2023 03:44 AM
    6 Attachment(s)
    • 19
    • 385
    HansDouwe
    07-26-2023, 07:32 AM Go to last post

  38. [SOLVED] Formula to use Indirect with Index and Match from Different Sheets

    Started by pnasir‎, 07-26-2023 04:24 AM
    2 Attachment(s)
    • 5
    • 150
    pnasir
    07-26-2023, 06:46 AM Go to last post

  39. Loan Grace periods, & a complicated sum function.

    Started by mafify‎, 07-25-2023 06:18 AM
    3 Attachment(s)
    • 8
    • 253
    mafify
    07-26-2023, 06:06 AM Go to last post

  40. Question [SOLVED] Find the latest PO number from the same item with INDEX-MATCH & helper column.

    Started by Addvocado9‎, 07-26-2023 02:10 AM
    index, match & index 4 Attachment(s)
    • 5
    • 402
    AliGW
    07-26-2023, 04:18 AM Go to last post

  41. [SOLVED] Excluding weekends from Gantt Chart

    Started by Yannis07‎, 12-23-2020 06:31 AM
    8 Attachment(s)
    • 18
    • 5,941
    FDibbins
    07-26-2023, 12:41 AM Go to last post

  42. Auto populate values for a month based on a previous months value

    Started by pasqualebaldi‎, 07-23-2023 01:53 PM
    5 Attachment(s)
    • 6
    • 331
    pasqualebaldi
    07-25-2023, 09:28 PM Go to last post

  43. I am trying to out together an occupancy for my nursery.

    Started by Jennyz1231‎, 07-25-2023 03:57 PM
    1 Attachment(s)
    • 2
    • 386
    HansDouwe
    07-25-2023, 08:31 PM Go to last post

  44. COUNT Functions

    Started by Vocieee‎, 07-20-2023 09:10 PM
    count and if, formula 2 Attachment(s)
    • 8
    • 375
    Phuocam
    07-25-2023, 08:31 PM Go to last post

  45. Summing Across Tabs Using a Dropdown

    Started by jac5939‎, 07-25-2023 05:24 PM
    2 Attachment(s)
    • 4
    • 181
    jac5939
    07-25-2023, 06:31 PM Go to last post

  46. Adding complexity/ more criteria to some formulas

    Started by slewis123‎, 07-24-2023 04:47 PM
    1 Attachment(s)
    • 5
    • 223
    TMS
    07-25-2023, 04:02 PM Go to last post

  47. Best method for automatic Cell updating in Formula

    Started by picataggio‎, 07-25-2023 03:51 PM
    • 1
    • 133
    HansDouwe
    07-25-2023, 04:01 PM Go to last post

  48. [SOLVED] Trying to Resolve #Name? Errors in Transition from Google Sheets to Excel

    Started by terrykalaka‎, 07-20-2023 08:06 AM
    2 Attachment(s)
    • 10
    • 344
    terrykalaka
    07-25-2023, 02:57 PM Go to last post

  49. Question [SOLVED] Concatenate a Spill

    Started by purgamentum‎, 07-25-2023 01:58 PM
    concatenate, spill
    • 2
    • 550
    purgamentum
    07-25-2023, 02:24 PM Go to last post

  50. [SOLVED] Need help with date calculations

    Started by kyber‎, 07-25-2023 10:23 AM
    4 Attachment(s)
    • 14
    • 306
    AliGW
    07-25-2023, 11:28 AM Go to last post
+ Post New Thread
Page 101 of 5610 FirstFirst ... 101 ...

Forum Information and Options

Users Browsing this Forum

There are currently 101 users browsing this forum. (5 members & 96 guests)

  1. JohnTopley,
  2. pelowski,
  3. TMS

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