+ Post New Thread
Page 402 of 5614 FirstFirst ... 402 ...
Threads 20051 to 20100 of 280684

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. [SOLVED] Find first cell in range with value and report date from header

    Started by EnergyFX‎, 11-06-2021 01:23 PM
    2 Attachment(s)
    • 7
    • 281
    EnergyFX
    11-07-2021, 02:43 PM Go to last post

  2. [SOLVED] Finding values and blanks in a range.

    Started by parbynat‎, 11-07-2021 01:22 PM
    1 Attachment(s)
    • 3
    • 210
    Fluff13
    11-07-2021, 02:41 PM Go to last post

  3. [SOLVED] Single Formula to Average Numbers based on Percentile/Quintile

    Started by Phillycheese5‎, 11-01-2021 11:27 AM
    3 Attachment(s)
    • 7
    • 380
    Phillycheese5
    11-07-2021, 12:48 PM Go to last post

  4. Convert function using input from a cell.

    Started by john drake‎, 11-06-2021 09:57 AM
    • 14
    • 296
    TMS
    11-07-2021, 12:38 PM Go to last post

  5. [SOLVED] Using multiple criteria with a wildcard to return multiple values

    Started by chrisou‎, 11-06-2021 03:08 PM
    2 Attachment(s)
    • 3
    • 296
    AliGW
    11-07-2021, 04:16 AM Go to last post

  6. Partial Match - Mac characters match

    Started by Prascena‎, 11-06-2021 01:58 PM
    2 Attachment(s)
    • 3
    • 311
    jardiel
    11-06-2021, 09:40 PM Go to last post

  7. [SOLVED] HOURS whats the difference of DAY hours & NIGHT hours per SHIFT formula

    Started by StephanRS‎, 11-04-2021 10:37 AM
    calendar, date, hours, summary 3 Attachment(s)
    • 2
    • 830
    StephanRS
    11-06-2021, 02:35 PM Go to last post

  8. [SOLVED] Formula to bring 3 different status depending on percentage

    Started by eddyrcabrera79‎, 11-06-2021 01:59 PM
    2 Attachment(s)
    • 2
    • 190
    Sam Capricci
    11-06-2021, 02:17 PM Go to last post

  9. Help with customized recipe list that filters to what ingredients you have on hand

    Started by gbest002‎, 11-01-2021 10:51 AM
    3 Attachment(s)
    • 3
    • 757
    JeteMc
    11-06-2021, 12:21 PM Go to last post

  10. Question Linking two tables and selecting highest

    Started by sxAubagne‎, 11-01-2021 09:07 AM
    2 Attachment(s)
    • 3
    • 306
    JeteMc
    11-06-2021, 10:45 AM Go to last post

  11. [SOLVED] LOOKUP Formula Does Not Work

    Started by zanshin777‎, 11-05-2021 01:46 PM
    3 Attachment(s)
    • 5
    • 281
    TMS
    11-06-2021, 10:20 AM Go to last post

  12. [SOLVED] Formula to extract data from worksheets

    Started by cosmica67‎, 11-06-2021 07:31 AM
    2 Attachment(s)
    • 6
    • 251
    cosmica67
    11-06-2021, 08:42 AM Go to last post

  13. How to keep one cell in all copied formulas?

    Started by dan76n‎, 11-06-2021 04:29 AM
    • 3
    • 272
    TMS
    11-06-2021, 06:41 AM Go to last post

  14. Closest distance between 2 zipcodes

    Started by tonycel‎, 10-31-2021 03:25 PM
    2 Attachment(s)
    • 6
    • 1,338
    tonycel
    11-06-2021, 05:44 AM Go to last post

  15. Formulas to calculate average trips per month

    Started by tshepolt‎, 11-05-2021 03:03 AM
    3 Attachment(s)
    • 3
    • 342
    GeoffW283
    11-06-2021, 12:37 AM Go to last post

  16. Lookup with wildcards in table_array

    Started by ef275962‎, 11-01-2021 11:23 AM
    lookup, wildcard 1 Attachment(s)
    • 3
    • 443
    JeteMc
    11-05-2021, 08:53 PM Go to last post

  17. Index Match with ABS and Inequality

    Started by jblack6572‎, 11-05-2021 05:10 PM
    1 Attachment(s)
    • 1
    • 201
    protonLeah
    11-05-2021, 06:06 PM Go to last post

  18. Smile [SOLVED] How to remove ALT+Enter from an Excel Cell

    Started by BBFDSue‎, 11-05-2021 12:38 PM
    alt + enter, many columns, one cell 1 Attachment(s)
    • 3
    • 3,980
    DJunqueira
    11-05-2021, 05:18 PM Go to last post

  19. [SOLVED] Formula to include as a result Symbol + Status

    Started by eddyrcabrera79‎, 11-05-2021 02:53 PM
    2 Attachment(s)
    • 5
    • 232
    DJunqueira
    11-05-2021, 04:26 PM Go to last post

  20. M code Power BI Dashboard transfer to Excel, how to do...?

    Started by Nemesis_3‎, 11-04-2021 02:45 PM
    • 1
    • 227
    DJunqueira
    11-05-2021, 04:22 PM Go to last post

  21. COUNT # of UNIQUE Values Based on Two Criteria

    Started by EvolutionJulie‎, 11-04-2021 02:04 PM
    3 Attachment(s)
    • 4
    • 225
    DJunqueira
    11-05-2021, 03:47 PM Go to last post

  22. Talking Excel Random Quiz Function

    Started by sdw74‎, 11-01-2021 05:05 PM
    2 Attachment(s)
    • 4
    • 296
    sdw74
    11-05-2021, 03:17 PM Go to last post

  23. [SOLVED] Filter Formula with and or

    Started by Timmer2005‎, 11-05-2021 10:54 AM
    filter 2 Attachment(s)
    • 2
    • 310
    Fluff13
    11-05-2021, 03:07 PM Go to last post

  24. Auto-populate information from one tab to another

    Started by thorray‎, 10-18-2021 03:02 PM
    2 Attachment(s)
    • 4
    • 492
    thorray
    11-05-2021, 01:28 PM Go to last post

  25. Transfer specific information from several files to one

    Started by SVM MGMT‎, 11-05-2021 12:28 PM
    4 Attachment(s)
    • 1
    • 155
    JohnTopley
    11-05-2021, 12:48 PM Go to last post

  26. Formula Needed - Year Rolling Dates Calculated From Several Sheets

    Started by ItsAGoodDay‎, 11-01-2021 08:10 AM
    3 Attachment(s)
    • 6
    • 344
    Pete_UK
    11-05-2021, 12:21 PM Go to last post

  27. Calculating Shipped on time

    Started by GOW81‎, 11-05-2021 09:50 AM
    3 Attachment(s)
    • 7
    • 323
    GOW81
    11-05-2021, 12:00 PM Go to last post

  28. [SOLVED] weekly totals

    Started by skipro‎, 11-04-2021 10:31 AM
    8 Attachment(s)
    • 12
    • 294
    skipro
    11-05-2021, 11:44 AM Go to last post

  29. Question How to increase a number monthly

    Started by Doupscud‎, 03-01-2021 04:25 PM
    2 Attachment(s)
    • 7
    • 455
    JeteMc
    11-05-2021, 11:43 AM Go to last post

  30. [SOLVED] IF Function problem

    Started by mal.b.graham‎, 11-05-2021 11:01 AM
    1 Attachment(s)
    • 2
    • 172
    Pete_UK
    11-05-2021, 11:42 AM Go to last post

  31. [SOLVED] VLOOKUP issue, need absolute references

    Started by RichardLP‎, 11-05-2021 09:33 AM
    • 3
    • 240
    MrShorty
    11-05-2021, 11:11 AM Go to last post

  32. [SOLVED] Formula combining or Alterations to Lookup table?

    Started by jhw1998‎, 11-05-2021 06:12 AM
    3 Attachment(s)
    • 4
    • 206
    jhw1998
    11-05-2021, 10:54 AM Go to last post

  33. Retrieve values between different worksheets with conditions

    Started by elcrazyz‎, 11-03-2021 05:54 PM
    3 Attachment(s)
    • 5
    • 285
    Kaper
    11-05-2021, 10:30 AM Go to last post

  34. [SOLVED] SUMIFs on one tab taking data from 4 tabs

    Started by rayted‎, 11-05-2021 08:42 AM
    sumifs 1 Attachment(s)
    • 6
    • 437
    rayted
    11-05-2021, 10:22 AM Go to last post

  35. [SOLVED] How To Find Text In A Cell

    Started by kgtrader‎, 11-01-2021 01:37 PM
    2 Attachment(s)
    • 23
    • 1,008
    JohnTopley
    11-05-2021, 09:47 AM Go to last post

  36. [SOLVED] Formatting based on ID

    Started by Berna11‎, 11-05-2021 06:25 AM
    2 Attachment(s)
    • 5
    • 228
    Berna11
    11-05-2021, 07:17 AM Go to last post

  37. Formula for Calibration Status

    Started by SCopey‎, 10-25-2021 11:14 PM
    3 Attachment(s)
    • 4
    • 340
    SCopey
    11-05-2021, 12:13 AM Go to last post

  38. [SOLVED] Match cell and return range from same row

    Started by tool_fairy‎, 10-26-2021 07:45 AM
    2 Attachment(s)
    • 12
    • 353
    JeteMc
    11-04-2021, 10:36 PM Go to last post

  39. Red face [SOLVED] Calculate number based on Yes/No dropdown

    Started by HannahExcelNewbie‎, 11-03-2021 10:34 PM
    2 Attachment(s)
    • 9
    • 445
    HannahExcelNewbie
    11-04-2021, 07:49 PM Go to last post

  40. How do I create a formula that creates a customized hyperlink based on a cell reference?

    Started by loby‎, 11-04-2021 05:06 PM
    excel, hyper link, javascript, macro (vba)
    • 1
    • 320
    jardiel
    11-04-2021, 05:51 PM Go to last post

  41. Excel - conditional formatting based on start and end date

    Started by Lowanger‎, 11-04-2021 04:41 PM
    1 Attachment(s)
    • 1
    • 189
    TMS
    11-04-2021, 04:55 PM Go to last post

  42. Highlighting cells with same last name with different first names

    Started by davidingilbert‎, 11-04-2021 02:46 PM
    1 Attachment(s)
    • 3
    • 318
    Pete_UK
    11-04-2021, 04:51 PM Go to last post

  43. Have table populate rows automatically

    Started by heytherejem‎, 10-28-2021 10:25 AM
    auto-fill, lookup, range, table
    • 5
    • 478
    Coley356
    11-04-2021, 03:48 PM Go to last post

  44. [SOLVED] Counting cells in-between 2 values

    Started by IreSaffa‎, 11-03-2021 12:47 PM
    1 Attachment(s)
    • 6
    • 281
    FlameRetired
    11-04-2021, 03:34 PM Go to last post

  45. Working out days of rest with IFS function (two criteria)

    Started by caseyjayne23‎, 11-04-2021 09:21 AM
    1 Attachment(s)
    • 11
    • 262
    caseyjayne23
    11-04-2021, 03:04 PM Go to last post

  46. add a cell to a formula

    Started by john_cash‎, 11-04-2021 11:13 AM
    4 Attachment(s)
    • 8
    • 267
    john_cash
    11-04-2021, 03:00 PM Go to last post

  47. Finding & Matching Values Then Returning Sum

    Started by justgeminime‎, 10-30-2021 11:37 AM
    hlookup, match, vlookup 3 Attachment(s)
    • 9
    • 569
    justgeminime
    11-04-2021, 02:57 PM Go to last post

  48. Drop down list with hyperlinks or with referral/jump to another cell

    Started by E-Dan‎, 10-16-2021 07:41 PM
    3 Attachment(s)
    • 9
    • 471
    E-Dan
    11-04-2021, 02:15 PM Go to last post

  49. [SOLVED] Extracting Time from "Text"

    Started by Dexter2‎, 10-05-2021 02:16 PM
    1 Attachment(s)
    • 15
    • 521
    Dexter2
    11-04-2021, 01:10 PM Go to last post

  50. Question [SOLVED] Help with the UNIQUE function to count unique rows

    Started by EK923‎, 11-03-2021 01:27 PM
    • 10
    • 325
    Fluff13
    11-04-2021, 12:52 PM Go to last post
+ Post New Thread
Page 402 of 5614 FirstFirst ... 402 ...

Forum Information and Options

Users Browsing this Forum

There are currently 60 users browsing this forum. (4 members & 56 guests)

  1. boynejs,
  2. cwwazy,
  3. Phuocam,
  4. viewotst

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