+ Post New Thread
Page 1 of 5612 1 ...
Threads 1 to 50 of 280553

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

  1. Listing data from one sheet to another while liming number of entries

    Started by bekwiet‎, Yesterday 11:32 PM
    5 Attachment(s)
    • 13
    • 63
    AliGW
    Today, 02:22 AM Go to last post

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

    Started by JN831‎, Yesterday 09:44 PM
    3 Attachment(s)
    • 7
    • 105
    AliGW
    Today, 01:52 AM Go to last post

  3. If duplicate, returns the recent value

    Started by dummy777‎, Yesterday 06:15 AM
    1 Attachment(s)
    • 5
    • 93
    AliGW
    Today, 12:58 AM Go to last post

  4. formula containing row to change when row inserted on source sheet

    Started by Howardc1001‎, Yesterday 10:55 PM
    • 1
    • 21
    AliGW
    Today, 12:47 AM Go to last post

  5. Help Extracting Specific Text From Inconsistent Text Strings

    Started by ZANDRY10085‎, 04-16-2024 07:56 PM
    2 Attachment(s)
    • 7
    • 112
    bebo021999
    Today, 12:36 AM Go to last post

  6. Continue to my last Thread discussion

    Started by Friend1‎, Yesterday 02:33 PM
    2 Attachment(s)
    • 2
    • 60
    Friend1
    Yesterday, 11:11 PM Go to last post

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

    Started by Boris Josipovic‎, Yesterday 08:06 PM
    1 Attachment(s)
    • 5
    • 72
    Boris Josipovic
    Yesterday, 10:14 PM Go to last post

  8. Joining text with today's date

    Started by klabtv‎, Yesterday 07:19 PM
    • 2
    • 32
    Pete_UK
    Yesterday, 07:37 PM Go to last post

  9. [SOLVED] Loan Running Balance Not Considering Interest

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

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

    Started by dxfoxd‎, 04-17-2024 12:59 PM
    6 Attachment(s)
    • 11
    • 173
    dxfoxd
    Yesterday, 05:30 PM Go to last post

  11. Trying to Stop duplicates with Data Validation

    Started by JRP0707‎, Yesterday 02:39 PM
    4 Attachment(s)
    • 1
    • 52
    popipipo
    Yesterday, 04:41 PM Go to last post

  12. Adding Spaces to Text to Hack Center Align

    Started by rjj920‎, Yesterday 09:52 AM
    center, format, len
    • 5
    • 62
    6StringJazzer
    Yesterday, 03:09 PM Go to last post

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

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

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

    Started by SoumyaGrace‎, Yesterday 02:51 PM
    • 4
    • 48
    Fluff13
    Yesterday, 02:58 PM Go to last post

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

    Started by LeapyUK‎, Yesterday 08:44 AM
    • 6
    • 94
    TMS
    Yesterday, 01:57 PM Go to last post

  16. Conditional Format for calendar with specific variables

    Started by mebert80‎, 04-18-2024 10:37 PM
    1 Attachment(s)
    • 2
    • 44
    mebert80
    Yesterday, 12:36 PM Go to last post

  17. IF Formula with Sum inside?

    Started by robonuk‎, Yesterday 12:01 PM
    • 1
    • 53
    HansDouwe
    Yesterday, 12:18 PM Go to last post

  18. 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)
    • 10
    • 100
    TMS
    Yesterday, 11:56 AM Go to last post

  19. [SOLVED] =INDEX dependent on value in cell

    Started by DarrylBurge‎, Yesterday 06:47 AM
    3 Attachment(s)
    • 5
    • 81
    6StringJazzer
    Yesterday, 11:51 AM Go to last post

  20. Lightbulb summation based on multiple criterias from different sheets with indirect function

    Started by sanjuss2‎, Yesterday 11:27 AM
    1 Attachment(s)
    • 0
    • 52
    sanjuss2
    Yesterday, 11:27 AM Go to last post

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

    Started by lilsnoop‎, Yesterday 10:01 AM
    1 Attachment(s)
    • 5
    • 76
    windknife
    Yesterday, 11:24 AM Go to last post

  22. lookup a value, but need two identifiers

    Started by Edward Hyde‎, 04-18-2024 10:25 AM
    4 Attachment(s)
    • 9
    • 101
    AliGW
    Yesterday, 11:06 AM Go to last post

  23. Filter noch working as expected

    Started by Edward Hyde‎, Yesterday 10:58 AM
    1 Attachment(s)
    • 1
    • 40
    AliGW
    Yesterday, 11:00 AM Go to last post

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

    Started by MSchibs‎, Yesterday 09:37 AM
    1 Attachment(s)
    • 2
    • 72
    Jacc
    Yesterday, 10:24 AM Go to last post

  25. [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
    • 86
    AliGW
    Yesterday, 10:09 AM Go to last post

  26. 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
    • 82
    wk9128
    Yesterday, 10:06 AM Go to last post

  27. Post IF Value(text) = duplicate then return Value(text) -1 -2 -3

    Started by RickVB‎, Yesterday 09:58 AM
    1 Attachment(s)
    • 2
    • 46
    JohnTopley
    Yesterday, 10:06 AM Go to last post

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

    Started by Kalamari‎, Yesterday 08:38 AM
    • 3
    • 46
    AliGW
    Yesterday, 09:23 AM Go to last post

  29. lookup a value and find the correct headline

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

  30. Automatic fill up

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

  31. Post sickness trigger spreadsheet

    Started by charlottech‎, Yesterday 06:19 AM
    • 1
    • 37
    AliGW
    Yesterday, 06:56 AM Go to last post

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

    Started by sbvaram‎, Yesterday 03:37 AM
    3 Attachment(s)
    • 13
    • 131
    AliGW
    Yesterday, 05:54 AM Go to last post

  33. [SOLVED] Data Validation Help Need

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

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

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

  35. Post [SOLVED] Not transferring Employee names to main sheets

    Started by Jordon R‎, 04-18-2024 08:04 PM
    3 Attachment(s)
    • 8
    • 64
    TMS
    Yesterday, 03:19 AM Go to last post

  36. SUMPRODUCT and SUBTOTAL for STRUCTURED TABLE

    Started by EmmeEnne1979‎, 04-18-2024 01:20 PM
    2 Attachment(s)
    • 5
    • 112
    AliGW
    Yesterday, 02:19 AM Go to last post

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

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

  38. Match two criteria in two columns

    Started by alo2279‎, 04-18-2024 09:34 PM
    3 Attachment(s)
    • 2
    • 64
    windknife
    04-18-2024, 10:10 PM Go to last post

  39. Post [SOLVED] Weekly Call Logger

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

  40. Angry [SOLVED] SUMIFS will not work correctly

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

  41. [SOLVED] Vat calculation

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

  42. [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
    • 113
    CK76
    04-18-2024, 04:19 PM Go to last post

  43. Clearing validation upon change

    Started by John Karman‎, 04-18-2024 01:26 PM
    clearing, validation 1 Attachment(s)
    • 0
    • 55
    John Karman
    04-18-2024, 01:26 PM Go to last post

  44. Select every nth cell in a column

    Started by eozkired‎, 04-18-2024 01:06 PM
    • 1
    • 45
    Bernie Deitrick
    04-18-2024, 01:13 PM Go to last post

  45. Red face [SOLVED] Pull Values from 'data sheet' into 'check sheet' based on serial no

    Started by adz2‎, 04-18-2024 11:51 AM
    pull, results 2 Attachment(s)
    • 1
    • 37
    etaf
    04-18-2024, 12:00 PM Go to last post

  46. Index and match to find a column number

    Started by tays01s‎, 04-17-2024 04:11 PM
    index, matach 3 Attachment(s)
    • 2
    • 52
    tays01s
    04-18-2024, 11:53 AM Go to last post

  47. [SOLVED] Conditional formatting to highlights duplicate date from yesterdays date

    Started by dummy777‎, 04-18-2024 07:47 AM
    4 Attachment(s)
    • 11
    • 116
    HansDouwe
    04-18-2024, 11:18 AM Go to last post

  48. Is there a formula to join values but start over after blank rows?

    Started by Sandi770‎, 04-16-2024 01:33 PM
    4 Attachment(s)
    • 5
    • 74
    JeteMc
    04-18-2024, 09:36 AM Go to last post

  49. Post Countif - only up to where the required text changes?

    Started by jed76‎, 04-18-2024 03:47 AM
    countif, excel, function 1 Attachment(s)
    • 17
    • 173
    jed76
    04-18-2024, 07:49 AM Go to last post

  50. Question [SOLVED] Grouping data values in one column based on another column (picture included to explain)

    Started by ant665321‎, 04-17-2024 11:36 AM
    3 Attachment(s)
    • 6
    • 95
    ant665321
    04-18-2024, 07:09 AM Go to last post
+ Post New Thread
Page 1 of 5612 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 52 users browsing this forum. (3 members & 49 guests)

  1. bekwiet,
  2. Pepe Le Mokko,
  3. Phuocam

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