+ Post New Thread
Page 21 of 5611 FirstFirst ... 21 ...
Threads 1001 to 1050 of 280520

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

  1. Unique Transpose

    Started by pmw19800‎, 02-25-2024 09:14 AM
    2 Attachment(s)
    • 3
    • 173
    windknife
    02-26-2024, 05:04 AM Go to last post

  2. [SOLVED] Locate a number

    Started by jevicha2‎, 02-23-2024 10:14 PM
    4 Attachment(s)
    • 5
    • 245
    Sam Capricci
    02-25-2024, 11:11 PM Go to last post

  3. How to pull up all data from the same value of 1 column?

    Started by EXCELBENCH‎, 02-25-2024 09:25 PM
    3 Attachment(s)
    • 5
    • 152
    EXCELBENCH
    02-25-2024, 10:42 PM Go to last post

  4. Post Excel formula help

    Started by excelenthusiast9‎, 02-23-2024 02:14 PM
    data tracking, what if 1 Attachment(s)
    • 3
    • 189
    JeteMc
    02-25-2024, 10:34 PM Go to last post

  5. Index/Match on multiple results

    Started by miky1989‎, 05-30-2023 11:19 AM
    6 Attachment(s)
    • 14
    • 467
    alansidman
    02-25-2024, 08:19 PM Go to last post

  6. [SOLVED] How to write this formula

    Started by Jim Love‎, 02-22-2024 07:23 PM
    • 5
    • 208
    Jim Love
    02-25-2024, 06:50 PM Go to last post

  7. Finding Analog Range Data Mimicking Last Few Results

    Started by jdrenken7‎, 02-24-2024 04:20 PM
    4 Attachment(s)
    • 4
    • 182
    DJunqueira
    02-25-2024, 04:07 PM Go to last post

  8. problrm using index match formula

    Started by carrollm‎, 02-25-2024 02:45 PM
    index match formula 1 Attachment(s)
    • 2
    • 95
    BadlySpelledBuoy
    02-25-2024, 02:56 PM Go to last post

  9. Exclamation [SOLVED] Indexing Issue: Pull Historical Data from table & return last five instances?

    Started by 001kbx‎, 02-24-2024 12:34 PM
    4 Attachment(s)
    • 14
    • 261
    DJunqueira
    02-25-2024, 08:15 AM Go to last post

  10. Question a networkday formula that excludes holidays and multiple leave date entries by employee

    Started by gibsarum‎, 12-31-2023 04:55 AM
    16 Attachment(s)
    • 41
    • 670
    HansDouwe
    02-25-2024, 07:31 AM Go to last post

  11. [SOLVED] Rearranging Data Based on Delimiter

    Started by chullan88‎, 02-21-2024 03:57 PM
    4 Attachment(s)
    • 8
    • 247
    windknife
    02-25-2024, 07:23 AM Go to last post

  12. how to create formula if sheet changes name

    Started by eugz‎, 02-25-2024 12:26 AM
    • 3
    • 154
    FDibbins
    02-25-2024, 01:38 AM Go to last post

  13. Lightbulb Conditional Formatting Question

    Started by ajamesritt‎, 02-22-2024 02:36 PM
    conditional fomatting 1 Attachment(s)
    • 3
    • 159
    JeteMc
    02-24-2024, 08:14 PM Go to last post

  14. Question How can we bring Max. and Second Max. values to mixed table on different sheet ?

    Started by beu‎, 02-24-2024 06:39 AM
    5 Attachment(s)
    • 9
    • 345
    beu
    02-24-2024, 03:31 PM Go to last post

  15. [SOLVED] Sum Values based on specific end text word and year

    Started by deweyirl‎, 02-24-2024 02:11 PM
    1 Attachment(s)
    • 3
    • 129
    TMS
    02-24-2024, 03:05 PM Go to last post

  16. [SOLVED] Hise #Value! error

    Started by gotroots‎, 02-24-2024 12:57 PM
    • 5
    • 146
    Fluff13
    02-24-2024, 02:37 PM Go to last post

  17. Post Tools Book-out and Returned Summary Sheet for Stores

    Started by gerdusvanrooyen‎, 07-26-2022 02:28 AM
    8 Attachment(s)
    • 9
    • 382
    AliGW
    02-24-2024, 12:59 PM Go to last post

  18. Copy a cell with formulated value to another cell, but delete the formula

    Started by cyliyu‎, 02-24-2024 05:30 AM
    1 Attachment(s)
    • 3
    • 98
    TMS
    02-24-2024, 05:51 AM Go to last post

  19. How to move desired rows to a new worksheet

    Started by Martyha‎, 02-23-2024 01:46 PM
    2 Attachment(s)
    • 6
    • 161
    TMS
    02-24-2024, 04:20 AM Go to last post

  20. Date For First weekday of the week exclude PH and Weekends

    Started by vincenttys‎, 02-21-2024 05:38 AM
    5 Attachment(s)
    • 4
    • 219
    kvsrinivasamurthy
    02-24-2024, 12:36 AM Go to last post

  21. [SOLVED] Formula for Advanced Filter Criteria

    Started by LKERN‎, 02-23-2024 06:51 PM
    advanced filter formula 1 Attachment(s)
    • 8
    • 146
    TMS
    02-23-2024, 09:22 PM Go to last post

  22. [SOLVED] Calculating the Total Time Between Two Times

    Started by kingsolo‎, 02-23-2024 04:54 PM
    2 Attachment(s)
    • 5
    • 167
    TMS
    02-23-2024, 07:12 PM Go to last post

  23. Allocation of Sales Visits by Month

    Started by stephRuzzi‎, 02-23-2024 10:33 AM
    excel, formula, spre 2 Attachment(s)
    • 2
    • 146
    DJunqueira
    02-23-2024, 06:49 PM Go to last post

  24. Filtered formulas

    Started by aqus‎, 02-19-2024 10:13 AM
    4 Attachment(s)
    • 14
    • 263
    DJunqueira
    02-23-2024, 04:55 PM Go to last post

  25. [SOLVED] Formulas not working as intended - not sure why

    Started by kmclean.wesco‎, 02-21-2024 02:14 PM
    formula help, formula not working 7 Attachment(s)
    • 26
    • 323
    kmclean.wesco
    02-23-2024, 04:00 PM Go to last post

  26. [SOLVED] How to add minutes and seconds together

    Started by CaMeSuffit‎, 02-22-2024 11:01 PM
    2 Attachment(s)
    • 13
    • 281
    CaMeSuffit
    02-23-2024, 03:47 PM Go to last post

  27. Final cost

    Started by WildPatilla‎, 02-23-2024 02:04 PM
    1 Attachment(s)
    • 3
    • 116
    Pete_UK
    02-23-2024, 02:38 PM Go to last post

  28. Funky Date Lookup

    Started by jomili‎, 02-23-2024 01:10 PM
    1 Attachment(s)
    • 1
    • 103
    Pete_UK
    02-23-2024, 01:15 PM Go to last post

  29. Post need help with a cost report function

    Started by Brewser94‎, 02-23-2024 09:54 AM
    1 Attachment(s)
    • 1
    • 141
    6StringJazzer
    02-23-2024, 01:04 PM Go to last post

  30. [SOLVED] This should be easy - Making Team Rosters

    Started by oddcarout‎, 02-23-2024 12:38 PM
    1 Attachment(s)
    • 3
    • 115
    oddcarout
    02-23-2024, 01:03 PM Go to last post

  31. [SOLVED] Customer Ranking by Cost in Pivot Tables: Ascending Order

    Started by Excel 1_2_3‎, 02-19-2024 05:50 AM
    4 Attachment(s)
    • 7
    • 219
    JeteMc
    02-23-2024, 11:22 AM Go to last post

  32. [SOLVED] XMATCH to reterive right date depending on formula given

    Started by dharvey1978‎, 02-23-2024 03:22 AM
    2 Attachment(s)
    • 9
    • 158
    AliGW
    02-23-2024, 07:46 AM Go to last post

  33. Excel Formula to extra partial data based on a Delimiter

    Started by k2nike‎, 02-22-2024 03:07 PM
    formula, partial, partial cell content 2 Attachment(s)
    • 4
    • 115
    etaf
    02-23-2024, 04:50 AM Go to last post

  34. [SOLVED] Formula not copying in row when inserted through a table

    Started by rhayes23‎, 02-22-2024 08:43 PM
    • 4
    • 136
    TMS
    02-23-2024, 04:12 AM Go to last post

  35. [SOLVED] Update cell where criteria meet

    Started by JamesT1‎, 02-23-2024 02:47 AM
    3 Attachment(s)
    • 6
    • 136
    AliGW
    02-23-2024, 04:11 AM Go to last post

  36. [SOLVED] Automatically generate a sequence number in the form.

    Started by cyliyu‎, 02-23-2024 01:31 AM
    1 Attachment(s)
    • 3
    • 115
    windknife
    02-23-2024, 02:45 AM Go to last post

  37. How do I program this calendar to rotate the on call person?

    Started by hugh.ross‎, 02-22-2024 11:46 PM
    2 Attachment(s)
    • 1
    • 124
    HansDouwe
    02-23-2024, 01:51 AM Go to last post

  38. Countif over multiple worksheets

    Started by jlschae154‎, 02-22-2024 01:33 PM
    1 Attachment(s)
    • 2
    • 128
    wk9128
    02-23-2024, 12:24 AM Go to last post

  39. Counting value in a cell if a cell in the same row but a different column has a set value

    Started by JackJJr‎, 02-20-2024 12:42 PM
    1 Attachment(s)
    • 4
    • 168
    JeteMc
    02-22-2024, 09:33 PM Go to last post

  40. [SOLVED] Networkdays formula if no date

    Started by dschwichtenberg‎, 02-13-2024 02:33 AM
    networkdays & if 2 Attachment(s)
    • 5
    • 177
    DJunqueira
    02-22-2024, 07:43 PM Go to last post

  41. Help with word replacement...

    Started by Mojo77‎, 02-22-2024 06:43 PM
    1 Attachment(s)
    • 1
    • 94
    6StringJazzer
    02-22-2024, 07:12 PM Go to last post

  42. Early, On-Time, Late options

    Started by skyemclaurin‎, 02-22-2024 04:28 PM
    2 Attachment(s)
    • 2
    • 124
    skyemclaurin
    02-22-2024, 05:25 PM Go to last post

  43. IF Statement to include multiple items

    Started by araza123‎, 02-22-2024 04:28 PM
    1 Attachment(s)
    • 1
    • 90
    BadlySpelledBuoy
    02-22-2024, 04:42 PM Go to last post

  44. Formula to Find the last sales price for a particiular unit; and formula to find last Sal

    Started by Bal194‎, 02-22-2024 02:12 PM
    3 Attachment(s)
    • 4
    • 126
    alansidman
    02-22-2024, 04:08 PM Go to last post

  45. [SOLVED] If Or Statement

    Started by billy60‎, 02-22-2024 02:58 PM
    • 7
    • 142
    etaf
    02-22-2024, 03:58 PM Go to last post

  46. Ghost in the machine problem with INDIRECT

    Started by scaffdog845‎, 02-20-2024 02:06 PM
    • 6
    • 195
    scaffdog845
    02-22-2024, 03:53 PM Go to last post

  47. Filter on one worksheet and multiple

    Started by jlschae154‎, 02-22-2024 01:19 PM
    1 Attachment(s)
    • 5
    • 129
    DJunqueira
    02-22-2024, 03:48 PM Go to last post

  48. Average dates between a min and max with while sorting "names" and "years

    Started by Aronn Palmer‎, 02-22-2024 09:37 AM
    6 Attachment(s)
    • 7
    • 116
    DJunqueira
    02-22-2024, 03:47 PM Go to last post

  49. [SOLVED] Couple of Conditional Formatting questions

    Started by SirFency‎, 02-22-2024 01:10 PM
    • 4
    • 102
    Pete_UK
    02-22-2024, 02:24 PM Go to last post

  50. I need help for the formula

    Started by tongresman8‎, 02-21-2024 04:31 PM
    4 Attachment(s)
    • 8
    • 165
    TMS
    02-22-2024, 01:31 PM Go to last post
+ Post New Thread
Page 21 of 5611 FirstFirst ... 21 ...

Forum Information and Options

Users Browsing this Forum

There are currently 102 users browsing this forum. (5 members & 97 guests)

  1. BeardedGrizzly~,
  2. billy60,
  3. Brian Brown,
  4. finallymint,
  5. nastro

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