+ Post New Thread
Page 503 of 5614 FirstFirst ... 503 ...
Threads 25101 to 25150 of 280680

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

  1. COUNTIF Question

    Started by fathafluff‎, 04-28-2021 02:50 PM
    1 Attachment(s)
    • 2
    • 226
    TMS
    04-28-2021, 03:13 PM Go to last post

  2. [SOLVED] Find all unique values that are not blank

    Started by Tjfinley‎, 04-28-2021 02:44 PM
    1 Attachment(s)
    • 3
    • 177
    Fluff13
    04-28-2021, 03:02 PM Go to last post

  3. [SOLVED] Receiving VALUE error in a cell that has this formula

    Started by cubangt‎, 04-28-2021 02:31 PM
    • 3
    • 208
    cubangt
    04-28-2021, 03:01 PM Go to last post

  4. Expanding Results to multiple cells.

    Started by RyanVB99‎, 04-28-2021 12:53 PM
    1 Attachment(s)
    • 3
    • 309
    RyanVB99
    04-28-2021, 01:07 PM Go to last post

  5. Question [SOLVED] Help with Index/Match on two criteria

    Started by iantix‎, 04-28-2021 10:02 AM
    1 Attachment(s)
    • 7
    • 282
    iantix
    04-28-2021, 12:13 PM Go to last post

  6. [SOLVED] adding up previous month

    Started by DEEARO‎, 04-28-2021 11:54 AM
    1 Attachment(s)
    • 2
    • 194
    JohnTopley
    04-28-2021, 12:08 PM Go to last post

  7. LOGEST returns #NUM! error, same data range works fine in LINEST

    Started by Technetium‎, 04-27-2021 09:12 AM
    • 5
    • 1,380
    MrShorty
    04-28-2021, 11:25 AM Go to last post

  8. Excel Query Editor

    Started by jharvey87‎, 04-27-2021 03:38 PM
    1 Attachment(s)
    • 1
    • 274
    XLent
    04-28-2021, 11:08 AM Go to last post

  9. [SOLVED] Missing parenthesis

    Started by dcargill‎, 04-28-2021 09:13 AM
    • 3
    • 345
    JohnTopley
    04-28-2021, 10:41 AM Go to last post

  10. [SOLVED] INDEX,MATCH from bottom up with multi-criteria

    Started by MannStewart‎, 04-28-2021 05:14 AM
    2 Attachment(s)
    • 7
    • 2,108
    MannStewart
    04-28-2021, 10:04 AM Go to last post

  11. Creating a dynamic monthly meal calendar

    Started by Brunheas‎, 04-28-2021 09:32 AM
    5 Attachment(s)
    • 1
    • 299
    JohnTopley
    04-28-2021, 09:48 AM Go to last post

  12. Buying and Selling in Multiple Currencies

    Started by mattsar‎, 04-28-2021 08:11 AM
    2 Attachment(s)
    • 2
    • 195
    JohnTopley
    04-28-2021, 09:06 AM Go to last post

  13. [SOLVED] Summing up weights for different suppliers and products per month

    Started by smbcoach‎, 04-28-2021 03:19 AM
    2 Attachment(s)
    • 10
    • 404
    smbcoach
    04-28-2021, 09:02 AM Go to last post

  14. [SOLVED] Return booked holiday dates from a holiday planner

    Started by johnmitch38‎, 04-28-2021 07:15 AM
    2 Attachment(s)
    • 2
    • 257
    johnmitch38
    04-28-2021, 08:18 AM Go to last post

  15. [SOLVED] Cumulative amount excel formula

    Started by sunboy‎, 04-28-2021 07:13 AM
    2 Attachment(s)
    • 3
    • 356
    sunboy
    04-28-2021, 08:15 AM Go to last post

  16. Thumbs up [SOLVED] Reference Data Changes Every 2nd Row

    Started by ChristovJN‎, 04-28-2021 07:04 AM
    1 Attachment(s)
    • 2
    • 215
    ChristovJN
    04-28-2021, 07:48 AM Go to last post

  17. Question [SOLVED] Formula to find the End date value from a date range.

    Started by ftk0811‎, 04-28-2021 06:48 AM
    1 Attachment(s)
    • 1
    • 266
    JohnTopley
    04-28-2021, 07:07 AM Go to last post

  18. [SOLVED] get the next month of a selected month.

    Started by ilikegreen‎, 04-28-2021 03:42 AM
    excel, formula, month, next month
    • 3
    • 374
    JohnTopley
    04-28-2021, 06:05 AM Go to last post

  19. How to get records based on a condition using Index Match?

    Started by Eduards‎, 04-28-2021 04:51 AM
    2 Attachment(s)
    • 4
    • 233
    kvsrinivasamurthy
    04-28-2021, 05:21 AM Go to last post

  20. [SOLVED] Count Unique Values Using multiple criteris

    Started by Iain170‎, 04-28-2021 03:01 AM
    3 Attachment(s)
    • 6
    • 737
    kvsrinivasamurthy
    04-28-2021, 05:01 AM Go to last post

  21. sending an email in outlook from a list of email address in excel

    Started by lydiat‎, 04-28-2021 03:02 AM
    • 1
    • 300
    lydiat
    04-28-2021, 03:33 AM Go to last post

  22. Excel Formula-Substract Function

    Started by ricky82‎, 04-28-2021 02:52 AM
    1 Attachment(s)
    • 1
    • 204
    JohnTopley
    04-28-2021, 03:06 AM Go to last post

  23. [SOLVED] Use formula only if there is a value in another cell

    Started by Juanhijuan‎, 04-26-2021 11:05 AM
    2 Attachment(s)
    • 9
    • 729
    Glenn Kennedy
    04-28-2021, 02:46 AM Go to last post

  24. [SOLVED] no return value if count is 0

    Started by bashscript‎, 04-26-2021 11:48 AM
    4 Attachment(s)
    • 4
    • 254
    Glenn Kennedy
    04-28-2021, 02:46 AM Go to last post

  25. Help with date range within COUNTIFS formula

    Started by pptdgc1999‎, 04-27-2021 11:02 AM
    countifs, countifs criteria range 1 Attachment(s)
    • 5
    • 396
    JohnTopley
    04-28-2021, 01:07 AM Go to last post

  26. [SOLVED] Pulling data from another sheet based on certain criteria, without creating blank rows

    Started by afreed33‎, 04-27-2021 12:28 AM
    blank cell, copying data, criteria, formula 2 Attachment(s)
    • 2
    • 889
    afreed33
    04-27-2021, 04:37 PM Go to last post

  27. Need it to sum total miles for week on seperate sheet

    Started by MsMel‎, 04-27-2021 03:33 PM
    1 Attachment(s)
    • 5
    • 221
    MsMel
    04-27-2021, 04:01 PM Go to last post

  28. Need Help: Finding Duplicate Values on Separate Sheets to Add Value of Another Cell

    Started by jaked4ge‎, 04-27-2021 03:17 PM
    2 Attachment(s)
    • 4
    • 242
    jaked4ge
    04-27-2021, 03:28 PM Go to last post

  29. [SOLVED] Formula Help for certain criteria

    Started by Stryfe‎, 04-27-2021 12:59 PM
    2 Attachment(s)
    • 2
    • 180
    Stryfe
    04-27-2021, 03:27 PM Go to last post

  30. Nested If with Or (I think)

    Started by Skittle82‎, 04-27-2021 12:23 PM
    1 Attachment(s)
    • 4
    • 202
    JohnTopley
    04-27-2021, 03:09 PM Go to last post

  31. [SOLVED] Finding duplicates with specific criteria

    Started by ClaraEB‎, 04-27-2021 01:49 PM
    1 Attachment(s)
    • 3
    • 207
    Fluff13
    04-27-2021, 02:12 PM Go to last post

  32. Smile Return value based on two project dates: Completed, Ongoing, Upcoming

    Started by nicoke‎, 04-26-2021 06:46 PM
    conditions, dates, formula 1 Attachment(s)
    • 4
    • 527
    FlameRetired
    04-27-2021, 01:40 PM Go to last post

  33. Question How to Convert DD/MM/YY HHMM to DD/MM/YY HH:MM

    Started by sactownhero‎, 04-27-2021 01:10 PM
    • 1
    • 229
    MrShorty
    04-27-2021, 01:20 PM Go to last post

  34. [SOLVED] sum row with different criteria's

    Started by DEEARO‎, 04-27-2021 12:33 PM
    2 Attachment(s)
    • 1
    • 205
    Bo_Ry
    04-27-2021, 12:57 PM Go to last post

  35. [SOLVED] finding the most Popular

    Started by DEEARO‎, 04-26-2021 07:16 AM
    4 Attachment(s)
    • 7
    • 281
    Glenn Kennedy
    04-27-2021, 12:35 PM Go to last post

  36. [SOLVED] FUNCTION INDEX + MATCH alternate solution

    Started by ferfer20‎, 04-26-2021 06:08 PM
    microsoft excel 2010, microsoft excel 2013, microsoft excel 2016 1 Attachment(s)
    • 2
    • 359
    ferfer20
    04-27-2021, 11:57 AM Go to last post

  37. Append and Store data using Power Query function

    Started by anay_zinje‎, 04-27-2021 10:57 AM
    append, power query 1 Attachment(s)
    • 1
    • 403
    anay_zinje
    04-27-2021, 11:51 AM Go to last post

  38. Shortcut Keys in Excel Ctrl + Shift + N, Ctrl + Shift + R, Ctrl + Shift + U is not working

    Started by anay_zinje‎, 03-17-2016 02:47 AM
    1 Attachment(s)
    • 4
    • 13,822
    anay_zinje
    04-27-2021, 11:49 AM Go to last post

  39. If formula on range with multiple conditions over multiple columns

    Started by Mr Stern 2‎, 04-27-2021 11:22 AM
    if multiple cells, if multiple condition, multiple criteria 1 Attachment(s)
    • 2
    • 321
    JohnTopley
    04-27-2021, 11:36 AM Go to last post

  40. [SOLVED] Vlookup from a range that have the same name

    Started by Even‎, 04-27-2021 08:31 AM
    3 Attachment(s)
    • 6
    • 259
    Even
    04-27-2021, 11:17 AM Go to last post

  41. [SOLVED] MIN IF function across multiple worksheets

    Started by Uomoviso‎, 09-02-2017 07:52 AM
    4 Attachment(s)
    • 15
    • 3,556
    nzopa
    04-27-2021, 11:12 AM Go to last post

  42. Find the value in the table and add up the instances of a team's total sales-From a table

    Started by sniper1‎, 04-27-2021 11:10 AM
    1 Attachment(s)
    • 0
    • 245
    sniper1
    04-27-2021, 11:10 AM Go to last post

  43. Append and Store data using Power Query function

    Started by anay_zinje‎, 04-27-2021 11:07 AM
    • 0
    • 292
    anay_zinje
    04-27-2021, 11:07 AM Go to last post

  44. Selecting Specific Cell Using Formula

    Started by CavyRPh‎, 04-27-2021 10:32 AM
    • 5
    • 358
    Fluff13
    04-27-2021, 10:59 AM Go to last post

  45. [SOLVED] Assign number to collumn for calculation in row

    Started by Coffeeflower‎, 04-27-2021 08:56 AM
    assign number, assign values, hidden formula, invisible value, row calcualtion 1 Attachment(s)
    • 3
    • 265
    JohnTopley
    04-27-2021, 09:31 AM Go to last post

  46. How to extract a total # from a subtotal string to use in a xlookup to another worksheet

    Started by DMcVey‎, 04-27-2021 08:13 AM
    • 1
    • 193
    TMS
    04-27-2021, 08:24 AM Go to last post

  47. Cell with formula affected by another cell which is not part of the formula

    Started by MagdalenaMc‎, 04-27-2021 08:15 AM
    • 1
    • 152
    AliGW
    04-27-2021, 08:17 AM Go to last post

  48. [SOLVED] COUNTIFS error

    Started by Thistledown‎, 04-27-2021 07:27 AM
    1 Attachment(s)
    • 5
    • 312
    JohnTopley
    04-27-2021, 07:51 AM Go to last post

  49. Find Record on 2 criteria with nearest lowest date

    Started by sanjuss2‎, 04-27-2021 02:24 AM
    4 Attachment(s)
    • 15
    • 328
    JohnTopley
    04-27-2021, 06:39 AM Go to last post

  50. Question Getting =COUNTIFS to change when results are filtered - Please help!

    Started by Mattmcging‎, 04-26-2021 09:43 AM
    countif, countifs, filter, subfunction, subtotal 1 Attachment(s)
    • 4
    • 476
    bebo021999
    04-27-2021, 06:03 AM Go to last post
+ Post New Thread
Page 503 of 5614 FirstFirst ... 503 ...

Forum Information and Options

Users Browsing this Forum

There are currently 54 users browsing this forum. (1 members & 53 guests)

  1. tungten9x

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