+ Post New Thread
Page 3 of 5614 FirstFirst 3 ...
Threads 101 to 150 of 280655

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

  1. [SOLVED] Combining two formulas into one cell

    Started by HajdukZD‎, 04-21-2024 09:34 PM
    1 Attachment(s)
    • 3
    • 73
    HajdukZD
    04-21-2024, 10:04 PM Go to last post

  2. How to calculate vacation hours based on pay period

    Started by lajohnson321‎, 04-20-2024 07:43 PM
    pto, pto accrual, pto days, pto formula, pto tracker 1 Attachment(s)
    • 3
    • 88
    Phuocam
    04-21-2024, 07:36 PM Go to last post

  3. [SOLVED] SMALL function that is variable

    Started by ussenterprise‎, 04-21-2024 04:54 PM
    • 6
    • 67
    TMS
    04-21-2024, 05:52 PM Go to last post

  4. Formula to check several dates on one Serial Number

    Started by JoaoPe‎, 04-21-2024 12:52 PM
    1 Attachment(s)
    • 4
    • 80
    Glenn Kennedy
    04-21-2024, 03:06 PM Go to last post

  5. [SOLVED] formula containing row to change when row inserted on source sheet

    Started by Howardc1001‎, 04-19-2024 10:55 PM
    3 Attachment(s)
    • 8
    • 122
    AliGW
    04-21-2024, 11:18 AM Go to last post

  6. [SOLVED] Debtor ageing with adjustment of credit balance on FIFO basis

    Started by vijayca‎, 04-21-2024 03:07 AM
    3 Attachment(s)
    • 4
    • 104
    vijayca
    04-21-2024, 10:40 AM Go to last post

  7. Clearing validation upon change

    Started by John Karman‎, 04-18-2024 01:26 PM
    clearing, validation 1 Attachment(s)
    • 1
    • 82
    davesexcel
    04-21-2024, 08:03 AM Go to last post

  8. [SOLVED] countifs multiple critera

    Started by Unclebenny‎, 04-21-2024 07:28 AM
    1 Attachment(s)
    • 3
    • 80
    windknife
    04-21-2024, 07:39 AM Go to last post

  9. [SOLVED] Use CF to highlight 2 columns based on weekday

    Started by mtouhig‎, 04-21-2024 02:31 AM
    3 Attachment(s)
    • 4
    • 99
    popipipo
    04-21-2024, 06:04 AM Go to last post

  10. [SOLVED] Remove blank rows

    Started by Kenny Yip‎, 04-20-2024 01:30 PM
    3 Attachment(s)
    • 8
    • 97
    Czeslaw
    04-21-2024, 01:46 AM Go to last post

  11. [SOLVED] Function/formula to lookup a column based on criteria and count

    Started by Jay325‎, 04-20-2024 11:35 PM
    1 Attachment(s)
    • 5
    • 86
    Jay325
    04-20-2024, 11:47 PM Go to last post

  12. [SOLVED] If cell contains specific text from one of multiple lists, return list header

    Started by Blue89‎, 04-20-2024 12:46 PM
    3 Attachment(s)
    • 2
    • 91
    ExceLogan
    04-20-2024, 05:11 PM Go to last post

  13. [SOLVED] Conflicting outcomes when accessing the same source cell

    Started by Marvo‎, 04-20-2024 12:53 PM
    1 Attachment(s)
    • 3
    • 52
    AliGW
    04-20-2024, 01:39 PM Go to last post

  14. [SOLVED] Return Sum of matching rows based on value in column, grouped by value in another

    Started by kristina‎, 04-20-2024 12:25 PM
    3 Attachment(s)
    • 12
    • 119
    AliGW
    04-20-2024, 01:38 PM Go to last post

  15. [SOLVED] Merging/Joining cell values into a new dynamic list

    Started by gdimmers‎, 04-20-2024 10:06 AM
    1 Attachment(s)
    • 4
    • 101
    AliGW
    04-20-2024, 12:31 PM Go to last post

  16. [SOLVED] Lookup a value in a matrix and give back the relavant headline

    Started by ThomasB61‎, 04-18-2024 02:59 PM
    formula, function, vba 3 Attachment(s)
    • 13
    • 139
    AliGW
    04-20-2024, 10:29 AM Go to last post

  17. [SOLVED] Search Row for Value and Return the Next Cell Value

    Started by MSchibs‎, 04-19-2024 09:37 AM
    1 Attachment(s)
    • 3
    • 106
    Jacc
    04-20-2024, 10:13 AM Go to last post

  18. [SOLVED] If duplicate, returns the recent value

    Started by dummy777‎, 04-19-2024 06:15 AM
    1 Attachment(s)
    • 6
    • 124
    dummy777
    04-20-2024, 09:49 AM Go to last post

  19. [SOLVED] Conditional Formatting Puzzle

    Started by Tricks420‎, 04-20-2024 08:04 AM
    1 Attachment(s)
    • 3
    • 67
    etaf
    04-20-2024, 09:39 AM Go to last post

  20. SUMPRODUCT and SUBTOTAL for STRUCTURED TABLE

    Started by EmmeEnne1979‎, 04-18-2024 01:20 PM
    2 Attachment(s)
    • 6
    • 149
    josephteh
    04-20-2024, 07:07 AM Go to last post

  21. [SOLVED] Formula for Table/Row Linking based on a Time Period

    Started by lucaskre8‎, 04-20-2024 05:01 AM
    3 Attachment(s)
    • 9
    • 118
    AliGW
    04-20-2024, 06:23 AM Go to last post

  22. [SOLVED] XLOOKUP or FILTER matrix result expected but #VALUE! returned

    Started by dxfoxd‎, 04-17-2024 12:59 PM
    7 Attachment(s)
    • 12
    • 211
    HansDouwe
    04-20-2024, 05:54 AM Go to last post

  23. Sum Function Returns Zero But Works Properly Inside a Formula?

    Started by JN831‎, 04-19-2024 09:44 PM
    3 Attachment(s)
    • 12
    • 184
    AliGW
    04-20-2024, 03:17 AM Go to last post

  24. [SOLVED] Remove decimal separators, points or commas

    Started by Boris Josipovic‎, 04-19-2024 08:06 PM
    1 Attachment(s)
    • 5
    • 99
    Boris Josipovic
    04-19-2024, 10:14 PM Go to last post

  25. Joining text with today's date

    Started by klabtv‎, 04-19-2024 07:19 PM
    • 2
    • 66
    Pete_UK
    04-19-2024, 07:37 PM Go to last post

  26. [SOLVED] Loan Running Balance Not Considering Interest

    Started by billy60‎, 04-18-2024 07:12 AM
    1 Attachment(s)
    • 3
    • 91
    billy60
    04-19-2024, 07:36 PM Go to last post

  27. Trying to Stop duplicates with Data Validation

    Started by JRP0707‎, 04-19-2024 02:39 PM
    4 Attachment(s)
    • 1
    • 61
    popipipo
    04-19-2024, 04:41 PM Go to last post

  28. Adding Spaces to Text to Hack Center Align

    Started by rjj920‎, 04-19-2024 09:52 AM
    center, format, len
    • 5
    • 70
    6StringJazzer
    04-19-2024, 03:09 PM Go to last post

  29. % of vacant units using 2 pivot tables - Dynamic

    Started by jeptik‎, 04-16-2024 11:41 AM
    2 Attachment(s)
    • 4
    • 68
    JeteMc
    04-19-2024, 03:01 PM Go to last post

  30. formula to check to see if the string in a cell has all charaters the same.

    Started by SoumyaGrace‎, 04-19-2024 02:51 PM
    • 4
    • 64
    Fluff13
    04-19-2024, 02:58 PM Go to last post

  31. [SOLVED] Help - Returning errors - want them to still add up or add as 0 if no data there

    Started by LeapyUK‎, 04-19-2024 08:44 AM
    • 6
    • 111
    TMS
    04-19-2024, 01:57 PM Go to last post

  32. Conditional Format for calendar with specific variables

    Started by mebert80‎, 04-18-2024 10:37 PM
    • 2
    • 64
    mebert80
    04-19-2024, 12:36 PM Go to last post

  33. IF Formula with Sum inside?

    Started by robonuk‎, 04-19-2024 12:01 PM
    • 1
    • 64
    HansDouwe
    04-19-2024, 12:18 PM Go to last post

  34. [SOLVED] Return value in 1 column based on last date match in another column help

    Started by lilsnoop‎, 04-19-2024 10:01 AM
    1 Attachment(s)
    • 5
    • 96
    windknife
    04-19-2024, 11:24 AM Go to last post

  35. Filter noch working as expected

    Started by Edward Hyde‎, 04-19-2024 10:58 AM
    1 Attachment(s)
    • 1
    • 51
    AliGW
    04-19-2024, 11:00 AM Go to last post

  36. [SOLVED] I have a column total that should be adjusted by (a cell total multiplied by another cell)

    Started by sanda_dennisp‎, 04-17-2024 06:07 PM
    1 Attachment(s)
    • 5
    • 103
    AliGW
    04-19-2024, 10:09 AM Go to last post

  37. Question [SOLVED] Summary Page that pulls information from different columns into a two primary columns

    Started by maplesyrup22‎, 04-16-2024 04:09 PM
    1 Attachment(s)
    • 5
    • 93
    wk9128
    04-19-2024, 10:06 AM Go to last post

  38. [SOLVED] Building a link using a formula.

    Started by Kalamari‎, 04-19-2024 08:38 AM
    • 3
    • 57
    AliGW
    04-19-2024, 09:23 AM Go to last post

  39. lookup a value and find the correct headline

    Started by ThomasB61‎, 04-19-2024 09:19 AM
    formula, functions, vba 1 Attachment(s)
    • 1
    • 50
    AliGW
    04-19-2024, 09:20 AM Go to last post

  40. Automatic fill up

    Started by pbruyere‎, 04-18-2024 02:16 PM
    2 Attachment(s)
    • 6
    • 101
    AliGW
    04-19-2024, 07:33 AM Go to last post

  41. Post sickness trigger spreadsheet

    Started by charlottech‎, 04-19-2024 06:19 AM
    • 1
    • 50
    AliGW
    04-19-2024, 06:56 AM Go to last post

  42. [SOLVED] Formula required for combine 10 unique digits from bottom to top

    Started by sbvaram‎, 04-19-2024 03:37 AM
    3 Attachment(s)
    • 13
    • 149
    AliGW
    04-19-2024, 05:54 AM Go to last post

  43. [SOLVED] Data Validation Help Need

    Started by Eric Tsang‎, 04-18-2024 11:07 AM
    3 Attachment(s)
    • 7
    • 76
    Eric Tsang
    04-19-2024, 04:55 AM Go to last post

  44. [SOLVED] Two way (Row & Column) lookup using Index Match

    Started by nagesh.tvsr‎, 04-15-2024 08:31 AM
    3 Attachment(s)
    • 10
    • 128
    etaf
    04-19-2024, 04:17 AM Go to last post

  45. Smile INDIRECT() result to change based on adjacent cell

    Started by lea092‎, 04-18-2024 10:24 PM
    if(, indirect(
    • 1
    • 71
    AliGW
    04-19-2024, 01:00 AM Go to last post

  46. Post [SOLVED] Weekly Call Logger

    Started by BeardedGrizzly~‎, 04-18-2024 12:27 PM
    1 Attachment(s)
    • 1
    • 56
    Logit
    04-18-2024, 06:49 PM Go to last post

  47. Angry [SOLVED] SUMIFS will not work correctly

    Started by debun‎, 04-18-2024 04:12 PM
    sum, sumif, sumsif 1 Attachment(s)
    • 5
    • 80
    TMS
    04-18-2024, 06:46 PM Go to last post

  48. [SOLVED] Vat calculation

    Started by sunboy‎, 04-18-2024 03:42 PM
    4 Attachment(s)
    • 11
    • 107
    TMS
    04-18-2024, 06:08 PM Go to last post

  49. [SOLVED] Generate a table with repeating values based on input parameter

    Started by HighGoblinInvestigat‎, 04-17-2024 02:31 PM
    date, fomula, table 2 Attachment(s)
    • 4
    • 121
    CK76
    04-18-2024, 04:19 PM Go to last post

  50. Select every nth cell in a column

    Started by eozkired‎, 04-18-2024 01:06 PM
    • 1
    • 51
    Bernie Deitrick
    04-18-2024, 01:13 PM Go to last post
+ Post New Thread
Page 3 of 5614 FirstFirst 3 ...

Forum Information and Options

Users Browsing this Forum

There are currently 60 users browsing this forum. (2 members & 58 guests)

  1. Gregb11

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