+ Post New Thread
Page 105 of 5614 FirstFirst ... 105 ...
Threads 5201 to 5250 of 280686

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

  1. My Excel File Is Heavy For Use

    Started by soubasa‎, 07-27-2023 12:35 PM
    3 Attachment(s)
    • 11
    • 258
    dosydos
    07-27-2023, 03:45 PM Go to last post

  2. Question How to Add Dropdown in Search Cell or Autocompletes Remaining Letters

    Started by hameezkhan85‎, 07-20-2023 04:00 AM
    autocomplete, dropdown box, search a cell 2 Attachment(s)
    • 1
    • 183
    protonLeah
    07-27-2023, 03:16 PM Go to last post

  3. [SOLVED] Censor email addresses partially

    Started by RookA1‎, 06-14-2023 09:55 PM
    5 Attachment(s)
    • 6
    • 678
    6StringJazzer
    07-27-2023, 02:58 PM Go to last post

  4. [SOLVED] Network days with time fraction (less than full working day)

    Started by Micfree1‎, 07-26-2023 01:39 PM
    2 Attachment(s)
    • 9
    • 251
    HansDouwe
    07-27-2023, 02:24 PM Go to last post

  5. [SOLVED] Create unique combinations

    Started by zz_zz11‎, 07-27-2023 12:10 AM
    3 Attachment(s)
    • 6
    • 396
    HansDouwe
    07-27-2023, 02:16 PM Go to last post

  6. Excel Drag and Drop Script

    Started by mvaccarino‎, 07-27-2023 12:57 PM
    • 0
    • 185
    mvaccarino
    07-27-2023, 12:57 PM Go to last post

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

  8. 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
    • 452
    smartangel
    07-27-2023, 12:30 PM Go to last post

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

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

  11. [SOLVED] Unable to Vlookup with Textsplit function

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

  12. [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
    • 243
    haroonkhurshid
    07-27-2023, 10:59 AM Go to last post

  13. [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
    • 214
    AliGW
    07-27-2023, 10:37 AM Go to last post

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

  15. Array formula division help needed

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

  16. Lookup Last Values from List

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

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

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

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

  19. [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
    • 141
    Sritcho
    07-27-2023, 05:48 AM Go to last post

  20. [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
    • 152
    AliGW
    07-27-2023, 05:46 AM Go to last post

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

  22. [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
    • 267
    AliGW
    07-27-2023, 04:21 AM Go to last post

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

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

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

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

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

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

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

  27. Create unique combinations

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

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

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

  29. [SOLVED] Return Maximum Value from Next column

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

  30. Look Up if t cells Match

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

  31. Calculated Result Based On Matching Rows?

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

  32. Running Totals for Bank Balances

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

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

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

  34. [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
    • 331
    Pete_UK
    07-26-2023, 01:10 PM Go to last post

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

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

  36. 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
    • 361
    Glenn Kennedy
    07-26-2023, 12:10 PM Go to last post

  37. [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
    • 175
    AliGW
    07-26-2023, 11:19 AM Go to last post

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

  39. [SOLVED] Countifs across mutliple sheets

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

  40. Copy a function to a whole column

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

  41. Grace Period

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

  42. [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
    • 256
    HansDouwe
    07-26-2023, 08:59 AM Go to last post

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

  44. [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
    • 153
    pnasir
    07-26-2023, 06:46 AM Go to last post

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

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

  46. 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
    • 404
    AliGW
    07-26-2023, 04:18 AM Go to last post

  47. [SOLVED] Excluding weekends from Gantt Chart

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

  48. 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
    • 336
    pasqualebaldi
    07-25-2023, 09:28 PM Go to last post

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

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

  50. COUNT Functions

    Started by Vocieee‎, 07-20-2023 09:10 PM
    count and if, formula 2 Attachment(s)
    • 8
    • 376
    Phuocam
    07-25-2023, 08:31 PM Go to last post
+ Post New Thread
Page 105 of 5614 FirstFirst ... 105 ...

Forum Information and Options

Users Browsing this Forum

There are currently 86 users browsing this forum. (1 members & 85 guests)

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