+ Post New Thread
Page 502 of 5611 FirstFirst ... 502 ...
Threads 25051 to 25100 of 280543

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] 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

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

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

  4. [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
    • 768
    Fluff13
    04-25-2021, 04:48 PM Go to last post

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

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

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

  7. 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
    • 380
    DeeDeeDee
    04-25-2021, 01:16 PM Go to last post

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

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

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

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

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

  13. Question [SOLVED] how to calculate count & percentage form data base based on current month & previous month

    Started by emmr‎, 04-25-2021 04:59 AM
    2 Attachment(s)
    • 1
    • 345
    BadlySpelledBuoy
    04-25-2021, 05:50 AM Go to last post

  14. Arrow Index, aggregate and return the highest or following highest value (Avoid duplicates)

    Started by rajamdade‎, 04-22-2021 12:02 PM
    duplicate check, highest occurrence, index & aggregate, return a value, return all matches 2 Attachment(s)
    • 4
    • 414
    rajamdade
    04-25-2021, 05:27 AM Go to last post

  15. Moved: ISO Calendar in Power Query

    Started by ColaMix‎, 04-24-2021 11:20 AM
    •  
    •  

  16. Red face Sum Amount of hours and minutes to total time

    Started by Sigarya‎, 04-24-2021 06:15 PM
    1 Attachment(s)
    • 2
    • 283
    JohnTopley
    04-25-2021, 04:04 AM Go to last post

  17. Solver error - Linearity condition not satisfied

    Started by tapaspanda1321‎, 04-14-2021 04:53 PM
    5 Attachment(s)
    • 8
    • 4,450
    Hydraulics
    04-25-2021, 03:55 AM Go to last post

  18. [SOLVED] Excel Vlookup with IF to match date between two dates

    Started by mark888‎, 04-24-2021 05:33 PM
    1 Attachment(s)
    • 2
    • 342
    mark888
    04-25-2021, 03:33 AM Go to last post

  19. Tracker for Production Company

    Started by cocprofile‎, 04-25-2021 12:36 AM
    carton label, product inventory, production reports, production scheduling 2 Attachment(s)
    • 5
    • 374
    JohnTopley
    04-25-2021, 03:24 AM Go to last post

  20. Post Formula to search the name of cell C7 from master sheet

    Started by ang40sn‎, 04-24-2021 07:33 AM
    2 Attachment(s)
    • 6
    • 309
    JohnTopley
    04-25-2021, 02:37 AM Go to last post

  21. Lookup and Offset Help Please

    Started by ptmuldoon‎, 04-24-2021 05:06 PM
    • 1
    • 296
    FDibbins
    04-25-2021, 01:30 AM Go to last post

  22. Rept date every n row

    Started by daboho‎, 04-24-2021 12:07 PM
    2 Attachment(s)
    • 6
    • 380
    bebo021999
    04-25-2021, 01:05 AM Go to last post

  23. Look at header row and look down to see if there is data

    Started by wherdzik‎, 04-24-2021 04:49 PM
    2 Attachment(s)
    • 1
    • 207
    Bo_Ry
    04-25-2021, 01:05 AM Go to last post

  24. [SOLVED] Split the uneven text .

    Started by I need excel help‎, 04-24-2021 06:04 PM
    1 Attachment(s)
    • 2
    • 416
    I need excel help
    04-24-2021, 08:11 PM Go to last post

  25. [SOLVED] Index / Match with 4 criteria returns #N/A

    Started by JeffGrant‎, 04-24-2021 04:01 AM
    2 Attachment(s)
    • 5
    • 592
    JeffGrant
    04-24-2021, 06:22 PM Go to last post

  26. Automate sum of different months and products

    Started by kakaman‎, 04-24-2021 12:51 PM
    3 Attachment(s)
    • 8
    • 342
    JohnTopley
    04-24-2021, 04:01 PM Go to last post

  27. [SOLVED] Count asset value after minus the depreciation value

    Started by shyampanda‎, 04-24-2021 10:39 AM
    1 Attachment(s)
    • 5
    • 315
    shyampanda
    04-24-2021, 12:57 PM Go to last post

  28. [SOLVED] if formula for between two numbers

    Started by pavankumarbangaru‎, 04-24-2021 11:06 AM
    2 Attachment(s)
    • 4
    • 219
    etaf
    04-24-2021, 12:24 PM Go to last post

  29. Find closest non-blank cell to generate helper column

    Started by KGB_KGB‎, 04-23-2021 12:22 PM
    2 Attachment(s)
    • 4
    • 243
    Richard Buttrey
    04-24-2021, 12:18 PM Go to last post

  30. Tracking Increase/Decrease in Rank

    Started by zbert‎, 05-19-2020 12:46 AM
    3 Attachment(s)
    • 4
    • 581
    zbert
    04-24-2021, 12:07 PM Go to last post

  31. Find the Word "Missing" - Not In a Formula

    Started by wherdzik‎, 04-24-2021 09:35 AM
    • 3
    • 455
    Fluff13
    04-24-2021, 11:27 AM Go to last post

  32. [SOLVED] 2, 3, ,4, 5, 6, matches in every columns

    Started by Excl3454‎, 04-24-2021 01:32 AM
    countif, match & index 2 Attachment(s)
    • 2
    • 468
    Excl3454
    04-24-2021, 09:53 AM Go to last post

  33. [SOLVED] Create one master list from lists on multiple worksheets

    Started by TomP1988‎, 05-03-2019 05:32 PM
    6 Attachment(s)
    • 13
    • 957
    AliGW
    04-24-2021, 09:17 AM Go to last post

  34. [SOLVED] Show Names in the same Cell

    Started by l_grassic‎, 04-23-2021 03:03 PM
    1 Attachment(s)
    • 5
    • 317
    Fluff13
    04-24-2021, 08:23 AM Go to last post

  35. [SOLVED] Pull the content of the last cell of a column from multiple sheets to a master front sheet

    Started by Dorset_Bloke‎, 04-23-2021 03:59 PM
    indirect formula, lookup, lookup & references 2 Attachment(s)
    • 10
    • 889
    kvsrinivasamurthy
    04-24-2021, 07:17 AM Go to last post

  36. [SOLVED] Datedif formula needed for months and days

    Started by John Henworth‎, 04-24-2021 05:39 AM
    3 Attachment(s)
    • 3
    • 250
    torachan
    04-24-2021, 06:42 AM Go to last post

  37. Post Search and match value cross multiple sheets and return values

    Started by vennn‎, 04-24-2021 12:35 AM
    1 Attachment(s)
    • 2
    • 222
    bebo021999
    04-24-2021, 12:50 AM Go to last post

  38. status based on two dates with multiple conditions

    Started by dawnmv‎, 04-22-2021 06:53 PM
    1 Attachment(s)
    • 5
    • 355
    protonLeah
    04-24-2021, 12:09 AM Go to last post

  39. Question Identifying lowest price hours of day throughout the year.

    Started by JoeSlater‎, 04-23-2021 03:43 PM
    1 Attachment(s)
    • 1
    • 208
    bebo021999
    04-23-2021, 11:51 PM Go to last post

  40. [SOLVED] Tricky: How to check if two different values are in the same column

    Started by mrcdinis‎, 04-22-2021 05:39 PM
    • 10
    • 512
    hrlngrv
    04-23-2021, 07:29 PM Go to last post

  41. How to COPY DOWN a SUMIF formula.

    Started by dgarber‎, 04-23-2021 01:32 PM
    • 7
    • 753
    Fluff13
    04-23-2021, 05:08 PM Go to last post

  42. [SOLVED] vlookup returning N/A

    Started by bashscript‎, 04-23-2021 10:34 AM
    2 Attachment(s)
    • 18
    • 385
    bashscript
    04-23-2021, 04:57 PM Go to last post

  43. Dividing multiple columns and rows

    Started by Baybreeze75‎, 04-23-2021 03:19 PM
    • 1
    • 217
    JohnTopley
    04-23-2021, 04:56 PM Go to last post

  44. [SOLVED] Counting problem adding table rows

    Started by Berna11‎, 04-23-2021 01:48 PM
    2 Attachment(s)
    • 2
    • 227
    Berna11
    04-23-2021, 02:34 PM Go to last post

  45. [SOLVED] Sumifs with Criteria 1 as range rather than cell

    Started by haroonkhurshid‎, 04-23-2021 02:01 PM
    sumifs and formula, sumifs criteria range 1 Attachment(s)
    • 3
    • 288
    Fluff13
    04-23-2021, 02:31 PM Go to last post

  46. Excel formula to run a look up against two columns

    Started by Excel_apprentice‎, 04-16-2021 04:01 PM
    lookup formula 1 Attachment(s)
    • 3
    • 550
    Excel_apprentice
    04-23-2021, 02:25 PM Go to last post

  47. [SOLVED] Subtotal Count is including formula row in filtered data

    Started by msdclark‎, 04-22-2021 10:54 AM
    • 3
    • 292
    TMS
    04-23-2021, 01:12 PM Go to last post

  48. [SOLVED] Vertical lookup is not giving proper outcome

    Started by Morte1974‎, 04-23-2021 09:34 AM
    2 Attachment(s)
    • 7
    • 269
    JohnTopley
    04-23-2021, 01:06 PM Go to last post

  49. [SOLVED] Formula to return the most commonly occurring (text) value based on criteria

    Started by Excel_NoneTheWiser‎, 04-22-2021 07:57 AM
    3 Attachment(s)
    • 16
    • 562
    JohnTopley
    04-23-2021, 01:02 PM Go to last post

  50. [SOLVED] Formula to count days worked that are on weekends

    Started by KMJ256388‎, 04-23-2021 03:03 AM
    2 Attachment(s)
    • 6
    • 361
    JohnTopley
    04-23-2021, 01:00 PM Go to last post
+ Post New Thread
Page 502 of 5611 FirstFirst ... 502 ...

Forum Information and Options

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