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

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

  1. [SOLVED] highlight correct cells

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

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

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

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

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

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

  7. Formula to autofill date

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  27. 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
    • 341
    Keebellah
    04-26-2021, 08:34 AM Go to last post

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

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

  30. [SOLVED] Unique alphabetical list

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

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

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

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

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

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

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

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

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

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

  39. [SOLVED] Ranking list based on test scores

    Started by Madcowz7‎, 04-23-2021 10:09 PM
    4 Attachment(s)
    • 12
    • 499
    Madcowz7
    04-25-2021, 11:13 PM Go to last post

  40. Auto Data fatch

    Started by Wolfin2010‎, 04-24-2021 05:37 PM
    2 Attachment(s)
    • 1
    • 213
    Gregb11
    04-25-2021, 10:52 PM Go to last post

  41. [SOLVED] Value Function Gives #VALUE! Error....

    Started by viking2‎, 04-25-2021 07:50 PM
    2 Attachment(s)
    • 9
    • 558
    MrShorty
    04-25-2021, 10:40 PM Go to last post

  42. [SOLVED] Index and Filter Functions: Workaround to sort, filter, and format within array?

    Started by beginner21‎, 04-25-2021 12:50 PM
    array, filter array, format cell, index 1 Attachment(s)
    • 11
    • 767
    Fluff13
    04-25-2021, 04:48 PM Go to last post

  43. SUMIFS Function - Seeing the "Records" that make up a result

    Started by PeterJABarrett‎, 04-19-2021 04:47 PM
    2 Attachment(s)
    • 14
    • 445
    XL&ME
    04-25-2021, 03:27 PM Go to last post

  44. [SOLVED] Formula to count several columns and group into combinations

    Started by Excel_apprentice‎, 04-24-2021 06:44 AM
    3 Attachment(s)
    • 8
    • 304
    Excel_apprentice
    04-25-2021, 02:32 PM Go to last post

  45. Calculating Number of Weeks Between 2 Dates as of a Specific Date

    Started by DeeDeeDee‎, 04-23-2021 06:49 PM
    2 Attachment(s)
    • 4
    • 379
    DeeDeeDee
    04-25-2021, 01:16 PM Go to last post

  46. [SOLVED] Help with countif formula for calendar (countif any date in table present)

    Started by KMJ256388‎, 04-24-2021 05:58 PM
    2 Attachment(s)
    • 3
    • 665
    JohnTopley
    04-25-2021, 12:11 PM Go to last post

  47. Comparing Time Values

    Started by rjj920‎, 04-23-2021 08:45 AM
    iferror, offset, time 3 Attachment(s)
    • 7
    • 625
    AliGW
    04-25-2021, 09:57 AM Go to last post

  48. Count Worksheet in Workbook with Sheets that contain an underscore eg. 123456_Smith

    Started by wherdzik‎, 04-25-2021 08:50 AM
    • 3
    • 268
    Fluff13
    04-25-2021, 09:47 AM Go to last post

  49. Add cell reference within array brackets

    Started by Tony Tony‎, 04-24-2021 03:04 PM
    • 2
    • 257
    Tony Tony
    04-25-2021, 08:22 AM Go to last post

  50. 2 last values with conditional formatting

    Started by ruibarbosa‎, 04-24-2021 05:14 PM
    2 Attachment(s)
    • 2
    • 295
    AliGW
    04-25-2021, 05:55 AM Go to last post
+ Post New Thread
Page 501 of 5611 FirstFirst ... 501 ...

Forum Information and Options

Users Browsing this Forum

There are currently 64 users browsing this forum. (2 members & 62 guests)

  1. Rick Rothstein

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