+ Post New Thread
Page 6 of 5614 FirstFirst ... 6 ...
Threads 251 to 300 of 280690

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

  1. Filter with time window (Array function?)

    Started by timenewroman‎, 04-15-2024 09:29 AM
    1 Attachment(s)
    • 1
    • 69
    AliGW
    04-15-2024, 09:31 AM Go to last post

  2. [SOLVED] Excel formula to find out what workday of a month is a particular date

    Started by samyraj‎, 04-15-2024 05:02 AM
    3 Attachment(s)
    • 3
    • 77
    HansDouwe
    04-15-2024, 09:13 AM Go to last post

  3. [SOLVED] Sum Every Nth column Starting From Column 1

    Started by blackburnsexcel‎, 04-15-2024 08:37 AM
    • 6
    • 95
    AliGW
    04-15-2024, 08:56 AM Go to last post

  4. [SOLVED] Accumulative Addition Formula

    Started by omlette_boy‎, 04-15-2024 04:39 AM
    1 Attachment(s)
    • 13
    • 125
    windknife
    04-15-2024, 06:21 AM Go to last post

  5. [SOLVED] Index Match 2 Criteria

    Started by TimLevs‎, 04-15-2024 05:43 AM
    2 Attachment(s)
    • 5
    • 76
    Pete_UK
    04-15-2024, 06:06 AM Go to last post

  6. Moved: Conditional Sum through many sheets

    Started by SledgeTitan‎, 04-12-2024 06:50 AM
    •  
    •  

  7. [SOLVED] Help with formula

    Started by dandi10‎, 04-15-2024 05:14 AM
    excel formula 2 Attachment(s)
    • 3
    • 69
    etaf
    04-15-2024, 05:36 AM Go to last post

  8. Averaging Time Duration

    Started by raemaurer21‎, 04-10-2024 06:58 PM
    1 Attachment(s)
    • 13
    • 157
    Pete_UK
    04-15-2024, 04:39 AM Go to last post

  9. [SOLVED] Need assistance with formatting output to 2 decimals

    Started by skydivetom‎, 04-15-2024 03:23 AM
    • 3
    • 54
    AliGW
    04-15-2024, 04:02 AM Go to last post

  10. [SOLVED] Formula to find data in another sheet

    Started by Oeysbrei‎, 04-15-2024 02:35 AM
    2 Attachment(s)
    • 7
    • 89
    AliGW
    04-15-2024, 03:56 AM Go to last post

  11. [SOLVED] Finding partial match in databse with FILTER and XLOOPUP

    Started by aethsilgne‎, 04-14-2024 12:06 PM
    countif, databse, filter, partial, xlookup 9 Attachment(s)
    • 19
    • 224
    AliGW
    04-15-2024, 03:39 AM Go to last post

  12. Average total cost on a tiered pricing table

    Started by Littleowl‎, 04-14-2024 07:38 AM
    3 Attachment(s)
    • 3
    • 135
    kvsrinivasamurthy
    04-15-2024, 02:22 AM Go to last post

  13. Using Sumproduct to Count Dates Ignoring Blanks

    Started by CamBoss125‎, 04-11-2024 01:03 AM
    2 Attachment(s)
    • 7
    • 154
    bebo021999
    04-14-2024, 10:31 PM Go to last post

  14. Same formula for different workbook

    Started by craig37862‎, 04-12-2024 03:26 PM
    2 Attachment(s)
    • 3
    • 103
    JeteMc
    04-14-2024, 09:43 PM Go to last post

  15. XIRR Formula error

    Started by bmahfouz‎, 04-11-2024 12:43 PM
    1 Attachment(s)
    • 7
    • 178
    MrShorty
    04-14-2024, 09:30 PM Go to last post

  16. Formula to find wich raw has cells with matching criteria

    Started by ZuluNation‎, 04-14-2024 12:53 PM
    • 3
    • 93
    Gregb11
    04-14-2024, 09:19 PM Go to last post

  17. #NUM error in XIRR formula

    Started by wmjenner‎, 04-12-2024 07:53 PM
    2 Attachment(s)
    • 5
    • 119
    MrShorty
    04-14-2024, 02:28 PM Go to last post

  18. Assign Serial Numbers to each product code

    Started by EdliraAlbania‎, 04-12-2024 03:56 AM
    4 Attachment(s)
    • 6
    • 159
    Glenn Kennedy
    04-14-2024, 01:50 PM Go to last post

  19. [SOLVED] Trying to Number Rows that Start with a Specific Word or Phrase

    Started by Modify_inc‎, 04-14-2024 12:54 PM
    2 Attachment(s)
    • 13
    • 87
    etaf
    04-14-2024, 01:49 PM Go to last post

  20. formula to make dropdown list change upon selections

    Started by pmsherry‎, 04-14-2024 04:43 AM
    1 Attachment(s)
    • 1
    • 73
    Estevaoba
    04-14-2024, 01:10 PM Go to last post

  21. [SOLVED] Adding year to date data based on selected month

    Started by Touta75‎, 04-12-2024 04:59 PM
    3 Attachment(s)
    • 8
    • 100
    AliGW
    04-14-2024, 01:09 PM Go to last post

  22. [SOLVED] making a login page

    Started by Bailymaus‎, 04-11-2024 10:27 AM
    3 Attachment(s)
    • 5
    • 145
    ORoos
    04-14-2024, 11:21 AM Go to last post

  23. [SOLVED] Extract Two Highest Values From a Range, Skipping Blank Cells

    Started by jyurek‎, 04-13-2024 09:40 PM
    max values, skip blanks array 2 Attachment(s)
    • 7
    • 153
    AliGW
    04-14-2024, 10:36 AM Go to last post

  24. Remove all text Xcept some

    Started by DesertDweller9‎, 04-13-2024 01:44 PM
    • 10
    • 130
    windknife
    04-14-2024, 09:22 AM Go to last post

  25. [SOLVED] Index and Matching

    Started by dianaCatz‎, 04-13-2024 05:53 PM
    2 Attachment(s)
    • 5
    • 101
    Glenn Kennedy
    04-14-2024, 09:10 AM Go to last post

  26. Vlookup and indirect and match formula

    Started by dianaCatz‎, 04-14-2024 07:15 AM
    1 Attachment(s)
    • 1
    • 70
    JohnTopley
    04-14-2024, 08:23 AM Go to last post

  27. [SOLVED] Give a distinct sequence number for every data type in Col A and Col B

    Started by Ravana‎, 04-14-2024 03:01 AM
    3 Attachment(s)
    • 14
    • 131
    MohamedGadAllah
    04-14-2024, 08:14 AM Go to last post

  28. Conditional Formatting: Don't format blank cells

    Started by Waseem0888‎, 04-14-2024 06:13 AM
    2 Attachment(s)
    • 1
    • 72
    6StringJazzer
    04-14-2024, 07:35 AM Go to last post

  29. How to calculate the day?

    Started by lalaarif1‎, 04-13-2024 09:13 AM
    1 Attachment(s)
    • 3
    • 121
    JohnTopley
    04-14-2024, 05:34 AM Go to last post

  30. Post Use only 1 formula to populate the information in various columns which are

    Started by noaman79‎, 04-11-2024 10:29 AM
    excel column 2 Attachment(s)
    • 4
    • 165
    AliGW
    04-14-2024, 02:37 AM Go to last post

  31. Count cells containing keywords with multiple criteria

    Started by Kailef‎, 04-13-2024 10:36 PM
    countifs, formula, search, sumproduct 3 Attachment(s)
    • 7
    • 122
    CARACALLA
    04-14-2024, 02:31 AM Go to last post

  32. Angry Progress Bar Based Upon Hours + Calculate Partial and Full Day Hours

    Started by JTB05‎, 03-12-2024 09:49 AM
    progress bar, work hours 1 Attachment(s)
    • 1
    • 94
    MohamedGadAllah
    04-14-2024, 02:23 AM Go to last post

  33. Hyperlinks do not work with either VLOOKUP or INDEX MATCH

    Started by Sorrento‎, 04-11-2024 10:44 AM
    hyperlink
    • 1
    • 107
    AliGW
    04-14-2024, 01:10 AM Go to last post

  34. calculating CAGR from two inputs; cumulative returns and years

    Started by flizzo‎, 04-11-2024 08:02 PM
    • 5
    • 142
    MohamedGadAllah
    04-14-2024, 12:58 AM Go to last post

  35. Calculating how long a pension will last

    Started by Grouty‎, 04-12-2024 10:08 PM
    3 Attachment(s)
    • 9
    • 160
    Sam Capricci
    04-13-2024, 05:55 PM Go to last post

  36. [SOLVED] Populating rows with values based on another column

    Started by MuhammadZiaUrRehman‎, 03-29-2024 12:49 AM
    5 Attachment(s)
    • 11
    • 244
    JeteMc
    04-13-2024, 12:42 PM Go to last post

  37. [SOLVED] How to use MATCH formula for various conditions?

    Started by rizwanulhasan‎, 04-13-2024 06:57 AM
    match 3 Attachment(s)
    • 13
    • 113
    JohnTopley
    04-13-2024, 11:10 AM Go to last post

  38. [SOLVED] Need formula that extracts every third value in COL B based on value (1, 2, 3) in COL A

    Started by skydivetom‎, 04-13-2024 05:13 AM
    2 Attachment(s)
    • 12
    • 138
    TMS
    04-13-2024, 10:39 AM Go to last post

  39. [SOLVED] Index and Match (lookup with multiple criteria)

    Started by chri1977‎, 04-12-2024 07:06 AM
    1 Attachment(s)
    • 5
    • 116
    chri1977
    04-13-2024, 05:15 AM Go to last post

  40. Angry [SOLVED] Condtionally check two columns and return results

    Started by bob112233‎, 04-12-2024 04:30 PM
    match, power query 1 Attachment(s)
    • 4
    • 93
    AliGW
    04-13-2024, 03:33 AM Go to last post

  41. Lookup Multiple values in a single cell and return corresponding value in another sheet

    Started by yashballari‎, 04-12-2024 07:04 AM
    multiple, single cell, values 1 Attachment(s)
    • 2
    • 104
    AliGW
    04-13-2024, 03:32 AM Go to last post

  42. Question Subtract one value from multiple others

    Started by misia_klu‎, 04-10-2024 06:48 AM
    automate, equation, formula assistance, subtracting cells 3 Attachment(s)
    • 6
    • 156
    kvsrinivasamurthy
    04-13-2024, 02:08 AM Go to last post

  43. [SOLVED] How to get a specific result using IF formula based on multiple conditions?

    Started by rizwanulhasan‎, 12-07-2023 10:50 PM
    13 Attachment(s)
    • 67
    • 1,063
    rizwanulhasan
    04-13-2024, 01:15 AM Go to last post

  44. Lookup/Find/Search formula to find player(s) in a table with multiple rows and columns

    Started by Giovi‎, 04-12-2024 06:40 PM
    3 Attachment(s)
    • 8
    • 174
    wk9128
    04-13-2024, 12:13 AM Go to last post

  45. [SOLVED] Total count every second column.

    Started by I need excel help‎, 04-11-2024 04:20 PM
    1 Attachment(s)
    • 6
    • 123
    Estevaoba
    04-12-2024, 08:38 PM Go to last post

  46. [SOLVED] IF Formula - can you someone pls help a rookie out with this formula?

    Started by zjadh123‎, 04-12-2024 11:12 AM
    • 3
    • 107
    wk9128
    04-12-2024, 08:07 PM Go to last post

  47. [SOLVED] WEEKNUM, IFERROR, and IF FORMULA HELP!

    Started by excelprk92‎, 04-12-2024 01:30 AM
    2 Attachment(s)
    • 5
    • 98
    excelprk92
    04-12-2024, 04:00 PM Go to last post

  48. Smile Help with Advanced Averaging

    Started by gradyc‎, 04-12-2024 12:22 PM
    averaging 1 Attachment(s)
    • 4
    • 74
    TMS
    04-12-2024, 03:25 PM Go to last post

  49. [SOLVED] INDEX, INDIRECT, MATCH query

    Started by Beats.Nigel‎, 04-11-2024 11:23 AM
    1 Attachment(s)
    • 9
    • 155
    AliGW
    04-12-2024, 01:20 PM Go to last post

  50. [SOLVED] a way to not have to reapply label filters in pivot table when data is added

    Started by scorpain‎, 04-12-2024 11:09 AM
    • 1
    • 74
    scorpain
    04-12-2024, 12:38 PM Go to last post
+ Post New Thread
Page 6 of 5614 FirstFirst ... 6 ...

Forum Information and Options

Users Browsing this Forum

There are currently 47 users browsing this forum. (5 members & 42 guests)

  1. boynejs,
  2. HansDouwe,
  3. JN831,
  4. tjensen91

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