+ Post New Thread
Page 504 of 5614 FirstFirst ... 504 ...
Threads 25151 to 25200 of 280696

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

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

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

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

  4. 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,834
    anay_zinje
    04-27-2021, 11:49 AM Go to last post

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

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

  7. [SOLVED] MIN IF function across multiple worksheets

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

  8. 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
    • 251
    sniper1
    04-27-2021, 11:10 AM Go to last post

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

  10. Selecting Specific Cell Using Formula

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

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

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

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

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

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

  16. 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
    • 478
    bebo021999
    04-27-2021, 06:03 AM Go to last post

  17. [SOLVED] highlight correct cells

    Started by John Henworth‎, 04-27-2021 02:33 AM
    2 Attachment(s)
    • 2
    • 275
    John Henworth
    04-27-2021, 04:37 AM Go to last post

  18. I need to trace positive and negative similar values irrespective 1250 rows of data

    Started by manoje‎, 04-27-2021 03:28 AM
    1 Attachment(s)
    • 2
    • 174
    bebo021999
    04-27-2021, 04:13 AM Go to last post

  19. [SOLVED] Provide cell contents from every other row on another sheet

    Started by phifer2088‎, 04-27-2021 02:20 AM
    1 Attachment(s)
    • 6
    • 276
    TMS
    04-27-2021, 03:35 AM Go to last post

  20. [SOLVED] How to check and count two column content simultaneously?

    Started by indicock‎, 04-24-2021 10:16 AM
    check and count, two column count 1 Attachment(s)
    • 3
    • 283
    JohnTopley
    04-27-2021, 02:26 AM Go to last post

  21. Question [SOLVED] Flexible range dropdown with previous conditions over the range of two sheets

    Started by bjoernZ‎, 04-22-2021 10:43 AM
    2 Attachment(s)
    • 5
    • 261
    JohnTopley
    04-27-2021, 02:24 AM Go to last post

  22. Extract Values from F15:S20 into F3:S10 if Condition Met

    Started by bjnockle‎, 04-20-2021 08:34 PM
    14 Attachment(s)
    • 18
    • 808
    kvsrinivasamurthy
    04-26-2021, 11:52 PM Go to last post

  23. Formula to autofill date

    Started by DJBlouin‎, 04-23-2021 01:06 PM
    date
    • 2
    • 412
    DJBlouin
    04-26-2021, 11:18 PM Go to last post

  24. [SOLVED] Returning multiple MATCH results in same cell, using wildcards

    Started by Genericname5632‎, 04-26-2021 10:16 PM
    1 Attachment(s)
    • 3
    • 213
    Genericname5632
    04-26-2021, 10:40 PM Go to last post

  25. [SOLVED] Array? error checking formula???

    Started by Babbabooie‎, 04-26-2021 04:45 PM
    long forumla 1 Attachment(s)
    • 1
    • 255
    spitfireblue
    04-26-2021, 10:40 PM Go to last post

  26. Question COUNTIFS a range is not blank

    Started by vwhite‎, 04-26-2021 12:45 PM
    countifs 2 Attachment(s)
    • 3
    • 330
    Glenn Kennedy
    04-26-2021, 05:38 PM Go to last post

  27. Alternative function ideas instead of filter?

    Started by beginner21‎, 04-26-2021 02:49 PM
    filter array, xlfn 1 Attachment(s)
    • 1
    • 413
    beginner21
    04-26-2021, 04:55 PM Go to last post

  28. Question Make Poules with ABBA

    Started by laforge2‎, 04-26-2021 04:09 PM
    abba, sort and filter
    • 2
    • 360
    laforge2
    04-26-2021, 04:43 PM Go to last post

  29. Add up all the value of a certain instance based on a certain sales category

    Started by sniper1‎, 04-26-2021 03:01 PM
    2 Attachment(s)
    • 1
    • 248
    etaf
    04-26-2021, 03:44 PM Go to last post

  30. [SOLVED] Formula show the last day of customer service

    Started by R0CKY‎, 04-26-2021 02:35 PM
    2 Attachment(s)
    • 3
    • 234
    The_Snook
    04-26-2021, 03:20 PM Go to last post

  31. [SOLVED] Find the value in the table and add up the instances of a team's total sales

    Started by sniper1‎, 04-26-2021 11:33 AM
    1 Attachment(s)
    • 2
    • 317
    sniper1
    04-26-2021, 02:35 PM Go to last post

  32. [SOLVED] Subtract difference of sums of two columns

    Started by Chet Gustavson‎, 04-26-2021 01:12 PM
    columns, subtract difference, sum
    • 4
    • 602
    Fluff13
    04-26-2021, 02:29 PM Go to last post

  33. Lightbulb IF statement breaks in the middle of the formula

    Started by noktis‎, 04-26-2021 02:10 PM
    • 1
    • 181
    MrShorty
    04-26-2021, 02:18 PM Go to last post

  34. Large root squire formula

    Started by vtegroup‎, 04-26-2021 01:11 PM
    2 Attachment(s)
    • 2
    • 199
    vtegroup
    04-26-2021, 01:50 PM Go to last post

  35. Search with values from one row in another column and then return value

    Started by Flips84‎, 04-26-2021 07:12 AM
    3 Attachment(s)
    • 6
    • 244
    Flips84
    04-26-2021, 01:00 PM Go to last post

  36. [SOLVED] Add Semicolon to Numbers in Different Cells Then Combine

    Started by woodsedge‎, 04-26-2021 11:10 AM
    2 Attachment(s)
    • 8
    • 229
    Glenn Kennedy
    04-26-2021, 11:38 AM Go to last post

  37. [SOLVED] Group and total duplicate values in a column

    Started by Thistledown‎, 04-26-2021 08:35 AM
    6 Attachment(s)
    • 10
    • 312
    Thistledown
    04-26-2021, 11:30 AM Go to last post

  38. Help with a COUNT formula to show total an ID occurs - not a running total

    Started by bfaws‎, 04-26-2021 10:51 AM
    1 Attachment(s)
    • 4
    • 371
    davsth
    04-26-2021, 11:13 AM Go to last post

  39. [SOLVED] IF formula to check value between two dates, add another condition

    Started by bfaws‎, 04-26-2021 10:24 AM
    • 3
    • 243
    6StringJazzer
    04-26-2021, 10:59 AM Go to last post

  40. Formula To Count Absences Based on Criteria & Matching Dates

    Started by LOK25‎, 04-22-2021 07:52 PM
    5 Attachment(s)
    • 8
    • 372
    JohnTopley
    04-26-2021, 10:37 AM Go to last post

  41. I think I need some type of concant formula? Index? Please Help! :)

    Started by keith81591‎, 04-23-2021 04:04 PM
    2 Attachment(s)
    • 3
    • 258
    JohnTopley
    04-26-2021, 09:58 AM Go to last post

  42. [SOLVED] Converting Conditional Formatting to regular formatting.

    Started by Graham Pall‎, 07-31-2015 10:28 AM
    • 10
    • 3,578
    LadyDesperada
    04-26-2021, 08:41 AM Go to last post

  43. Changing cell colour based on another cell's value, but the latter cell changes

    Started by Coffee-Hound‎, 04-26-2021 08:26 AM
    2 Attachment(s)
    • 1
    • 342
    Keebellah
    04-26-2021, 08:34 AM Go to last post

  44. Unhappy [SOLVED] Generate Report Per Plot Based on Number of Times a Specific Value Appears on a Given Day

    Started by lukerudd‎, 03-15-2021 09:17 AM
    14 Attachment(s)
    • 31
    • 864
    lukerudd
    04-26-2021, 08:28 AM Go to last post

  45. [SOLVED] How to extract member names for each leader in a worksheet

    Started by kolokoy‎, 04-24-2021 08:26 AM
    extracting data in cells 1 Attachment(s)
    • 10
    • 421
    kolokoy
    04-26-2021, 07:56 AM Go to last post

  46. [SOLVED] Unique alphabetical list

    Started by Berna11‎, 04-25-2021 11:56 AM
    4 Attachment(s)
    • 13
    • 687
    Glenn Kennedy
    04-26-2021, 07:40 AM Go to last post

  47. [SOLVED] Count days overdue only

    Started by Photochain‎, 04-26-2021 05:42 AM
    4 Attachment(s)
    • 9
    • 633
    TMS
    04-26-2021, 07:30 AM Go to last post

  48. [SOLVED] RANKIF function which can take formulas giving dynamic ranges as arguments

    Started by Marbleking‎, 04-26-2021 06:08 AM
    arguments, calculated ranges, rankif 2 Attachment(s)
    • 3
    • 257
    Marbleking
    04-26-2021, 07:21 AM Go to last post

  49. Question [SOLVED] Column tally stopped working when extending the table manually.

    Started by jitterbug888‎, 04-26-2021 01:05 AM
    table columns, table formula 5 Attachment(s)
    • 5
    • 379
    jitterbug888
    04-26-2021, 06:17 AM Go to last post

  50. Extract low and high by date range

    Started by Yoni17‎, 04-26-2021 05:22 AM
    2 Attachment(s)
    • 1
    • 173
    Glenn Kennedy
    04-26-2021, 05:39 AM Go to last post
+ Post New Thread
Page 504 of 5614 FirstFirst ... 504 ...

Forum Information and Options

Users Browsing this Forum

There are currently 61 users browsing this forum. (1 members & 60 guests)

  1. Fluff13

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