+ Post New Thread
Page 1 of 5613 1 ...
Threads 1 to 50 of 280602

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

  1. Moved: Radar chart help (I tried)

    Started by MattExcelLearner‎, Today 03:02 AM
    •  
    •  

  2. Single Value Arrays and DROP

    Started by Glenn Kennedy‎, Yesterday 01:05 PM
    3 Attachment(s)
    • 4
    • 79
    AliGW
    Today, 02:50 AM Go to last post

  3. [SOLVED] Increment number based on Location 2

    Started by josephteh‎, Yesterday 10:52 AM
    2 Attachment(s)
    • 5
    • 75
    wk9128
    Today, 02:47 AM Go to last post

  4. Complex Scheduling in Excel

    Started by evee‎, Today 12:33 AM
    schedule generator, schedules, scheduling with excel 1 Attachment(s)
    • 4
    • 82
    evee
    Today, 02:40 AM Go to last post

  5. [SOLVED] Drop down list hides used items

    Started by edriks‎, Yesterday 09:54 AM
    3 Attachment(s)
    • 6
    • 73
    AliGW
    Today, 02:28 AM Go to last post

  6. Need Help Merging Formulas

    Started by Destyn‎, Yesterday 05:03 PM
    • 3
    • 70
    Gregb11
    Yesterday, 10:54 PM Go to last post

  7. Continue to my last Thread discussion

    Started by Friend1‎, 04-19-2024 02:33 PM
    3 Attachment(s)
    • 5
    • 121
    windknife
    Yesterday, 09:47 PM Go to last post

  8. Match two criteria in two columns

    Started by alo2279‎, 04-18-2024 09:34 PM
    3 Attachment(s)
    • 4
    • 89
    windknife
    Yesterday, 09:46 PM Go to last post

  9. [SOLVED] To Only show result if 3 criteria is met.

    Started by FT00‎, Yesterday 01:03 PM
    2 Attachment(s)
    • 2
    • 53
    FT00
    Yesterday, 09:44 PM Go to last post

  10. Help Extracting Specific Text From Inconsistent Text Strings

    Started by ZANDRY10085‎, 04-16-2024 07:56 PM
    4 Attachment(s)
    • 9
    • 164
    bebo021999
    Yesterday, 09:42 PM Go to last post

  11. [SOLVED] part of formula from drop down option

    Started by Excl3454‎, Yesterday 05:50 PM
    choice menu, formula, replace 2 Attachment(s)
    • 3
    • 81
    wk9128
    Yesterday, 09:02 PM Go to last post

  12. Post [SOLVED] IF Value(text) = duplicate then return Value(text) -1 -2 -3

    Started by RickVB‎, 04-19-2024 09:58 AM
    1 Attachment(s)
    • 6
    • 79
    wk9128
    Yesterday, 08:36 PM Go to last post

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

    Started by bekwiet‎, 04-19-2024 11:32 PM
    6 Attachment(s)
    • 18
    • 131
    bekwiet
    Yesterday, 08:31 PM Go to last post

  14. [SOLVED] The problem of cumulative sum of merging units

    Started by metrostar‎, 04-21-2024 10:06 AM
    4 Attachment(s)
    • 6
    • 192
    wk9128
    Yesterday, 08:10 PM Go to last post

  15. [SOLVED] DATEDIF Being Inconsistent

    Started by Drexl27‎, Yesterday 05:13 PM
    2 Attachment(s)
    • 2
    • 51
    Drexl27
    Yesterday, 06:48 PM Go to last post

  16. [SOLVED] Function to join cells text together

    Started by Jay325‎, Yesterday 06:22 PM
    1 Attachment(s)
    • 3
    • 39
    TMS
    Yesterday, 06:44 PM Go to last post

  17. [SOLVED] Formula to insert text into a table looking at time/location

    Started by Jay325‎, 04-21-2024 06:08 PM
    4 Attachment(s)
    • 13
    • 98
    TMS
    Yesterday, 06:34 PM Go to last post

  18. [SOLVED] Enforce a Date Format 'yyyy-mm-dd' onto a Column in a .csv file.

    Started by noboffinme‎, 04-21-2024 09:08 PM
    • 6
    • 86
    noboffinme
    Yesterday, 05:33 PM Go to last post

  19. Red face Formula for if a value is above, below or within a range

    Started by elly_gallio‎, 05-30-2015 02:54 PM
    formula assistance
    • 5
    • 2,420
    bearlythere
    Yesterday, 05:03 PM Go to last post

  20. unauthorized changes - not by me- to linked S.S.

    Started by glynhunt‎, Yesterday 02:41 PM
    • 1
    • 52
    6StringJazzer
    Yesterday, 03:08 PM Go to last post

  21. Post excel formula not returns to right value

    Started by Zaid3010‎, 04-20-2024 11:43 PM
    1 Attachment(s)
    • 5
    • 96
    TMS
    Yesterday, 02:51 PM Go to last post

  22. Question Summing up Supplier amounts from the same column

    Started by Dazzastark‎, Yesterday 10:49 AM
    2 Attachment(s)
    • 5
    • 83
    alansidman
    Yesterday, 02:32 PM Go to last post

  23. [SOLVED] FALSE result from deeply nested IF formula

    Started by Apaka‎, 04-21-2024 04:40 PM
    3 Attachment(s)
    • 17
    • 129
    AliGW
    Yesterday, 12:17 PM Go to last post

  24. [SOLVED] Use XMATCH and XLOOKUP To Find Result In Dynamic Range

    Started by JN831‎, Yesterday 11:13 AM
    2 Attachment(s)
    • 5
    • 61
    Fluff13
    Yesterday, 11:56 AM Go to last post

  25. [SOLVED] trying to return a value using Xlookup and match from a price table

    Started by iks181‎, 04-21-2024 01:12 PM
    xlookup 1 Attachment(s)
    • 7
    • 82
    TMS
    Yesterday, 11:02 AM Go to last post

  26. [SOLVED] lookup a value, but need two identifiers

    Started by Edward Hyde‎, 04-18-2024 10:25 AM
    5 Attachment(s)
    • 18
    • 187
    TMS
    Yesterday, 10:49 AM Go to last post

  27. [SOLVED] Specific Subtraction based on two identical Cells

    Started by GLHDS‎, Yesterday 07:43 AM
    1 Attachment(s)
    • 4
    • 61
    AliGW
    Yesterday, 10:43 AM Go to last post

  28. Index and match to find a column number

    Started by tays01s‎, 04-17-2024 04:11 PM
    index, matach 3 Attachment(s)
    • 5
    • 109
    JeteMc
    Yesterday, 09:50 AM Go to last post

  29. [SOLVED] write how many consecutive consonants

    Started by makinmomb‎, 04-20-2024 09:09 AM
    3 Attachment(s)
    • 9
    • 140
    makinmomb
    Yesterday, 09:20 AM Go to last post

  30. Lookup to match with two criteria one of which is between two dates.

    Started by redslash2000‎, Yesterday 08:37 AM
    2 Attachment(s)
    • 5
    • 63
    AliGW
    Yesterday, 09:05 AM Go to last post

  31. [SOLVED] using vlookup to find different instances

    Started by jacc14‎, 04-21-2024 03:40 PM
    vlookup 2 Attachment(s)
    • 6
    • 98
    Pete_UK
    Yesterday, 08:47 AM Go to last post

  32. [SOLVED] Displaying the true text of Indirect formula

    Started by Lozfitzuk‎, Yesterday 07:21 AM
    formula to text, indirect 3 Attachment(s)
    • 8
    • 75
    AliGW
    Yesterday, 08:15 AM Go to last post

  33. Remove Space between alphabet

    Started by goodboy‎, Yesterday 06:18 AM
    1 Attachment(s)
    • 6
    • 70
    AliGW
    Yesterday, 07:30 AM Go to last post

  34. [SOLVED] Fomula for finding/inserting data from a prevous date

    Started by lucaskre8‎, Yesterday 05:26 AM
    3 Attachment(s)
    • 6
    • 68
    AliGW
    Yesterday, 07:04 AM Go to last post

  35. Question Formula for preparing Rotating Roster

    Started by madgilberta‎, 04-20-2024 12:44 PM
    1 Attachment(s)
    • 7
    • 128
    AliGW
    Yesterday, 06:25 AM Go to last post

  36. [SOLVED] Aggregate function to count instances based on criteria

    Started by alan2260‎, Yesterday 05:51 AM
    2 Attachment(s)
    • 4
    • 51
    AliGW
    Yesterday, 06:05 AM Go to last post

  37. [SOLVED] Conditional rules and change colour cells

    Started by kcfungus‎, 04-21-2024 09:00 PM
    2 Attachment(s)
    • 7
    • 96
    kcfungus
    Yesterday, 04:23 AM Go to last post

  38. How to apply brackets to selected cells using formulas?

    Started by thanub99‎, Yesterday 12:16 AM
    2 Attachment(s)
    • 4
    • 80
    AliGW
    Yesterday, 03:45 AM Go to last post

  39. [SOLVED] Increment number based on Location

    Started by josephteh‎, Yesterday 12:10 AM
    4 Attachment(s)
    • 7
    • 101
    HansDouwe
    Yesterday, 02:44 AM Go to last post

  40. [SOLVED] Looking up criteria and returning values between two dates

    Started by rooboyz‎, Yesterday 01:22 AM
    2 Attachment(s)
    • 8
    • 81
    wk9128
    Yesterday, 02:02 AM Go to last post

  41. [SOLVED] Extract data from another worksheet excluding rows without data

    Started by Kenny Yip‎, 04-21-2024 01:44 PM
    2 Attachment(s)
    • 3
    • 78
    AliGW
    Yesterday, 01:14 AM Go to last post

  42. [SOLVED] Combining two formulas into one cell

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

  43. 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
    • 83
    Phuocam
    04-21-2024, 07:36 PM Go to last post

  44. [SOLVED] SMALL function that is variable

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

  45. Formula to check several dates on one Serial Number

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

  46. [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
    • 114
    AliGW
    04-21-2024, 11:18 AM Go to last post

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

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

  48. Clearing validation upon change

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

  49. [SOLVED] countifs multiple critera

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

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

    Started by mtouhig‎, 04-21-2024 02:31 AM
    3 Attachment(s)
    • 4
    • 95
    popipipo
    04-21-2024, 06:04 AM Go to last post
+ Post New Thread
Page 1 of 5613 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 96 users browsing this forum. (6 members & 90 guests)

  1. a15995,
  2. evee,
  3. finallymint,
  4. MattExcelLearner,
  5. samchia,
  6. TTXY

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