+ Post New Thread
Page 51 of 5614 FirstFirst ... 51 ...
Threads 2501 to 2550 of 280674

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

  1. [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

  2. [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

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. [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
    • 205
    HansDouwe
    12-14-2023, 03:23 PM Go to last post

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

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

  10. [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

  11. [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

  12. [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

  13. 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

  14. [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

  15. 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

  16. 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

  17. 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

  18. Vlookup from Excel worksheet not saving in Word document

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

  19. [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

  20. [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

  21. 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

  22. 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

  23. [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

  24. 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
    • 151
    glent
    12-14-2023, 08:28 AM Go to last post

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

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

  26. [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

  27. Moved: Replicating Color Formatting along a column

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

  28. [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

  29. 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

  30. 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

  31. [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

  32. Help with Formula for Average

    Started by showtimesaints‎, 12-12-2023 11:45 PM
    4 Attachment(s)
    • 10
    • 311
    windknife
    12-14-2023, 12:34 AM Go to last post

  33. [SOLVED] Looped Xlookup (I think that's what I need)

    Started by Mattjc1‎, 12-13-2023 06:35 PM
    4 Attachment(s)
    • 5
    • 142
    TMS
    12-13-2023, 09:01 PM Go to last post

  34. [SOLVED] COUNTIFS but only for Filtered Rows

    Started by applehugger‎, 12-13-2023 05:58 PM
    • 7
    • 182
    applehugger
    12-13-2023, 08:53 PM Go to last post

  35. Cut/Paste Data Automatically based on Value within in WB

    Started by hutchy95‎, 12-11-2023 12:04 PM
    1 Attachment(s)
    • 1
    • 132
    JeteMc
    12-13-2023, 08:42 PM Go to last post

  36. Smile cell eror message

    Started by toddp2‎, 12-13-2023 02:39 PM
    • 1
    • 94
    alansidman
    12-13-2023, 04:36 PM Go to last post

  37. [SOLVED] prevent selected rows from printing

    Started by meonly123‎, 12-12-2023 08:36 PM
    2 Attachment(s)
    • 2
    • 162
    meonly123
    12-13-2023, 03:54 PM Go to last post

  38. [SOLVED] How to write a formula with multiple IF conditions?

    Started by rizwanulhasan‎, 12-13-2023 05:33 AM
    1 Attachment(s)
    • 15
    • 333
    JohnTopley
    12-13-2023, 03:24 PM Go to last post

  39. Vlookup find any date in range of dates in column with dates

    Started by Musto85‎, 12-13-2023 12:42 PM
    • 3
    • 131
    etaf
    12-13-2023, 02:28 PM Go to last post

  40. [SOLVED] Arrange Horizontal data in Table Form

    Started by KRIXXXX‎, 12-13-2023 12:19 PM
    1 Attachment(s)
    • 1
    • 161
    Estevaoba
    12-13-2023, 02:17 PM Go to last post

  41. [SOLVED] Two pulldowns pick out result from table

    Started by MrO‎, 12-13-2023 12:00 PM
    1 Attachment(s)
    • 3
    • 119
    AliGW
    12-13-2023, 01:58 PM Go to last post

  42. [SOLVED] Power Query - Get Dynamic Headers from another Table and "VLOOKUP"

    Started by dluhut‎, 12-11-2023 05:08 PM
    3 Attachment(s)
    • 3
    • 227
    alansidman
    12-13-2023, 12:10 PM Go to last post

  43. Question [SOLVED] Dates based on number and text from another sheet

    Started by AndreiD‎, 12-13-2023 10:30 AM
    vlookup 1 Attachment(s)
    • 4
    • 175
    Pepe Le Mokko
    12-13-2023, 12:02 PM Go to last post

  44. [SOLVED] Lookup Column headings and return corresponding column value in another row

    Started by kdrymer85‎, 12-13-2023 09:44 AM
    formula 3 Attachment(s)
    • 11
    • 227
    AliGW
    12-13-2023, 10:17 AM Go to last post

  45. [SOLVED] how to count words in cells (and compare it to quantity before adding it up)

    Started by excel_wnb‎, 12-13-2023 04:19 AM
    1 Attachment(s)
    • 8
    • 204
    windknife
    12-13-2023, 09:38 AM Go to last post

  46. Problem with =IF formula <<

    Started by geoff.s‎, 12-13-2023 06:10 AM
    if formula, if formula help 2 Attachment(s)
    • 7
    • 417
    AliGW
    12-13-2023, 07:58 AM Go to last post

  47. [SOLVED] Help creating a formula that requires different calculations for multiple columns

    Started by Linowood‎, 12-10-2023 07:31 PM
    2 Attachment(s)
    • 8
    • 344
    Gregb11
    12-13-2023, 07:49 AM Go to last post

  48. [SOLVED] Multiple data validation for cells.

    Started by krooms‎, 12-13-2023 05:53 AM
    1 Attachment(s)
    • 5
    • 232
    AliGW
    12-13-2023, 07:48 AM Go to last post

  49. Question [SOLVED] Count number of instances over a 13 week period

    Started by Oliver3443‎, 12-08-2023 05:47 AM
    2 Attachment(s)
    • 10
    • 265
    Oliver3443
    12-13-2023, 07:46 AM Go to last post

  50. Lightbulb [SOLVED] Use LET function to create 2 Sorted tables based on multiple criteria

    Started by Hesham121‎, 06-13-2023 05:51 AM
    5 Attachment(s)
    • 13
    • 348
    HansDouwe
    12-13-2023, 07:05 AM Go to last post
+ Post New Thread
Page 51 of 5614 FirstFirst ... 51 ...

Forum Information and Options

Users Browsing this Forum

There are currently 92 users browsing this forum. (8 members & 84 guests)

  1. bushwacked,
  2. Colin Legg,
  3. deadparrot,
  4. madgilberta,
  5. puffinator,
  6. TMS,
  7. webdjoe

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