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

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

  1. Calculating a percentage based on rows above and below

    Started by ExcelNewbie92‎, Today 06:05 AM
    2 Attachment(s)
    • 12
    • 106
    ExcelNewbie92
    Today, 10:09 AM Go to last post

  2. Vlookup from a range of values

    Started by samyraj‎, Yesterday 06:58 AM
    2 Attachment(s)
    • 5
    • 52
    AliGW
    Today, 10:04 AM Go to last post

  3. [SOLVED] Conditionally formatting question with checkboxes.

    Started by Tricks420‎, 04-20-2024 10:55 AM
    11 Attachment(s)
    • 20
    • 166
    AliGW
    Today, 09:56 AM Go to last post

  4. [SOLVED] Averaging the last 4 weeks

    Started by Narbar_123‎, Yesterday 09:33 AM
    3 Attachment(s)
    • 5
    • 94
    Narbar_123
    Today, 09:35 AM Go to last post

  5. Find unique values in a column(which is identified by column number)

    Started by krishnapg‎, Today 05:08 AM
    excel function, formula
    • 8
    • 90
    kvsrinivasamurthy
    Today, 09:00 AM Go to last post

  6. using =sum formula ignoring spaces

    Started by Writingformulas‎, Today 07:44 AM
    1 Attachment(s)
    • 4
    • 59
    AliGW
    Today, 08:48 AM Go to last post

  7. return a value to another sheet and decrease the amount of stock on that product

    Started by kdolba‎, Yesterday 09:04 AM
    2 Attachment(s)
    • 1
    • 71
    Kaper
    Today, 05:42 AM Go to last post

  8. [SOLVED] Wildcard to exclude specific word from list when using SUMIFS

    Started by varbergt‎, Today 04:13 AM
    sumifs, wildcard 3 Attachment(s)
    • 4
    • 55
    AliGW
    Today, 05:04 AM Go to last post

  9. Post Changing template data

    Started by Jordon R‎, 04-23-2024 10:10 PM
    3 Attachment(s)
    • 11
    • 134
    AliGW
    Today, 01:44 AM Go to last post

  10. Singale line data

    Started by btparkhe1920‎, Today 12:05 AM
    1 Attachment(s)
    • 3
    • 55
    TMS
    Today, 01:20 AM Go to last post

  11. looking up a string value in a column of 'currency' datatype values

    Started by dv1651st‎, Yesterday 10:59 PM
    3 Attachment(s)
    • 2
    • 56
    AliGW
    Today, 12:52 AM Go to last post

  12. [SOLVED] Convert string to date format

    Started by dobracik‎, Yesterday 04:01 AM
    1 Attachment(s)
    • 8
    • 118
    Czeslaw
    Today, 12:12 AM Go to last post

  13. Power Query - Extract data from worksheet

    Started by Kenny Yip‎, 04-23-2024 04:46 AM
    3 Attachment(s)
    • 4
    • 99
    Kenny Yip
    Yesterday, 11:43 PM Go to last post

  14. total and average patient counts through admit/discharge dates

    Started by crazy8jacky‎, Yesterday 11:05 AM
    2 Attachment(s)
    • 3
    • 79
    Gregb11
    Yesterday, 11:19 PM Go to last post

  15. [SOLVED] By row/bycol question

    Started by FT00‎, Yesterday 01:36 PM
    1 Attachment(s)
    • 2
    • 77
    FT00
    Yesterday, 09:39 PM Go to last post

  16. AVERAGE/IF Formula issue

    Started by W2OAN‎, Yesterday 10:00 AM
    averageif, averageifs, averageifs mulitpul, formula, formulas 1 Attachment(s)
    • 3
    • 83
    wk9128
    Yesterday, 07:18 PM Go to last post

  17. Post [SOLVED] How can I add value based on two different variables?

    Started by D2S‎, 04-23-2024 11:23 PM
    2 Attachment(s)
    • 5
    • 105
    wk9128
    Yesterday, 06:54 PM Go to last post

  18. [SOLVED] Clean and Convert Text, Then Average

    Started by JN831‎, Yesterday 04:19 PM
    3 Attachment(s)
    • 5
    • 83
    Glenn Kennedy
    Yesterday, 05:05 PM Go to last post

  19. Angry Losing my mind trying to figure out a search

    Started by RHJR‎, Yesterday 11:30 AM
    • 3
    • 53
    RHJR
    Yesterday, 01:00 PM Go to last post

  20. [SOLVED] If cell = then return a list

    Started by b00110908‎, Yesterday 06:34 AM
    4 Attachment(s)
    • 23
    • 146
    AliGW
    Yesterday, 12:27 PM Go to last post

  21. why are my date functions not working

    Started by Osprey2‎, Yesterday 11:05 AM
    • 4
    • 56
    Fluff13
    Yesterday, 12:10 PM Go to last post

  22. [SOLVED] Comparing data in 2 sheets

    Started by Poppy12‎, Yesterday 05:05 AM
    2 Attachment(s)
    • 9
    • 100
    AliGW
    Yesterday, 10:03 AM Go to last post

  23. 1st place calcuations with points

    Started by Judy Hailey‎, Yesterday 08:09 AM
    • 1
    • 51
    Pete_UK
    Yesterday, 08:17 AM Go to last post

  24. Post [SOLVED] Formulae to copy data between sheets with only a certan value.

    Started by kingscorpp‎, Yesterday 06:44 AM
    3 Attachment(s)
    • 10
    • 78
    AliGW
    Yesterday, 07:33 AM Go to last post

  25. Populate sheet with specific data from a different sheet

    Started by Valexana‎, 04-23-2024 11:46 AM
    5 Attachment(s)
    • 3
    • 109
    kvsrinivasamurthy
    Yesterday, 07:19 AM Go to last post

  26. Data Grouping

    Started by Magalela‎, Yesterday 06:55 AM
    1 Attachment(s)
    • 1
    • 47
    AliGW
    Yesterday, 06:57 AM Go to last post

  27. Question [SOLVED] How to calculate the diameter of a sprial.

    Started by SjofaaSj‎, 04-23-2024 08:02 AM
    3 Attachment(s)
    • 10
    • 142
    AliGW
    Yesterday, 05:33 AM Go to last post

  28. [SOLVED] How to calculate best numbers 3 i a certain rank or order (european championship)

    Started by gittermaster‎, 05-14-2016 02:02 PM
    8 Attachment(s)
    • 17
    • 1,088
    AliGW
    Yesterday, 05:06 AM Go to last post

  29. [SOLVED] Filter Function issue

    Started by oneblondebrow‎, 04-23-2024 11:26 AM
    3 Attachment(s)
    • 12
    • 96
    AliGW
    Yesterday, 04:01 AM Go to last post

  30. Add (B) + (C) ; then add value to equal to = 19

    Started by 43Matt‎, 04-23-2024 07:46 PM
    • 6
    • 99
    AliGW
    Yesterday, 01:04 AM Go to last post

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

    Started by Jordon R‎, 04-18-2024 08:04 PM
    3 Attachment(s)
    • 9
    • 89
    Jordon R
    Yesterday, 12:03 AM Go to last post

  32. How do I count duplicates occurrences in a cell

    Started by boynejs‎, 04-23-2024 11:00 PM
    1 Attachment(s)
    • 1
    • 52
    Rick Rothstein
    04-23-2024, 11:11 PM Go to last post

  33. [SOLVED] IF Function to check if x date is before y date (not working)

    Started by Drexl27‎, 04-23-2024 08:01 PM
    1 Attachment(s)
    • 2
    • 56
    Drexl27
    04-23-2024, 10:12 PM Go to last post

  34. [SOLVED] Need Help Merging Formulas

    Started by Destyn‎, 04-22-2024 05:03 PM
    • 5
    • 100
    Gregb11
    04-23-2024, 09:43 PM Go to last post

  35. How to find the no. of text values in one column depending on criteria in another column?

    Started by Tabbii‎, 04-23-2024 03:55 PM
    3 Attachment(s)
    • 5
    • 79
    Estevaoba
    04-23-2024, 08:03 PM Go to last post

  36. Index and match to find a column number

    Started by tays01s‎, 04-17-2024 04:11 PM
    index, matach 3 Attachment(s)
    • 7
    • 151
    JeteMc
    04-23-2024, 07:15 PM Go to last post

  37. using vlookup to find different instances

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

  38. [SOLVED] Logical Formula

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

  39. 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
    • 83
    JeteMc
    04-23-2024, 01:59 PM Go to last post

  40. Complex Scheduling in Excel

    Started by evee‎, 04-23-2024 12:33 AM
    schedule generator, schedules, scheduling with excel 2 Attachment(s)
    • 5
    • 143
    Hydraulics
    04-23-2024, 01:55 PM Go to last post

  41. 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
    • 53
    Estevaoba
    04-23-2024, 01:46 PM Go to last post

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

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

  43. mathing / look up formula help

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

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

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

  45. Help Extracting Specific Text From Inconsistent Text Strings

    Started by ZANDRY10085‎, 04-16-2024 07:56 PM
    5 Attachment(s)
    • 10
    • 189
    ZANDRY10085
    04-23-2024, 11:57 AM Go to last post

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

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

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

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

  48. Force user to delete content of cell

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

  49. 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
    • 156
    JeteMc
    04-23-2024, 09:07 AM Go to last post

  50. 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
    • 90
    AliGW
    04-23-2024, 08:36 AM Go to last post
+ Post New Thread
Page 1 of 5613 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 111 users browsing this forum. (5 members & 106 guests)

  1. etaf,
  2. ExcelNewbie92,
  3. HansDouwe,
  4. Maryse Roy,
  5. samyraj

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