+ Post New Thread
Page 3 of 5610 FirstFirst 3 ...
Threads 101 to 150 of 280487

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

  1. [SOLVED] Adding/Merging a formula with an existing formula to capture 2 conditions

    Started by Mike Geraghty‎, 04-08-2024 09:40 PM
    4 Attachment(s)
    • 9
    • 115
    AliGW
    04-12-2024, 01:08 AM Go to last post

  2. One value in multi cell to return multi all instances Help!

    Started by tingler0‎, 04-09-2024 09:15 AM
    3 Attachment(s)
    • 8
    • 118
    Gregb11
    04-11-2024, 09:30 PM Go to last post

  3. [SOLVED] Find a centile for the nearest array value for a specific age

    Started by tays01s‎, 04-04-2024 02:27 PM
    3 Attachment(s)
    • 7
    • 250
    JeteMc
    04-11-2024, 04:17 PM Go to last post

  4. Question Calculate the sum based on the status of a certain cell

    Started by mboosta‎, 04-11-2024 08:18 AM
    1 Attachment(s)
    • 4
    • 105
    6StringJazzer
    04-11-2024, 02:14 PM Go to last post

  5. Advanced Filter

    Started by jlo33‎, 04-11-2024 11:31 AM
    1 Attachment(s)
    • 4
    • 87
    jlo33
    04-11-2024, 01:13 PM Go to last post

  6. Lightbulb [SOLVED] Formula to scan and identify 4 unique criteria simultaneously

    Started by Brent2024‎, 04-08-2024 11:51 AM
    1 Attachment(s)
    • 8
    • 159
    JeteMc
    04-11-2024, 12:10 PM Go to last post

  7. [SOLVED] Formula to calculate against 2 columns to produce a figure

    Started by MattExcelLearner‎, 04-11-2024 09:42 AM
    2 Attachment(s)
    • 3
    • 62
    Glenn Kennedy
    04-11-2024, 10:19 AM Go to last post

  8. Alphanumeric sorting (4 elements) of 77,000+ lines! SQL option too.

    Started by potofteatohavein‎, 04-10-2024 05:31 AM
    alphanumeric sort, forumla help, sorting advanced, sql data 3 Attachment(s)
    • 13
    • 157
    kvsrinivasamurthy
    04-11-2024, 10:10 AM Go to last post

  9. Help with line graph

    Started by stryped‎, 04-10-2024 03:20 PM
    4 Attachment(s)
    • 7
    • 84
    Glenn Kennedy
    04-11-2024, 09:21 AM Go to last post

  10. Regarding COUNT Specific String

    Started by sakibnaz‎, 04-10-2024 05:50 PM
    countif 2 Attachment(s)
    • 4
    • 114
    Glenn Kennedy
    04-11-2024, 09:03 AM Go to last post

  11. [SOLVED] Minutes Calculation

    Started by mvcp007‎, 04-11-2024 12:10 AM
    2 Attachment(s)
    • 4
    • 112
    mvcp007
    04-11-2024, 08:14 AM Go to last post

  12. [SOLVED] Conditional formatting - different formula based on cell content

    Started by eawyne‎, 04-03-2024 05:52 AM
    5 Attachment(s)
    • 9
    • 152
    eawyne
    04-11-2024, 07:49 AM Go to last post

  13. Formula stop a calculation running once it has reached a defined criteria

    Started by Coopereto‎, 04-11-2024 07:19 AM
    limiting a calculation 2 Attachment(s)
    • 1
    • 96
    avk
    04-11-2024, 07:44 AM Go to last post

  14. [SOLVED] excel omits adjacent cells fix

    Started by Magaletta‎, 04-11-2024 05:49 AM
    2 Attachment(s)
    • 13
    • 93
    AliGW
    04-11-2024, 06:37 AM Go to last post

  15. [SOLVED] Formula returns #Value! when + empty cell with formula with cell with value and formula

    Started by varbergt‎, 04-11-2024 03:55 AM
    add, addition, blank cell 3 Attachment(s)
    • 9
    • 120
    HansDouwe
    04-11-2024, 05:43 AM Go to last post

  16. [SOLVED] How to add values in cells of a table which has specific text in columns?

    Started by 0Cool‎, 04-11-2024 04:04 AM
    exce function 1 Attachment(s)
    • 5
    • 81
    AliGW
    04-11-2024, 05:05 AM Go to last post

  17. [SOLVED] How to calculate percentage to match old discount amount

    Started by avk‎, 04-10-2024 07:30 AM
    1 Attachment(s)
    • 2
    • 106
    josephteh
    04-11-2024, 04:14 AM Go to last post

  18. [SOLVED] Trying to get a dependent drop down list to work

    Started by pmsherry‎, 04-10-2024 08:26 AM
    dropdown list, formula 3 Attachment(s)
    • 10
    • 179
    MohamedGadAllah
    04-11-2024, 03:29 AM Go to last post

  19. [SOLVED] Generating a List of Values/Prefixes in a Particular Order

    Started by ExcelSport‎, 04-10-2024 01:26 AM
    4 Attachment(s)
    • 7
    • 127
    windknife
    04-10-2024, 10:58 PM Go to last post

  20. [SOLVED] Return A Column Header Based On Latest Instance Of Data In A Row

    Started by Mvaldesi‎, 04-10-2024 11:04 AM
    2 Attachment(s)
    • 3
    • 85
    windknife
    04-10-2024, 09:01 PM Go to last post

  21. [SOLVED] Round figure calculation

    Started by MUNNA2023‎, 04-10-2024 12:12 PM
    1 Attachment(s)
    • 3
    • 91
    josephteh
    04-10-2024, 07:51 PM Go to last post

  22. Question [SOLVED] Conditional Formatting Task Tracking

    Started by dave3881‎, 04-09-2024 09:15 PM
    conditional formatting 3 Attachment(s)
    • 6
    • 105
    dave3881
    04-10-2024, 07:50 PM Go to last post

  23. [SOLVED] Totalling column data based upon heading

    Started by Rroger_D‎, 04-10-2024 01:32 PM
    1 Attachment(s)
    • 10
    • 93
    Pete_UK
    04-10-2024, 06:53 PM Go to last post

  24. [SOLVED] Count with restrictions

    Started by tfmoraes‎, 04-10-2024 10:47 AM
    2 Attachment(s)
    • 5
    • 81
    Fluff13
    04-10-2024, 04:34 PM Go to last post

  25. [SOLVED] Formula to move items from one long list to separate rows - separated by commas

    Started by collinsc‎, 04-10-2024 05:47 AM
    1 Attachment(s)
    • 4
    • 90
    MohamedGadAllah
    04-10-2024, 03:22 PM Go to last post

  26. [SOLVED] Can I use EXACT() or ISNUMBER(SEARCH()) to look for more than one thing?

    Started by Fahim Haqyar‎, 04-10-2024 12:45 PM
    2 Attachment(s)
    • 5
    • 102
    etaf
    04-10-2024, 02:54 PM Go to last post

  27. Excel Online Formula Re-Write for Better Performance

    Started by sajidbagi‎, 04-10-2024 11:46 AM
    formulas, hlookup, links 1 Attachment(s)
    • 2
    • 90
    Fluff13
    04-10-2024, 02:19 PM Go to last post

  28. Add up per month

    Started by leovilla‎, 04-09-2024 05:09 PM
    2 Attachment(s)
    • 8
    • 90
    TMS
    04-10-2024, 01:47 PM Go to last post

  29. Populate a selected cell

    Started by varbergt‎, 04-10-2024 07:05 AM
    blank, if formula, populat data 3 Attachment(s)
    • 5
    • 138
    MohamedGadAllah
    04-10-2024, 12:08 PM Go to last post

  30. Find "text" in a range, and for each one, move over 1 to the right and get the number

    Started by mbenson111‎, 04-10-2024 11:22 AM
    1 Attachment(s)
    • 2
    • 64
    mbenson111
    04-10-2024, 12:00 PM Go to last post

  31. Conditional formatting to highlight stale data in dependent dropdowns

    Started by Rybruce‎, 04-09-2024 05:31 PM
    2 Attachment(s)
    • 3
    • 111
    Estevaoba
    04-10-2024, 11:46 AM Go to last post

  32. COUNTIF Multiple Criteria in Multiple Ranges

    Started by ntlknight‎, 04-08-2024 05:38 AM
    1 Attachment(s)
    • 2
    • 94
    JeteMc
    04-10-2024, 11:30 AM Go to last post

  33. rotation based on 3 months on & 15 Days Off ?

    Started by mamadou88‎, 02-03-2024 11:13 AM
    3 Attachment(s)
    • 9
    • 318
    AliGW
    04-10-2024, 11:07 AM Go to last post

  34. Question How to autofill a complex/linked cell system

    Started by HoorayForTom‎, 04-05-2024 12:19 PM
    autofill, linked cell, table data 5 Attachment(s)
    • 8
    • 167
    HoorayForTom
    04-10-2024, 11:06 AM Go to last post

  35. Confused with what fuction I should be using, and how to format it correctly.

    Started by mboosta‎, 04-10-2024 10:12 AM
    2 Attachment(s)
    • 4
    • 79
    josephteh
    04-10-2024, 10:42 AM Go to last post

  36. Trying to return a value based on another value from a table

    Started by JexxSwift‎, 04-10-2024 10:25 AM
    • 1
    • 52
    TMS
    04-10-2024, 10:29 AM Go to last post

  37. Lightbulb [SOLVED] Finance Tracker Help + Suggestions To Track Welcomed

    Started by Magaletta‎, 04-09-2024 02:29 AM
    4 Attachment(s)
    • 6
    • 95
    Magaletta
    04-10-2024, 09:42 AM Go to last post

  38. [SOLVED] Check format of cell value - various combinations

    Started by Noobian‎, 04-05-2024 12:01 AM
    1 Attachment(s)
    • 8
    • 178
    JeteMc
    04-10-2024, 09:20 AM Go to last post

  39. New invoice allocation register

    Started by emmagizer‎, 10-23-2023 10:22 PM
    9 Attachment(s)
    • 13
    • 365
    AliGW
    04-10-2024, 09:00 AM Go to last post

  40. Use MID to create text using THREE sections of text

    Started by DarrylBurge‎, 04-10-2024 05:53 AM
    1 Attachment(s)
    • 4
    • 97
    DarrylBurge
    04-10-2024, 07:31 AM Go to last post

  41. [SOLVED] automated sum formula depends on variable value

    Started by bojie700‎, 04-09-2024 09:15 PM
    2 Attachment(s)
    • 9
    • 148
    bojie700
    04-10-2024, 06:41 AM Go to last post

  42. [SOLVED] formula not working after 606 row

    Started by btparkhe1920‎, 04-10-2024 12:41 AM
    3 Attachment(s)
    • 14
    • 159
    windknife
    04-10-2024, 05:26 AM Go to last post

  43. Question [SOLVED] Conditional Concatenated List

    Started by aurelien_21‎, 04-10-2024 04:43 AM
    concatenate, list 2 Attachment(s)
    • 4
    • 57
    AliGW
    04-10-2024, 05:14 AM Go to last post

  44. [SOLVED] HELP im managed to delete formulas from worksheet and cant remember what they are.

    Started by tweacle‎, 04-10-2024 04:24 AM
    2 Attachment(s)
    • 6
    • 59
    AliGW
    04-10-2024, 05:06 AM Go to last post

  45. Talking [SOLVED] Conditional Format whole row based on match with data in another table.

    Started by potofteatohavein‎, 04-09-2024 10:30 AM
    conditional format, ifna, match 3 Attachment(s)
    • 2
    • 72
    potofteatohavein
    04-10-2024, 04:44 AM Go to last post

  46. Combining cells information together

    Started by rhino80‎, 04-10-2024 04:36 AM
    • 1
    • 57
    TMS
    04-10-2024, 04:40 AM Go to last post

  47. [SOLVED] Dynamic Look Up

    Started by ciderhead‎, 04-09-2024 11:59 AM
    1 Attachment(s)
    • 4
    • 93
    TMS
    04-10-2024, 04:27 AM Go to last post

  48. average if zero with offset()

    Started by td3201‎, 04-10-2024 12:25 AM
    1 Attachment(s)
    • 7
    • 387
    AliGW
    04-10-2024, 04:02 AM Go to last post

  49. Lightbulb [SOLVED] get value from upper & lower cell based on values

    Started by sanjuss2‎, 04-09-2024 09:42 AM
    2 Attachment(s)
    • 3
    • 113
    sanjuss2
    04-10-2024, 01:44 AM Go to last post

  50. Does sorting a range with the left-most column hidden also sort the left column?

    Started by Larry.LeBlanc@O‎, 04-10-2024 12:35 AM
    1 Attachment(s)
    • 2
    • 72
    TMS
    04-10-2024, 01:40 AM Go to last post
+ Post New Thread
Page 3 of 5610 FirstFirst 3 ...

Forum Information and Options

Users Browsing this Forum

There are currently 108 users browsing this forum. (5 members & 103 guests)

  1. alansidman,
  2. Bernie Deitrick,
  3. Glenn Kennedy,
  4. impala096,
  5. Newtonus_Prime

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