+ Post New Thread
Page 1 of 5621 1 ...
Threads 1 to 50 of 281001

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

  1. [SOLVED] Number of duplicate values on the same row.

    Started by Volker_H‎, Yesterday 05:48 PM
    1 Attachment(s)
    • 4
    • 70
    FlameRetired
    Today, 06:58 PM Go to last post

  2. Excel 2010 - Adapt formulas to find duplicate and unique values with alphanumeric data

    Started by Luisftv‎, Today 03:22 AM
    3 Attachment(s)
    • 10
    • 131
    Luisftv
    Today, 05:43 PM Go to last post

  3. Calculating Total Gym Weight Based on Bodyweight

    Started by earlyfreak‎, Yesterday 11:05 AM
    4 Attachment(s)
    • 9
    • 90
    earlyfreak
    Today, 04:59 PM Go to last post

  4. Schedule Formula that Indicates Off Days

    Started by tacnola‎, Today 11:16 AM
    2 Attachment(s)
    • 4
    • 71
    Bernie Deitrick
    Today, 03:15 PM Go to last post

  5. Matching Reporting Month, Forecast Title, Check Mark, with the Cost Title

    Started by garrett.grillo‎, Yesterday 05:58 PM
    1 Attachment(s)
    • 4
    • 69
    garrett.grillo
    Today, 02:12 PM Go to last post

  6. Question Unique (or maybe not) lookup & sum

    Started by slade8200‎, 05-03-2024 03:50 PM
    5 Attachment(s)
    • 21
    • 261
    Glenn Kennedy
    Today, 01:58 PM Go to last post

  7. max value within a time range

    Started by Writingformulas‎, 05-13-2024 03:45 PM
    3 Attachment(s)
    • 15
    • 179
    Writingformulas
    Today, 01:44 PM Go to last post

  8. Lightbulb How to get a summary of total expenses

    Started by Anuru‎, Yesterday 01:31 PM
    2 Attachment(s)
    • 5
    • 63
    alansidman
    Today, 01:14 PM Go to last post

  9. Make big numbers numbers usable

    Started by joeppiej‎, Today 12:17 PM
    2 Attachment(s)
    • 2
    • 44
    Glenn Kennedy
    Today, 12:54 PM Go to last post

  10. [SOLVED] SUMIF _Conditioned (% of performance)

    Started by ebrauns79‎, Yesterday 04:22 AM
    6 Attachment(s)
    • 15
    • 130
    ebrauns79
    Today, 12:33 PM Go to last post

  11. Question Generate list based on multiple criteria - one of which is to lookup within a table

    Started by pfusella‎, 05-13-2024 03:29 PM
    1 Attachment(s)
    • 2
    • 92
    pfusella
    Today, 12:16 PM Go to last post

  12. Vllook up or a similar function to look up a date range

    Started by samyraj‎, Today 09:31 AM
    1 Attachment(s)
    • 2
    • 35
    samyraj
    Today, 12:14 PM Go to last post

  13. Question HELP! Modelling a fee with a Cap and Collar, with a deferred element

    Started by Restructure Me‎, 05-10-2024 09:11 AM
    8 Attachment(s)
    • 13
    • 158
    Restructure Me
    Today, 12:10 PM Go to last post

  14. Need to compare 2021 data ONLY with users who responded in 2020 survey.

    Started by Ochimus‎, Today 11:16 AM
    1 Attachment(s)
    • 1
    • 36
    JohnTopley
    Today, 12:09 PM Go to last post

  15. formula to ignore blank cells

    Started by crompton1980‎, Yesterday 01:52 PM
    1 Attachment(s)
    • 5
    • 79
    TMS
    Today, 12:03 PM Go to last post

  16. Empty Row after every group of data

    Started by MubiJazz‎, Today 06:16 AM
    1 Attachment(s)
    • 2
    • 38
    AliGW
    Today, 11:55 AM Go to last post

  17. Question Formula to show saving up to a cut off point

    Started by Oliver3443‎, Today 09:42 AM
    1 Attachment(s)
    • 7
    • 44
    AliGW
    Today, 11:15 AM Go to last post

  18. [SOLVED] X & Y Axis choices results via a drop down menu

    Started by Roger50046‎, Today 09:56 AM
    1 Attachment(s)
    • 3
    • 32
    AliGW
    Today, 11:13 AM Go to last post

  19. Bottom up lookup to find first instance of one of 3 criteria

    Started by bfuk‎, Today 09:03 AM
    lookup, vlookup 2 Attachment(s)
    • 9
    • 87
    Fluff13
    Today, 10:48 AM Go to last post

  20. Team Comp - Help with a formula to show each teams points against the other teams points

    Started by Markiii3‎, Today 09:38 AM
    1 Attachment(s)
    • 1
    • 41
    AliGW
    Today, 10:08 AM Go to last post

  21. Distribute available quantity by rank to the max and remaining to the last rank

    Started by zain.ansari‎, Today 08:55 AM
    1 Attachment(s)
    • 2
    • 61
    zain.ansari
    Today, 09:32 AM Go to last post

  22. Moved: Pull data from sheet to new sheet based on multiple criteria from another sheet in excel

    Started by Eng. Sallam‎, Yesterday 04:26 AM
    •  
    •  

  23. [SOLVED] Work Time: difference between two dates with conditions

    Started by lordpvl‎, 05-10-2024 05:27 AM
    7 Attachment(s)
    • 14
    • 155
    kvsrinivasamurthy
    Today, 08:36 AM Go to last post

  24. Shift formula

    Started by Rushendra‎, Today 08:07 AM
    2 Attachment(s)
    • 1
    • 49
    sudbhavani
    Today, 08:33 AM Go to last post

  25. [SOLVED] Counting new record years correctly

    Started by stockman‎, 05-12-2024 12:34 PM
    3 Attachment(s)
    • 19
    • 195
    stockman
    Today, 07:06 AM Go to last post

  26. [SOLVED] lookup formula returning multiple rows

    Started by ukphoenix‎, Yesterday 02:27 PM
    2 Attachment(s)
    • 5
    • 86
    Fluff13
    Today, 06:42 AM Go to last post

  27. I need help with vacation time

    Started by dutratp‎, Today 06:31 AM
    1 Attachment(s)
    • 0
    • 36
    dutratp
    Today, 06:31 AM Go to last post

  28. Match 2 cells text strings to get the left behind

    Started by Shareez Saleem‎, Today 02:29 AM
    3 Attachment(s)
    • 3
    • 56
    windknife
    Today, 05:44 AM Go to last post

  29. Calculate Overtime

    Started by Mike Geraghty‎, Yesterday 10:43 PM
    2 Attachment(s)
    • 3
    • 66
    AliGW
    Today, 05:29 AM Go to last post

  30. updatable calendar

    Started by zacccc‎, Yesterday 10:00 PM
    calendar
    • 2
    • 59
    Pete_UK
    Today, 04:49 AM Go to last post

  31. [SOLVED] Name range

    Started by geniusufo007‎, Today 02:59 AM
    1 Attachment(s)
    • 3
    • 44
    TMS
    Today, 04:49 AM Go to last post

  32. [SOLVED] Conditional format -highlight a value if matches with a group data and set criteria

    Started by jaredli‎, Today 02:22 AM
    2 Attachment(s)
    • 7
    • 60
    AliGW
    Today, 04:35 AM Go to last post

  33. Extracting date/times

    Started by Stoneballs‎, 05-13-2024 09:04 AM
    1 Attachment(s)
    • 1
    • 85
    alansidman
    Today, 04:28 AM Go to last post

  34. How would I modify this formula to be a NOT instead of is in list?

    Started by ghurty‎, Yesterday 10:31 PM
    • 5
    • 61
    Glenn Kennedy
    Today, 03:13 AM Go to last post

  35. If cell matches copy different cell

    Started by jlo33‎, Yesterday 11:58 PM
    • 3
    • 54
    TMS
    Today, 02:36 AM Go to last post

  36. Automatically sort multiple rows of data into order based on a priority cell.

    Started by jcole2024‎, Yesterday 11:19 PM
    1 Attachment(s)
    • 1
    • 45
    AliGW
    Today, 02:07 AM Go to last post

  37. [SOLVED] Key Box Numbers for Lotto Game

    Started by JN831‎, Yesterday 03:37 AM
    4 Attachment(s)
    • 11
    • 172
    JN831
    Yesterday, 11:24 PM Go to last post

  38. Need a formula for Net Sales

    Started by sweetfriend9‎, 05-10-2024 01:56 PM
    3 Attachment(s)
    • 4
    • 119
    josephteh
    Yesterday, 10:09 PM Go to last post

  39. [SOLVED] SUMIFS Help

    Started by Destyn‎, Yesterday 07:17 PM
    • 3
    • 45
    TMS
    Yesterday, 07:32 PM Go to last post

  40. I need Index/Match or another formula to return all instanses of matches

    Started by Jamesera27‎, Yesterday 04:48 PM
    2 Attachment(s)
    • 1
    • 43
    FlameRetired
    Yesterday, 07:15 PM Go to last post

  41. How to filter a column based on a column in a different file

    Started by ghurty‎, Yesterday 11:56 AM
    2 Attachment(s)
    • 6
    • 55
    ghurty
    Yesterday, 04:44 PM Go to last post

  42. [SOLVED] Populating cell with different values based on 1-5 different cells having text

    Started by Rolaids24‎, Yesterday 12:58 PM
    1 Attachment(s)
    • 3
    • 45
    TMS
    Yesterday, 01:50 PM Go to last post

  43. Question Payroll Weekend Differential

    Started by kiwisoup‎, Yesterday 11:45 AM
    • 1
    • 40
    Bernie Deitrick
    Yesterday, 01:48 PM Go to last post

  44. Occurance Number

    Started by robonuk‎, Yesterday 11:54 AM
    2 Attachment(s)
    • 2
    • 43
    TMS
    Yesterday, 01:46 PM Go to last post

  45. [SOLVED] Indirect function within sumifs to sum column based on matching criteria

    Started by bentleyh‎, 05-13-2024 07:24 AM
    2 Attachment(s)
    • 5
    • 109
    Limor_OP
    Yesterday, 01:04 PM Go to last post

  46. [SOLVED] Need to add a space between text in formula

    Started by joshdog13‎, Yesterday 11:25 AM
    2 Attachment(s)
    • 5
    • 58
    Glenn Kennedy
    Yesterday, 11:53 AM Go to last post

  47. [SOLVED] From Dropdown list MATCH-across-Multiple-Sheets

    Started by vvishalb‎, 05-12-2024 12:32 AM
    2 Attachment(s)
    • 6
    • 131
    Glenn Kennedy
    Yesterday, 11:31 AM Go to last post

  48. [SOLVED] Multi-layer VLOOKUP return a blank instead of 0

    Started by Rolaids24‎, 05-13-2024 01:15 PM
    1 Attachment(s)
    • 3
    • 79
    CARACALLA
    Yesterday, 11:16 AM Go to last post

  49. [SOLVED] INDEX & MATCH totals not adding up

    Started by Roger50046‎, Yesterday 09:27 AM
    2 Attachment(s)
    • 5
    • 60
    Glenn Kennedy
    Yesterday, 10:48 AM Go to last post

  50. [SOLVED] VLOOKUP response not changing based on logical test

    Started by Rolaids24‎, Yesterday 09:46 AM
    1 Attachment(s)
    • 4
    • 56
    Rolaids24
    Yesterday, 10:23 AM Go to last post
+ Post New Thread
Page 1 of 5621 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 66 users browsing this forum. (4 members & 62 guests)

  1. Luisftv,
  2. pfusella,
  3. Volker_H

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