+ Post New Thread
Page 5010 of 5613 FirstFirst ... 5010 ...
Threads 250451 to 250500 of 280643

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

  1. [SOLVED] Remove time from date

    Started by kimudao‎, 11-24-2022 02:33 AM
    5 Attachment(s)
    • 10
    • 295
    AliGW
    11-24-2022, 04:45 AM Go to last post

  2. Comparing two sets of cells

    Started by Shortstop96‎, 08-08-2022 09:46 AM
    dimensions, index 2 Attachment(s)
    • 4
    • 295
    Shortstop96
    08-08-2022, 10:19 AM Go to last post

  3. Find number of streaks in a row and length of each streak

    Started by zachwalkerpinto‎, 08-12-2022 02:51 PM
    2 Attachment(s)
    • 3
    • 295
    protonLeah
    08-12-2022, 08:09 PM Go to last post

  4. how to create formula to change cell value based on selected any cell in a range

    Started by eugz‎, 08-17-2022 05:28 PM
    • 2
    • 295
    FDibbins
    08-18-2022, 11:55 PM Go to last post

  5. [SOLVED] Need formula to categorize shift from start and end date and time

    Started by crusadessword‎, 12-20-2022 10:59 PM
    excel 2016 formula 2 Attachment(s)
    • 4
    • 295
    breadwinner
    12-22-2022, 09:44 PM Go to last post

  6. [SOLVED] match lookup multiple column

    Started by petercheunghk‎, 10-18-2022 11:57 PM
    4 Attachment(s)
    • 4
    • 295
    alansidman
    10-19-2022, 10:18 AM Go to last post

  7. Count available employees per hour

    Started by Mazza1444‎, 09-21-2022 04:40 PM
    4 Attachment(s)
    • 5
    • 295
    HansDouwe
    09-22-2022, 03:18 AM Go to last post

  8. How to return a fixed value from a cell which keeps changing its value

    Started by kate999‎, 12-09-2022 05:09 AM
    1 Attachment(s)
    • 13
    • 295
    kate999
    12-10-2022, 01:41 PM Go to last post

  9. How to extract the corresponding numbers in area A to area B

    Started by choletseng‎, 10-08-2022 06:41 PM
    1 Attachment(s)
    • 5
    • 295
    wk9128
    12-21-2022, 09:38 AM Go to last post

  10. Exclamation [SOLVED] Merging 3 sheets to one then using FILTER function [EXAMPLE ATTACHED]

    Started by Magaletta‎, 10-19-2022 05:05 AM
    8 Attachment(s)
    • 18
    • 295
    Glenn Kennedy
    10-19-2022, 08:22 AM Go to last post

  11. Replace outlier and empty cell to calculate reliable average

    Started by Gian11‎, 10-12-2022 04:29 AM
    3 Attachment(s)
    • 3
    • 295
    Glenn Kennedy
    10-12-2022, 07:48 AM Go to last post

  12. [SOLVED] Vlookup to show different sub categories in the same category

    Started by Guitarist‎, 05-04-2023 03:40 PM
    formu, how to, vlookup 3 Attachment(s)
    • 4
    • 295
    sandy666
    05-04-2023, 04:22 PM Go to last post

  13. Output multiple blocks of data from LET

    Started by ardross‎, 08-19-2022 04:29 AM
    2 Attachment(s)
    • 11
    • 295
    Bo_Ry
    08-19-2022, 10:03 AM Go to last post

  14. Need formula to return phrase based upon drop down choice

    Started by Mojo77‎, 02-17-2023 02:33 PM
    4 Attachment(s)
    • 11
    • 295
    TMS
    02-17-2023, 08:58 PM Go to last post

  15. Xlookup with multiple rows and values

    Started by motospeedo‎, 03-04-2023 02:46 PM
    3 Attachment(s)
    • 9
    • 295
    TMS
    03-07-2023, 10:07 AM Go to last post

  16. Display Best to Worst Exit

    Started by FXA‎, 03-05-2023 12:57 PM
    1 Attachment(s)
    • 4
    • 295
    JeteMc
    03-08-2023, 11:38 PM Go to last post

  17. Match three items in a list to create a new list

    Started by brandonmcg‎, 03-31-2023 10:48 AM
    1 Attachment(s)
    • 2
    • 295
    brandonmcg
    03-31-2023, 05:23 PM Go to last post

  18. [SOLVED] Coloring Like Rows Non-Repeating

    Started by Ekazumon‎, 04-13-2023 04:31 PM
    color, conditional format, formula, group, rows 2 Attachment(s)
    • 2
    • 295
    Ekazumon
    04-14-2023, 11:59 AM Go to last post

  19. [SOLVED] Calculate Sales Price to achieve margin

    Started by Mingeita‎, 05-02-2023 10:43 AM
    2 Attachment(s)
    • 11
    • 295
    josephteh
    05-04-2023, 07:27 AM Go to last post

  20. [SOLVED] sort date ascending if certain conditions met

    Started by raj soni‎, 05-10-2023 10:45 AM
    3 Attachment(s)
    • 5
    • 295
    sandy666
    05-22-2023, 03:48 AM Go to last post

  21. Conditional Format row based on multiple criteria

    Started by RamblinRacer‎, 06-22-2023 08:19 AM
    2 Attachment(s)
    • 4
    • 295
    RamblinRacer
    06-22-2023, 12:22 PM Go to last post

  22. how to parametrise file name in VLOOKUP external link

    Started by Pacho‎, 07-13-2023 07:26 AM
    • 4
    • 295
    Pacho
    07-15-2023, 05:11 AM Go to last post

  23. Index Match Using MULTIPLE CRITERIA

    Started by jackoooooo‎, 07-15-2023 11:06 AM
    1 Attachment(s)
    • 4
    • 295
    windknife
    07-15-2023, 11:42 AM Go to last post

  24. Post [SOLVED] Simplifying complex formula

    Started by Gulya‎, 01-04-2024 01:12 PM
    4 Attachment(s)
    • 5
    • 295
    windknife
    01-06-2024, 06:01 AM Go to last post

  25. [SOLVED] Copying over a formula after removing a criteria.

    Started by Marvo‎, 11-04-2023 05:35 PM
    2 Attachment(s)
    • 6
    • 295
    AliGW
    11-05-2023, 05:04 AM Go to last post

  26. Count Instances of X in Multiple Cells Not in a Range

    Started by 360Excel‎, 07-28-2022 10:25 AM
    4 Attachment(s)
    • 5
    • 295
    BadlySpelledBuoy
    07-28-2022, 03:35 PM Go to last post

  27. Spellnumber function Not Working in Old Excel Sheettt

    Started by gore a.t.‎, 12-05-2021 03:55 AM
    • 3
    • 295
    AliGW
    01-21-2022, 07:20 AM Go to last post

  28. [SOLVED] Count Number of Instances Column B >= Column A Without Helper Cells

    Started by TheMechEngineer‎, 02-17-2022 09:09 PM
    2 Attachment(s)
    • 6
    • 295
    Pete_UK
    02-17-2022, 10:05 PM Go to last post

  29. Updating months in sequential order based off starting month

    Started by colliebe‎, 02-20-2022 08:28 PM
    1 Attachment(s)
    • 6
    • 295
    USAF
    02-21-2022, 02:52 AM Go to last post

  30. calculate the best combination of numbers

    Started by nils_sverker‎, 03-26-2022 08:13 PM
    2 Attachment(s)
    • 2
    • 295
    Alf
    03-27-2022, 07:46 AM Go to last post

  31. Function to highlight numbers in sequence. Copy corresponding numbers

    Started by JM6544088‎, 07-09-2022 03:01 PM
    4 Attachment(s)
    • 4
    • 295
    JM6544088
    07-10-2022, 04:30 AM Go to last post

  32. [SOLVED] Conditional Formatting Formula Based on Several Conditions

    Started by applehugger‎, 02-17-2022 03:12 PM
    3 Attachment(s)
    • 10
    • 295
    applehugger
    02-17-2022, 04:51 PM Go to last post

  33. [SOLVED] Form a total days date based on a date and a total number of days

    Started by choletseng‎, 02-14-2022 08:27 PM
    1 Attachment(s)
    • 4
    • 295
    wk9128
    02-15-2022, 07:11 PM Go to last post

  34. [SOLVED] Help with averageifs function

    Started by bigband1‎, 03-23-2022 01:04 PM
    3 Attachment(s)
    • 5
    • 295
    Bo_Ry
    03-24-2022, 09:58 AM Go to last post

  35. [SOLVED] Nested IF, AND THEN forumla

    Started by CLAIRE0701‎, 05-15-2022 11:10 AM
    2 Attachment(s)
    • 11
    • 295
    menem
    05-16-2022, 05:44 AM Go to last post

  36. [SOLVED] Replace OFFSET with INDEX+COUNTIF

    Started by dcantere‎, 04-28-2022 08:08 AM
    • 11
    • 295
    dcantere
    04-28-2022, 10:10 AM Go to last post

  37. [SOLVED] Conditional Highlighting across different sheets and different columns

    Started by Laura Rose‎, 08-03-2022 10:13 AM
    4 Attachment(s)
    • 9
    • 295
    etaf
    08-04-2022, 04:34 PM Go to last post

  38. VALUE OFFSET function not working as expected

    Started by BMD4‎, 01-31-2022 11:14 PM
    2 Attachment(s)
    • 6
    • 295
    FDibbins
    02-01-2022, 02:48 PM Go to last post

  39. [SOLVED] Values in every row when the values come from a sheet where value in every 2nd row

    Started by grambograham‎, 10-09-2012 04:09 PM
    • 2
    • 294
    grambograham
    10-09-2012, 05:01 PM Go to last post

  40. Checking formulae

    Started by Dominykas‎, 11-28-2013 05:32 AM
    1 Attachment(s)
    • 1
    • 294
    Pete_UK
    11-28-2013, 05:50 AM Go to last post

  41. validating data

    Started by jt1672‎, 04-16-2014 11:31 AM
    1 Attachment(s)
    • 2
    • 294
    jt1672
    04-16-2014, 01:57 PM Go to last post

  42. help me in the formula

    Started by shabirgul‎, 05-04-2014 04:14 AM
    1 Attachment(s)
    • 1
    • 294
    zbor
    05-04-2014, 04:57 AM Go to last post

  43. Help returning information

    Started by aatch‎, 06-11-2014 03:21 AM
    • 1
    • 294
    aatch
    06-11-2014, 03:22 AM Go to last post

  44. Lightbulb Lookup and multiple column calculation

    Started by Mick S‎, 07-09-2014 03:26 PM
    1 Attachment(s)
    • 0
    • 294
    Mick S
    07-09-2014, 03:26 PM Go to last post

  45. Division by zero when the pay dates are the same with different items.

    Started by joaquinwalking‎, 08-04-2014 03:04 PM
    1 Attachment(s)
    • 2
    • 294
    Speshul
    08-04-2014, 03:35 PM Go to last post

  46. if function does not display value

    Started by RhapsodyBay‎, 02-02-2015 03:53 PM
    • 1
    • 294
    Jonmo1
    02-02-2015, 03:57 PM Go to last post

  47. What type of formula is this?

    Started by aschwalge‎, 01-30-2015 10:56 AM
    • 2
    • 294
    shg
    01-30-2015, 12:42 PM Go to last post

  48. Question pictures / graphics link between worksheets

    Started by CEEOrlando‎, 03-18-2015 05:38 PM
    • 0
    • 294
    CEEOrlando
    03-18-2015, 05:38 PM Go to last post

  49. Min if formula

    Started by ginamarieann‎, 03-19-2015 01:15 PM
    • 2
    • 294
    Richard Buttrey
    03-19-2015, 01:21 PM Go to last post

  50. Date Format Help

    Started by itshere‎, 03-24-2015 02:55 PM
    • 3
    • 294
    Fettertiger
    03-24-2015, 03:16 PM Go to last post
+ Post New Thread
Page 5010 of 5613 FirstFirst ... 5010 ...

Forum Information and Options

Users Browsing this Forum

There are currently 99 users browsing this forum. (6 members & 93 guests)

  1. Danilo Flaiban,
  2. etaf,
  3. ExcelNewbie92,
  4. HansDouwe,
  5. Maryse Roy,
  6. samyraj

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