+ Post New Thread
Page 2 of 5614 FirstFirst 2 ...
Threads 51 to 100 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. using vlookup to find different instances

    Started by jacc14‎, 04-21-2024 03:40 PM
    vlookup 4 Attachment(s)
    • 11
    • 162
    wk9128
    04-23-2024, 07:07 PM Go to last post

  2. [SOLVED] Logical Formula

    Started by Han_05‎, 04-23-2024 09:56 AM
    1 Attachment(s)
    • 4
    • 107
    Han_05
    04-23-2024, 02:42 PM Go to last post

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

    Started by sanjuss2‎, 04-19-2024 11:27 AM
    2 Attachment(s)
    • 1
    • 84
    JeteMc
    04-23-2024, 01:59 PM Go to last post

  4. OFFSET formula for dynamic range

    Started by Stuepef‎, 04-23-2024 11:39 AM
    counta, dynamic range, dynamic range for row, offset formula 1 Attachment(s)
    • 1
    • 54
    Estevaoba
    04-23-2024, 01:46 PM Go to last post

  5. How to count a specific phrase in an array using sumproduct with criteria

    Started by Fuddy_Duddy‎, 04-23-2024 12:24 PM
    • 1
    • 38
    TMS
    04-23-2024, 12:31 PM Go to last post

  6. mathing / look up formula help

    Started by rhino80‎, 04-23-2024 04:13 AM
    3 Attachment(s)
    • 6
    • 90
    TMS
    04-23-2024, 12:27 PM Go to last post

  7. Question [SOLVED] Summing up Supplier amounts from the same column

    Started by Dazzastark‎, 04-22-2024 10:49 AM
    2 Attachment(s)
    • 7
    • 122
    alansidman
    04-23-2024, 11:59 AM Go to last post

  8. [SOLVED] Conditional Formatting to highlight one row based on *text* in other cells

    Started by SeoulGal‎, 04-23-2024 03:52 AM
    • 9
    • 82
    Pete_UK
    04-23-2024, 11:49 AM Go to last post

  9. [SOLVED] TOCOL function to show non-zero values only?

    Started by Efendi‎, 04-23-2024 07:54 AM
    filter, tocol 4 Attachment(s)
    • 8
    • 79
    Czeslaw
    04-23-2024, 10:02 AM Go to last post

  10. Force user to delete content of cell

    Started by KerahJoy‎, 04-23-2024 09:59 AM
    clear, data validation, new data
    • 0
    • 66
    KerahJoy
    04-23-2024, 09:59 AM Go to last post

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

    Started by bekwiet‎, 04-19-2024 11:32 PM
    6 Attachment(s)
    • 19
    • 158
    JeteMc
    04-23-2024, 09:07 AM Go to last post

  12. Question Returning a list of parts from reference date

    Started by miribilist123‎, 03-26-2024 12:57 PM
    multi tab, referencing data, vlookup 3 Attachment(s)
    • 4
    • 92
    AliGW
    04-23-2024, 08:36 AM Go to last post

  13. Data Validation based on another data validation

    Started by miribilist123‎, 04-23-2024 07:57 AM
    1 Attachment(s)
    • 3
    • 69
    AliGW
    04-23-2024, 08:33 AM 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)
    • 7
    • 210
    kvsrinivasamurthy
    04-23-2024, 07:54 AM Go to last post

  15. [SOLVED] Convert different rows to one column

    Started by geniusufo007‎, 04-23-2024 03:58 AM
    2 Attachment(s)
    • 10
    • 103
    Czeslaw
    04-23-2024, 07:49 AM Go to last post

  16. [SOLVED] Increment number based on Location 2

    Started by josephteh‎, 04-22-2024 10:52 AM
    2 Attachment(s)
    • 6
    • 100
    Fluff13
    04-23-2024, 06:31 AM Go to last post

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

    Started by DarrylBurge‎, 04-19-2024 06:47 AM
    3 Attachment(s)
    • 6
    • 107
    DarrylBurge
    04-23-2024, 05:56 AM Go to last post

  18. [SOLVED] Using excel professional plus 2021 for Microsoft 365 function

    Started by geniusufo007‎, 04-23-2024 03:32 AM
    1 Attachment(s)
    • 6
    • 64
    AliGW
    04-23-2024, 04:24 AM Go to last post

  19. Moved: Radar chart help (I tried)

    Started by MattExcelLearner‎, 04-23-2024 03:02 AM
    •  
    •  

  20. Single Value Arrays and DROP

    Started by Glenn Kennedy‎, 04-22-2024 01:05 PM
    3 Attachment(s)
    • 4
    • 89
    AliGW
    04-23-2024, 02:50 AM Go to last post

  21. [SOLVED] Drop down list hides used items

    Started by edriks‎, 04-22-2024 09:54 AM
    3 Attachment(s)
    • 6
    • 78
    AliGW
    04-23-2024, 02:28 AM Go to last post

  22. [SOLVED] Continue to my last Thread discussion

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

  23. Match two criteria in two columns

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

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

    Started by FT00‎, 04-22-2024 01:03 PM
    2 Attachment(s)
    • 2
    • 70
    FT00
    04-22-2024, 09:44 PM Go to last post

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

    Started by Excl3454‎, 04-22-2024 05:50 PM
    choice menu, formula, replace 2 Attachment(s)
    • 3
    • 84
    wk9128
    04-22-2024, 09:02 PM Go to last post

  26. 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
    • 81
    wk9128
    04-22-2024, 08:36 PM Go to last post

  27. [SOLVED] DATEDIF Being Inconsistent

    Started by Drexl27‎, 04-22-2024 05:13 PM
    2 Attachment(s)
    • 2
    • 62
    Drexl27
    04-22-2024, 06:48 PM Go to last post

  28. [SOLVED] Function to join cells text together

    Started by Jay325‎, 04-22-2024 06:22 PM
    1 Attachment(s)
    • 3
    • 49
    TMS
    04-22-2024, 06:44 PM Go to last post

  29. [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
    • 111
    TMS
    04-22-2024, 06:34 PM Go to last post

  30. [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
    • 98
    noboffinme
    04-22-2024, 05:33 PM Go to last post

  31. 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,433
    bearlythere
    04-22-2024, 05:03 PM Go to last post

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

    Started by glynhunt‎, 04-22-2024 02:41 PM
    • 1
    • 53
    6StringJazzer
    04-22-2024, 03:08 PM Go to last post

  33. Post excel formula not returns to right value

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

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

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

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

    Started by JN831‎, 04-22-2024 11:13 AM
    2 Attachment(s)
    • 5
    • 71
    Fluff13
    04-22-2024, 11:56 AM Go to last post

  36. [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
    • 89
    TMS
    04-22-2024, 11:02 AM Go to last post

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

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

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

    Started by GLHDS‎, 04-22-2024 07:43 AM
    1 Attachment(s)
    • 4
    • 78
    AliGW
    04-22-2024, 10:43 AM Go to last post

  39. [SOLVED] write how many consecutive consonants

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

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

    Started by redslash2000‎, 04-22-2024 08:37 AM
    2 Attachment(s)
    • 5
    • 65
    AliGW
    04-22-2024, 09:05 AM Go to last post

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

    Started by Lozfitzuk‎, 04-22-2024 07:21 AM
    formula to text, indirect 3 Attachment(s)
    • 8
    • 77
    AliGW
    04-22-2024, 08:15 AM Go to last post

  42. [SOLVED] Remove Space between alphabet

    Started by goodboy‎, 04-22-2024 06:18 AM
    1 Attachment(s)
    • 6
    • 77
    AliGW
    04-22-2024, 07:30 AM Go to last post

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

    Started by lucaskre8‎, 04-22-2024 05:26 AM
    3 Attachment(s)
    • 6
    • 72
    AliGW
    04-22-2024, 07:04 AM Go to last post

  44. Question Formula for preparing Rotating Roster

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

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

    Started by alan2260‎, 04-22-2024 05:51 AM
    2 Attachment(s)
    • 4
    • 54
    AliGW
    04-22-2024, 06:05 AM Go to last post

  46. [SOLVED] Conditional rules and change colour cells

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

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

    Started by thanub99‎, 04-22-2024 12:16 AM
    2 Attachment(s)
    • 4
    • 83
    AliGW
    04-22-2024, 03:45 AM Go to last post

  48. [SOLVED] Increment number based on Location

    Started by josephteh‎, 04-22-2024 12:10 AM
    4 Attachment(s)
    • 7
    • 109
    HansDouwe
    04-22-2024, 02:44 AM Go to last post

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

    Started by rooboyz‎, 04-22-2024 01:22 AM
    2 Attachment(s)
    • 8
    • 85
    wk9128
    04-22-2024, 02:02 AM Go to last post

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

    Started by Kenny Yip‎, 04-21-2024 01:44 PM
    2 Attachment(s)
    • 3
    • 81
    AliGW
    04-22-2024, 01:14 AM Go to last post
+ Post New Thread
Page 2 of 5614 FirstFirst 2 ...

Forum Information and Options

Users Browsing this Forum

There are currently 68 users browsing this forum. (2 members & 66 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