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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  19. Moved: ISO Calendar in Power Query

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

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

  21. Solver error - Linearity condition not satisfied

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  50. 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
+ Post New Thread
Page 502 of 5611 FirstFirst ... 502 ...

Forum Information and Options

Users Browsing this Forum

There are currently 91 users browsing this forum. (4 members & 87 guests)

  1. alansidman,
  2. Jacc,
  3. MarkPr

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