+ Post New Thread
Page 503 of 5613 FirstFirst ... 503 ...
Threads 25101 to 25150 of 280645

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] 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
    • 358
    ferfer20
    04-27-2021, 11:57 AM Go to last post

  2. 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
    • 401
    anay_zinje
    04-27-2021, 11:51 AM Go to last post

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

  4. 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
    • 319
    JohnTopley
    04-27-2021, 11:36 AM Go to last post

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

  6. [SOLVED] MIN IF function across multiple worksheets

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

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

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

  9. Selecting Specific Cell Using Formula

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

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

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

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

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

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

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

  16. [SOLVED] highlight correct cells

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

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

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

  19. [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
    • 282
    JohnTopley
    04-27-2021, 02:26 AM Go to last post

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

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

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

  22. Formula to autofill date

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

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

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

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

  25. Question COUNTIFS a range is not blank

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

  26. Alternative function ideas instead of filter?

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

  27. Question Make Poules with ABBA

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

  28. 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
    • 247
    etaf
    04-26-2021, 03:44 PM Go to last post

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

  30. [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
    • 315
    sniper1
    04-26-2021, 02:35 PM Go to last post

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

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

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

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

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

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

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

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

  37. 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
    • 369
    davsth
    04-26-2021, 11:13 AM Go to last post

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

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

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

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

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

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

  43. 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
    • 863
    lukerudd
    04-26-2021, 08:28 AM Go to last post

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

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

  46. [SOLVED] Count days overdue only

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

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

  48. 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
    • 376
    jitterbug888
    04-26-2021, 06:17 AM Go to last post

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

  50. Moved: [SOLVED] What a great forum!

    Started by Eusr‎, 04-26-2021 05:24 AM
    •  
    •  
+ Post New Thread
Page 503 of 5613 FirstFirst ... 503 ...

Forum Information and Options

Users Browsing this Forum

There are currently 94 users browsing this forum. (6 members & 88 guests)

  1. ExcelNewbie92,
  2. greentea,
  3. JohnTopley,
  4. lee77,
  5. tays01s,
  6. xcellancer

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