+ Post New Thread
Page 50 of 5613 FirstFirst ... 50 ...
Threads 2451 to 2500 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. [SOLVED] VStack with multiple criteria

    Started by Etax‎, 12-15-2023 05:03 AM
    • 6
    • 559
    Etax
    12-15-2023, 09:24 PM Go to last post

  2. [SOLVED] Changing Currency Symbol Only Excel MS Office 16

    Started by Cbutd‎, 12-15-2023 12:32 PM
    currency conversion, currency format 2 Attachment(s)
    • 3
    • 189
    6StringJazzer
    12-15-2023, 07:16 PM Go to last post

  3. [SOLVED] To show True or False

    Started by goodboy‎, 12-12-2023 03:09 PM
    1 Attachment(s)
    • 3
    • 172
    Fluff13
    12-15-2023, 04:47 PM Go to last post

  4. Dynamic Output Based on Dropdown Selection With Corresponding Range V2

    Started by Relic24‎, 12-10-2023 06:47 AM
    4 Attachment(s)
    • 8
    • 266
    JeteMc
    12-15-2023, 04:37 PM Go to last post

  5. Copy from One Sheet to Another Based on Cell Match

    Started by RossHB2003‎, 12-15-2023 03:44 PM
    2 Attachment(s)
    • 1
    • 165
    Sam Capricci
    12-15-2023, 03:54 PM Go to last post

  6. [SOLVED] Overtime Calculation for Hours, not Pay

    Started by jomili‎, 12-14-2023 01:15 PM
    • 7
    • 221
    jomili
    12-15-2023, 02:53 PM Go to last post

  7. Complicated lookup question

    Started by seh0872‎, 12-14-2023 08:25 PM
    2 Attachment(s)
    • 10
    • 252
    seh0872
    12-15-2023, 02:33 PM Go to last post

  8. Battery Charging/Discharging with Surplus

    Started by Haiderniaz93‎, 11-29-2022 12:30 AM
    3 Attachment(s)
    • 8
    • 340
    JeteMc
    12-15-2023, 02:25 PM Go to last post

  9. Help with formulas to make data same format

    Started by robster66‎, 10-23-2023 09:13 PM
    2 Attachment(s)
    • 14
    • 471
    JeteMc
    12-15-2023, 01:43 PM Go to last post

  10. [SOLVED] Cut/Paste causing problems in Formula

    Started by Catsonheat‎, 12-13-2023 01:11 PM
    • 5
    • 206
    TMS
    12-15-2023, 01:38 PM Go to last post

  11. Formula not working consistently

    Started by LisaGarlena‎, 12-14-2023 03:05 PM
    3 Attachment(s)
    • 12
    • 245
    LisaGarlena
    12-15-2023, 01:18 PM Go to last post

  12. Choose with array function

    Started by ramesh27‎, 12-14-2023 06:28 AM
    3 Attachment(s)
    • 7
    • 263
    Glenn Kennedy
    12-15-2023, 01:11 PM Go to last post

  13. [SOLVED] Searchable drop down list in multiple cells

    Started by Mitchell1970‎, 07-21-2021 04:45 AM
    more than one cell, searchable dropdown list 2 Attachment(s)
    • 4
    • 344
    matthewdaly
    12-15-2023, 12:58 PM Go to last post

  14. [SOLVED] Formula for Daily Deduction of customer account with Daily Limit

    Started by FT00‎, 12-15-2023 03:38 AM
    4 Attachment(s)
    • 13
    • 239
    AliGW
    12-15-2023, 12:31 PM Go to last post

  15. Data Validation require quarter decimal ending

    Started by jomili‎, 12-15-2023 11:15 AM
    1 Attachment(s)
    • 2
    • 142
    JohnTopley
    12-15-2023, 11:32 AM Go to last post

  16. [SOLVED] Excel formula to separate name in two columns

    Started by sunboy‎, 12-14-2023 10:12 PM
    5 Attachment(s)
    • 10
    • 301
    alansidman
    12-15-2023, 11:23 AM Go to last post

  17. [SOLVED] Remove repeated results from sheet (keeping one copy)

    Started by MagicMan‎, 12-15-2023 10:46 AM
    2 Attachment(s)
    • 4
    • 112
    AliGW
    12-15-2023, 11:04 AM Go to last post

  18. Count only new occurrences within specific dates

    Started by KerahJoy‎, 12-15-2023 12:53 AM
    count, criteria, dates, new entries 3 Attachment(s)
    • 3
    • 258
    HansDouwe
    12-15-2023, 09:59 AM Go to last post

  19. [SOLVED] Alternative to INDIRECT - many instances of INDIRECT are slowing the workbook down

    Started by Christopher135‎, 12-11-2023 06:42 PM
    3 Attachment(s)
    • 11
    • 276
    Greg M
    12-15-2023, 08:45 AM Go to last post

  20. [SOLVED] Autosum specific number of cells

    Started by DarrylBurge‎, 12-15-2023 06:51 AM
    • 3
    • 112
    rorya
    12-15-2023, 08:15 AM Go to last post

  21. [SOLVED] How do I get the item name out from the item descriptions

    Started by artner0112‎, 12-14-2023 09:34 PM
    5 Attachment(s)
    • 18
    • 360
    TMS
    12-15-2023, 07:16 AM Go to last post

  22. Variance to Previous (Like PivotTable but via Formula)

    Started by dluhut‎, 12-14-2023 02:45 PM
    2 Attachment(s)
    • 1
    • 161
    josephteh
    12-15-2023, 07:03 AM Go to last post

  23. Lightbulb Copy quantity for product from one table to another based on unique ID.

    Started by Noguluxo‎, 12-15-2023 05:40 AM
    2 Attachment(s)
    • 3
    • 155
    AliGW
    12-15-2023, 06:59 AM Go to last post

  24. Issue with calculating Business hours

    Started by amitmodi_mrt‎, 12-14-2023 09:49 AM
    1 Attachment(s)
    • 1
    • 142
    josephteh
    12-15-2023, 06:45 AM Go to last post

  25. Question [SOLVED] Sort columns in a Protected sheet with locked cells

    Started by emsexcel‎, 11-24-2023 07:37 PM
    1 Attachment(s)
    • 10
    • 320
    TMS
    12-14-2023, 09:54 PM Go to last post

  26. Lightbulb Sheet 2 data from sheet 1 entries

    Started by ajamesritt‎, 12-14-2023 03:32 PM
    1 Attachment(s)
    • 3
    • 119
    TMS
    12-14-2023, 04:35 PM Go to last post

  27. [SOLVED] Formula to generate A to Z if the Qty is entered

    Started by pnasir‎, 12-12-2023 01:17 PM
    3 Attachment(s)
    • 7
    • 204
    HansDouwe
    12-14-2023, 03:23 PM Go to last post

  28. [SOLVED] Separate and "Group" sequential and non-sequential numbers

    Started by dluhut‎, 12-13-2023 12:55 PM
    5 Attachment(s)
    • 6
    • 341
    HansDouwe
    12-14-2023, 03:22 PM Go to last post

  29. [SOLVED] Can't write this formula in Excel (=drop)

    Started by Tirrazo‎, 12-13-2023 01:58 PM
    3 Attachment(s)
    • 12
    • 218
    HansDouwe
    12-14-2023, 03:21 PM Go to last post

  30. [SOLVED] Match Dashboard Budget Formulas to Selected Month

    Started by billy60‎, 12-14-2023 01:01 PM
    3 Attachment(s)
    • 10
    • 195
    billy60
    12-14-2023, 03:00 PM Go to last post

  31. [SOLVED] How to sumif with dynamic/variable number of criteria ranges

    Started by chris01395‎, 12-14-2023 08:49 AM
    4 Attachment(s)
    • 5
    • 211
    windknife
    12-14-2023, 01:14 PM Go to last post

  32. Need help getting this formula to pull date from C2 and everything before

    Started by Newtonus_Prime‎, 12-14-2023 12:55 PM
    1 Attachment(s)
    • 2
    • 152
    Newtonus_Prime
    12-14-2023, 12:58 PM Go to last post

  33. [SOLVED] Weighted Average Rent Per Square Foot for Plaza If Lease Started After a Certain Date

    Started by megaman123‎, 12-11-2023 03:21 PM
    2 Attachment(s)
    • 4
    • 253
    megaman123
    12-14-2023, 12:56 PM Go to last post

  34. Help with formula

    Started by Karlski‎, 12-11-2023 11:03 AM
    2 Attachment(s)
    • 7
    • 250
    Karlski
    12-14-2023, 12:56 PM Go to last post

  35. Creating equation with some rules to follow.

    Started by Olymp‎, 12-10-2023 07:53 PM
    1 Attachment(s)
    • 3
    • 174
    JeteMc
    12-14-2023, 12:56 PM Go to last post

  36. Cool Multiple Keyword Search Against Dataset - Baseball Registration

    Started by RaiderRed‎, 12-13-2023 02:27 PM
    1 Attachment(s)
    • 1
    • 108
    Estevaoba
    12-14-2023, 12:23 PM Go to last post

  37. Vlookup from Excel worksheet not saving in Word document

    Started by RickMcD‎, 12-14-2023 10:27 AM
    excel, vlookup, word
    • 1
    • 136
    TMS
    12-14-2023, 11:37 AM Go to last post

  38. [SOLVED] Bonus points in a league table

    Started by bborzych‎, 12-13-2023 06:00 PM
    2 Attachment(s)
    • 15
    • 293
    AliGW
    12-14-2023, 11:35 AM Go to last post

  39. [SOLVED] More efficient method than INDIRECT+CELL to create a variable range for SUM?

    Started by ZanT‎, 12-13-2023 07:48 PM
    • 4
    • 202
    ZanT
    12-14-2023, 11:17 AM Go to last post

  40. Question Get.Workbook(1) + Other Files

    Started by Cormorin1‎, 12-14-2023 09:38 AM
    excel function
    • 4
    • 164
    Fluff13
    12-14-2023, 11:13 AM Go to last post

  41. Automation

    Started by Conchimc‎, 12-14-2023 08:53 AM
    1 Attachment(s)
    • 1
    • 99
    AliGW
    12-14-2023, 09:10 AM Go to last post

  42. [SOLVED] COUNTIFS across a column range

    Started by RunBikeRun‎, 12-14-2023 08:23 AM
    • 3
    • 89
    Fluff13
    12-14-2023, 08:38 AM Go to last post

  43. automatically fill data from sheet1 to sheet2 based on date in sheet 1

    Started by glent‎, 12-13-2023 06:24 AM
    1 Attachment(s)
    • 2
    • 149
    glent
    12-14-2023, 08:28 AM Go to last post

  44. [SOLVED] need to get next Monday or Friday date

    Started by manshyworld‎, 12-13-2023 09:27 PM
    excel & formula
    • 5
    • 189
    AliGW
    12-14-2023, 07:30 AM Go to last post

  45. [SOLVED] Difference Formulas Based On Month Selected

    Started by billy60‎, 12-14-2023 05:27 AM
    1 Attachment(s)
    • 2
    • 120
    billy60
    12-14-2023, 05:51 AM Go to last post

  46. Moved: Replicating Color Formatting along a column

    Started by hasan mougharbel‎, 12-14-2023 04:14 AM
    •  
    •  

  47. [SOLVED] Formula to return a value based on value of another cell

    Started by whitesmarine‎, 12-14-2023 02:46 AM
    • 4
    • 241
    AliGW
    12-14-2023, 03:26 AM Go to last post

  48. Tracking year on year reductions and filtering by year / company

    Started by Alex_PP‎, 12-13-2023 04:44 PM
    measurement, measurement series, metrics, reduction, year database 1 Attachment(s)
    • 1
    • 114
    AliGW
    12-14-2023, 02:30 AM Go to last post

  49. Help with this FIFO formula

    Started by rendykyh‎, 12-13-2023 11:30 PM
    1 Attachment(s)
    • 5
    • 185
    HansDouwe
    12-14-2023, 02:01 AM Go to last post

  50. [SOLVED] MAXIF function

    Started by Havreliuc‎, 12-13-2023 07:03 AM
    1 Attachment(s)
    • 2
    • 206
    Havreliuc
    12-14-2023, 01:43 AM Go to last post
+ Post New Thread
Page 50 of 5613 FirstFirst ... 50 ...

Forum Information and Options

Users Browsing this Forum

There are currently 107 users browsing this forum. (1 members & 106 guests)

  1. davsth

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