+ Post New Thread
Page 500 of 5613 FirstFirst ... 500 ...
Threads 24951 to 25000 of 280637

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

  1. formula to highlight the top 3, 5 values in a row (for eg., in cells FA2 to GE2)

    Started by raja1964‎, 04-30-2021 01:24 PM
    2 Attachment(s)
    • 3
    • 264
    protonLeah
    05-02-2021, 04:00 PM Go to last post

  2. Lightbulb How to replace " from a Text?

    Started by Sybon‎, 05-02-2021 07:54 AM
    clean, replace, special character, substitute
    • 10
    • 498
    Rick Rothstein
    05-02-2021, 03:23 PM Go to last post

  3. Lightbulb [SOLVED] Adding multiple If conditions to a VLOOKUP function formula

    Started by Khaldon‎, 05-02-2021 11:42 AM
    2 Attachment(s)
    • 5
    • 310
    Khaldon
    05-02-2021, 02:35 PM Go to last post

  4. VPM Mix Sub-Calculations

    Started by warmstrong77‎, 04-27-2021 01:18 PM
    1 Attachment(s)
    • 1
    • 292
    FlameRetired
    05-02-2021, 02:12 PM Go to last post

  5. [SOLVED] Left, Right, Mid, or Substitute function to separate values into desired columns

    Started by bjnockle‎, 05-01-2021 08:59 PM
    2 Attachment(s)
    • 7
    • 347
    kvsrinivasamurthy
    05-02-2021, 10:40 AM Go to last post

  6. [SOLVED] Highlighting cells between columns in a row

    Started by Bilidikid‎, 05-02-2021 09:11 AM
    highlighting 2 Attachment(s)
    • 8
    • 379
    AliGW
    05-02-2021, 10:02 AM Go to last post

  7. How many IDs in column A match two criteria in column B?

    Started by J4KARTA‎, 04-24-2021 12:43 PM
    4 Attachment(s)
    • 10
    • 465
    J4KARTA
    05-02-2021, 09:41 AM Go to last post

  8. [SOLVED] Repeat Data using Dynamic Formula

    Started by leprince2007‎, 05-01-2021 08:17 AM
    1 Attachment(s)
    • 6
    • 377
    Fluff13
    05-02-2021, 08:23 AM Go to last post

  9. [SOLVED] Formula to increase a unique Id number that uses text and numbers

    Started by Stryfe‎, 05-02-2021 04:05 AM
    • 1
    • 236
    JohnTopley
    05-02-2021, 04:41 AM Go to last post

  10. [SOLVED] Returning unique values based on duplicate criteria

    Started by Excelfresh‎, 05-01-2021 06:44 PM
    duplicate, index + match 2 Attachment(s)
    • 7
    • 525
    JohnTopley
    05-02-2021, 02:48 AM Go to last post

  11. [SOLVED] Returning outstanding invoice amount for partial payments

    Started by mehdi_154‎, 04-12-2021 09:29 AM
    2 Attachment(s)
    • 8
    • 661
    mehdi_154
    05-02-2021, 02:47 AM Go to last post

  12. [SOLVED] Non Array Formula to Extract Unique Values

    Started by bjnockle‎, 04-30-2021 05:42 AM
    1 Attachment(s)
    • 3
    • 449
    AliGW
    05-02-2021, 02:44 AM Go to last post

  13. [SOLVED] Revenue and expenses list

    Started by sunboy‎, 05-01-2021 03:30 PM
    4 Attachment(s)
    • 8
    • 421
    Bo_Ry
    05-02-2021, 01:16 AM Go to last post

  14. [SOLVED] DATEDIF not working

    Started by Peterino‎, 05-01-2021 09:14 AM
    1 Attachment(s)
    • 5
    • 5,371
    Rick Rothstein
    05-01-2021, 06:44 PM Go to last post

  15. [SOLVED] Formula to alamgamate and edit?

    Started by LMills77‎, 04-30-2021 05:02 AM
    2 Attachment(s)
    • 10
    • 349
    JohnTopley
    05-01-2021, 04:08 PM Go to last post

  16. [SOLVED] Replace a term in one column with value in next column

    Started by reags‎, 05-01-2021 01:48 AM
    3 Attachment(s)
    • 10
    • 549
    AliGW
    05-01-2021, 03:53 PM Go to last post

  17. Adding rules for using keywords

    Started by Browne‎, 05-01-2021 09:51 AM
    2 Attachment(s)
    • 3
    • 334
    JohnTopley
    05-01-2021, 01:21 PM Go to last post

  18. Date formatting

    Started by chris8877‎, 05-01-2021 09:20 AM
    3 Attachment(s)
    • 2
    • 261
    Czeslaw
    05-01-2021, 09:58 AM Go to last post

  19. Group Countif formula with multiple conditions

    Started by suneeshpillai‎, 05-01-2021 05:29 AM
    3 Attachment(s)
    • 7
    • 368
    JohnTopley
    05-01-2021, 09:42 AM Go to last post

  20. [SOLVED] Formula to count finish times x amount of people

    Started by MR_STOPA‎, 04-30-2021 02:24 PM
    4 Attachment(s)
    • 9
    • 358
    JohnTopley
    05-01-2021, 09:02 AM Go to last post

  21. [SOLVED] Planned vs Actual Formula

    Started by juan.doe‎, 07-15-2014 12:21 AM
    7 Attachment(s)
    • 17
    • 4,884
    AliGW
    05-01-2021, 07:27 AM Go to last post

  22. Index Match to exclude numbers

    Started by hokielin‎, 04-30-2021 08:42 PM
    index match, mode arrays
    • 4
    • 447
    Sam Capricci
    05-01-2021, 05:33 AM Go to last post

  23. Rank by Descending, then if tie, rank by Ascending

    Started by lloyd2709‎, 04-30-2021 01:49 PM
    points, rank, rank two columns 1 Attachment(s)
    • 2
    • 373
    kvsrinivasamurthy
    05-01-2021, 03:34 AM Go to last post

  24. Split date ranges into single rows per date

    Started by HowieB‎, 10-05-2010 10:19 AM
    3 Attachment(s)
    • 18
    • 7,950
    JohnTopley
    05-01-2021, 02:34 AM Go to last post

  25. [SOLVED] Check cell if following specific pattern

    Started by naomieatsgreens‎, 04-27-2021 10:07 PM
    • 11
    • 460
    Rick Rothstein
    05-01-2021, 01:49 AM Go to last post

  26. Pulling Data from One Sheet to Another with Matches

    Started by grb23‎, 04-30-2021 10:00 AM
    1 Attachment(s)
    • 7
    • 400
    AliGW
    05-01-2021, 12:45 AM Go to last post

  27. Count if max < threshold

    Started by pickslides‎, 04-30-2021 02:59 AM
    5 Attachment(s)
    • 9
    • 377
    AliGW
    05-01-2021, 12:32 AM Go to last post

  28. [SOLVED] Require Formula to find date (data) on another sheet and input data from cell below

    Started by GolfNut39‎, 04-28-2021 07:09 PM
    2 Attachment(s)
    • 5
    • 319
    Pete_UK
    04-30-2021, 08:04 PM Go to last post

  29. Formula to copy and paste cell data when a condition is met.

    Started by ashishpatel34‎, 04-30-2021 05:17 PM
    1 Attachment(s)
    • 1
    • 300
    TMS
    04-30-2021, 06:48 PM Go to last post

  30. [SOLVED] Using If cell not empty as criteria within a SUMIFS statement

    Started by pptdgc1999‎, 04-28-2021 12:10 PM
    1 Attachment(s)
    • 23
    • 680
    JohnTopley
    04-30-2021, 04:57 PM Go to last post

  31. [SOLVED] Concatenate 2 numbers and keep a "000000.00" format

    Started by weareallstardust‎, 04-30-2021 11:43 AM
    concatenate, join 2 Attachment(s)
    • 4
    • 483
    AliGW
    04-30-2021, 04:03 PM Go to last post

  32. Calculate total hours scheduled each hours of the day

    Started by Trippi‎, 04-27-2021 04:35 PM
    6 Attachment(s)
    • 23
    • 654
    FlameRetired
    04-30-2021, 02:58 PM Go to last post

  33. Using IF AND OR

    Started by PropTrd‎, 04-30-2021 02:18 PM
    • 4
    • 216
    Fluff13
    04-30-2021, 02:30 PM Go to last post

  34. How to extract Text and Numbers from a Cell

    Started by acandan21‎, 04-27-2021 01:07 PM
    • 4
    • 362
    ChemistB
    04-30-2021, 02:10 PM Go to last post

  35. [SOLVED] Match to 3 criteria the return results

    Started by JennOlsen‎, 04-30-2021 12:32 PM
    2 Attachment(s)
    • 2
    • 223
    JennOlsen
    04-30-2021, 12:59 PM Go to last post

  36. Sum total by year , user

    Started by booney440‎, 04-30-2021 09:45 AM
    excel & formula 5 Attachment(s)
    • 6
    • 331
    etaf
    04-30-2021, 12:45 PM Go to last post

  37. Question Check if row is valid based on multiple criteria from range...

    Started by JMHenriques‎, 04-30-2021 12:29 PM
    2 Attachment(s)
    • 1
    • 220
    JohnTopley
    04-30-2021, 12:31 PM Go to last post

  38. [SOLVED] Formulas Not Increasing Properly in Table

    Started by sussington‎, 04-28-2021 11:19 AM
    2 Attachment(s)
    • 8
    • 282
    cubangt
    04-30-2021, 12:12 PM Go to last post

  39. [SOLVED] Address cell to reference row

    Started by WAAZUPEE‎, 04-30-2021 10:57 AM
    1 Attachment(s)
    • 4
    • 285
    WAAZUPEE
    04-30-2021, 11:42 AM Go to last post

  40. [SOLVED] Formula to find entries with duplicate value in one column AND differing value in another

    Started by MadMaxineisMad‎, 04-28-2021 05:13 PM
    2 Attachment(s)
    • 7
    • 307
    MadMaxineisMad
    04-30-2021, 09:45 AM Go to last post

  41. Post [SOLVED] Adding a conditional IF to a VLOOKUP function formula

    Started by Khaldon‎, 04-30-2021 07:04 AM
    1 Attachment(s)
    • 3
    • 272
    Sam Capricci
    04-30-2021, 07:39 AM Go to last post

  42. Formula calculating values depending on value in drop down list.

    Started by urr100‎, 04-30-2021 06:45 AM
    2 Attachment(s)
    • 1
    • 188
    JohnTopley
    04-30-2021, 07:36 AM Go to last post

  43. [SOLVED] list of unique Scrip Name

    Started by btparkhe1920‎, 04-30-2021 03:10 AM
    1 Attachment(s)
    • 8
    • 353
    JohnTopley
    04-30-2021, 07:35 AM Go to last post

  44. Put data into different cell

    Started by gmarquis‎, 04-30-2021 06:10 AM
    • 5
    • 237
    JohnTopley
    04-30-2021, 07:20 AM Go to last post

  45. Link an image to cell value to display specific images

    Started by Peter Morgan‎, 04-27-2021 11:31 AM
    2 Attachment(s)
    • 5
    • 342
    Peter Morgan
    04-30-2021, 07:03 AM Go to last post

  46. Search for a text and then search for another text after the row containing the first text

    Started by ajeshkdy‎, 04-30-2021 05:33 AM
    1 Attachment(s)
    • 2
    • 258
    ajeshkdy
    04-30-2021, 06:10 AM Go to last post

  47. Combine data from two columns

    Started by Even‎, 04-28-2021 04:38 AM
    5 Attachment(s)
    • 15
    • 478
    Even
    04-30-2021, 06:06 AM Go to last post

  48. [SOLVED] Highlight column of current weeknumber

    Started by PatrickEasy‎, 04-28-2021 10:04 AM
    1 Attachment(s)
    • 5
    • 1,608
    PatrickEasy
    04-30-2021, 05:14 AM Go to last post

  49. Question [SOLVED] Counting specific value when various are within cell?

    Started by digbee‎, 04-30-2021 04:22 AM
    formula, ifs formula, ifstatement 1 Attachment(s)
    • 3
    • 324
    digbee
    04-30-2021, 04:38 AM Go to last post

  50. Summing Multiple Row of Data

    Started by mark2323‎, 04-29-2021 03:06 PM
    2 Attachment(s)
    • 4
    • 260
    kvsrinivasamurthy
    04-30-2021, 04:05 AM Go to last post
+ Post New Thread
Page 500 of 5613 FirstFirst ... 500 ...

Forum Information and Options

Users Browsing this Forum

There are currently 57 users browsing this forum. (1 members & 56 guests)

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