+ Post New Thread
Page 501 of 5611 FirstFirst ... 501 ...
Threads 25001 to 25050 of 280542

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

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

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

  2. [SOLVED] MIN IF function across multiple worksheets

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

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

  4. Append and Store data using Power Query function

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

  5. Selecting Specific Cell Using Formula

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

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

  7. 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
    • 192
    TMS
    04-27-2021, 08:24 AM Go to last post

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

  9. [SOLVED] COUNTIFS error

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

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

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

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

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

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

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

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

  16. 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
    • 259
    JohnTopley
    04-27-2021, 02:24 AM Go to last post

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

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

  18. Formula to autofill date

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

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

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

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

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

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

  22. Alternative function ideas instead of filter?

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

  23. Question Make Poules with ABBA

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  36. 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
    • 257
    JohnTopley
    04-26-2021, 09:58 AM Go to last post

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

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

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

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

  40. [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
    • 420
    kolokoy
    04-26-2021, 07:56 AM Go to last post

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

  42. [SOLVED] Count days overdue only

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

  43. [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
    • 256
    Marbleking
    04-26-2021, 07:21 AM Go to last post

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

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

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

    Started by Eusr‎, 04-26-2021 05:24 AM
    •  
    •  

  47. Extract Year from Date

    Started by rluech‎, 04-26-2021 04:21 AM
    date, year() 1 Attachment(s)
    • 2
    • 374
    bebo021999
    04-26-2021, 05:19 AM Go to last post

  48. [SOLVED] Calculate data from multiple sheets and big rows.

    Started by dolphino‎, 04-26-2021 02:09 AM
    formula, sheet 4 Attachment(s)
    • 7
    • 394
    dolphino
    04-26-2021, 04:35 AM Go to last post

  49. [SOLVED] Nested IF Function and the Too Many Arguments Error

    Started by sainters‎, 04-25-2021 09:49 PM
    • 2
    • 351
    sainters
    04-25-2021, 11:14 PM Go to last post

  50. [SOLVED] Ranking list based on test scores

    Started by Madcowz7‎, 04-23-2021 10:09 PM
    4 Attachment(s)
    • 12
    • 500
    Madcowz7
    04-25-2021, 11:13 PM Go to last post
+ Post New Thread
Page 501 of 5611 FirstFirst ... 501 ...

Forum Information and Options

Users Browsing this Forum

There are currently 106 users browsing this forum. (10 members & 96 guests)

  1. 6StringJazzer,
  2. BE_receiving,
  3. Edward Hyde,
  4. Estevaoba,
  5. Jacc,
  6. JohnTopley,
  7. LeapyUK,
  8. lilsnoop,
  9. rjj920

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