+ Post New Thread
Page 451 of 5614 FirstFirst ... 451 ...
Threads 22501 to 22550 of 280687

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

  1. Calculate average only if all cells include values. Also use OFFSET for dynamic range.

    Started by jpowellzy‎, 10-19-2021 09:00 AM
    average, blank, isnumber, offset, text 1 Attachment(s)
    • 11
    • 791
    JeteMc
    10-22-2021, 10:54 AM Go to last post

  2. [SOLVED] Using a oggle button criteria within a countifs function

    Started by Slurry Pumper‎, 05-31-2018 11:33 AM
    2 Attachment(s)
    • 11
    • 899
    Slurry Pumper
    05-31-2018, 03:46 PM Go to last post

  3. [SOLVED] Problem with Index-Match function

    Started by offload‎, 05-29-2018 11:53 AM
    index, match 2 Attachment(s)
    • 11
    • 360
    63falcondude
    05-29-2018, 03:24 PM Go to last post

  4. Question [SOLVED] Partial text frequency counting in reports

    Started by losc‎, 10-21-2021 04:35 AM
    frequency, frequency text string, text analysis 5 Attachment(s)
    • 11
    • 472
    AliGW
    10-21-2021, 08:49 AM Go to last post

  5. [SOLVED] finding duplicates and triplicates between two lists

    Started by LAVA2‎, 05-29-2018 10:53 AM
    data accessing, dataset, excel, formulas & functions, sorting 1 Attachment(s)
    • 11
    • 779
    FlameRetired
    05-31-2018, 02:40 AM Go to last post

  6. Formular for prorating salary

    Started by [email protected]‎, 05-28-2018 06:25 AM
    2 Attachment(s)
    • 11
    • 507
    Roel Jongman
    06-04-2018, 05:23 AM Go to last post

  7. [SOLVED] Count dates in order (that are out of order)

    Started by Mogal‎, 02-28-2018 12:18 PM
    3 Attachment(s)
    • 11
    • 544
    Mogal
    03-01-2018, 11:35 AM Go to last post

  8. [SOLVED] get sum based on current month

    Started by k1dr0ck‎, 06-01-2018 02:01 AM
    4 Attachment(s)
    • 11
    • 412
    k1dr0ck
    06-04-2018, 04:32 AM Go to last post

  9. Extract certain columns within rows.

    Started by Sam D‎, 05-14-2018 11:16 AM
    2 Attachment(s)
    • 11
    • 377
    JohnTopley
    05-15-2018, 01:53 AM Go to last post

  10. Conditional Formatting - 2 columns of "general" numbers

    Started by prefcomm‎, 05-17-2018 12:19 PM
    3 Attachment(s)
    • 11
    • 591
    kvsrinivasamurthy
    05-21-2018, 11:13 AM Go to last post

  11. [SOLVED] Has percentage gone up or down based on prior cells with percentages in

    Started by moneypennie21‎, 05-21-2018 09:58 AM
    percentage change 5 Attachment(s)
    • 11
    • 468
    moneypennie21
    05-22-2018, 07:55 AM Go to last post

  12. [SOLVED] SUMPRODUCT Formula, using OR Logic

    Started by YUSATrain‎, 05-21-2018 02:22 PM
    3 Attachment(s)
    • 11
    • 571
    FDibbins
    05-22-2018, 05:22 PM Go to last post

  13. Cool [SOLVED] Which function do i have to use for counting only the names in one column ?

    Started by detektiv‎, 06-10-2018 05:14 AM
    function, names 1 Attachment(s)
    • 11
    • 643
    AliGW
    06-10-2018, 08:10 AM Go to last post

  14. [SOLVED] Formula

    Started by rizmomin‎, 02-04-2016 03:41 PM
    1 Attachment(s)
    • 11
    • 601
    rizmomin
    02-04-2016, 04:40 PM Go to last post

  15. [SOLVED] Transpose horizontal to vertical

    Started by akalien‎, 11-12-2021 06:56 AM
    5 Attachment(s)
    • 11
    • 414
    Pete_UK
    11-12-2021, 12:09 PM Go to last post

  16. Reshaping a matrix with formulas

    Started by RaulSerg‎, 10-18-2021 10:51 AM
    5 Attachment(s)
    • 11
    • 396
    RaulSerg
    10-20-2021, 05:53 AM Go to last post

  17. [SOLVED] Index/Match all associations formula help

    Started by lilsnoop‎, 11-21-2021 11:58 AM
    3 Attachment(s)
    • 11
    • 332
    lilsnoop
    11-21-2021, 04:58 PM Go to last post

  18. [SOLVED] Turn a COUNT formula into a Spilled Array formula

    Started by sire152003‎, 11-18-2021 07:13 PM
    array, spill, spilled range 3 Attachment(s)
    • 11
    • 583
    sire152003
    11-19-2021, 06:38 AM Go to last post

  19. [SOLVED] Return multiple rows based on multiple critera

    Started by meesha123‎, 10-27-2021 02:11 PM
    3 Attachment(s)
    • 11
    • 450
    meesha123
    11-16-2021, 07:17 AM Go to last post

  20. Working out days of rest with IFS function (two criteria)

    Started by caseyjayne23‎, 11-04-2021 09:21 AM
    1 Attachment(s)
    • 11
    • 262
    caseyjayne23
    11-04-2021, 03:04 PM Go to last post

  21. Help! Label a record depending on country and amount

    Started by LRULES‎, 11-14-2021 12:20 AM
    7 Attachment(s)
    • 11
    • 407
    LRULES
    11-15-2021, 10:21 PM Go to last post

  22. [SOLVED] List Result Dynamically with Match Partial Result

    Started by dluhut‎, 11-08-2021 07:37 PM
    5 Attachment(s)
    • 11
    • 388
    JEC.
    11-09-2021, 05:06 PM Go to last post

  23. Question [SOLVED] How to cal. monthly salary for mid hire/termination using Sumifs or SUmproduct

    Started by ShriHanuman‎, 11-07-2021 04:56 PM
    5 Attachment(s)
    • 11
    • 497
    JeteMc
    11-17-2021, 04:45 PM Go to last post

  24. Vlookup with conditional formatting

    Started by Kcadzow‎, 11-22-2021 07:49 AM
    2 Attachment(s)
    • 11
    • 355
    Fluff13
    11-29-2021, 12:59 PM Go to last post

  25. [SOLVED] Counting unique values in range, ignoring blank and "#N/A" values

    Started by Pr0‎, 11-30-2021 04:54 PM
    4 Attachment(s)
    • 11
    • 379
    Pr0
    12-01-2021, 09:39 AM Go to last post

  26. [SOLVED] include conditional formatting with TRANSPOSE function?

    Started by LizzyJ‎, 08-11-2014 10:44 AM
    1 Attachment(s)
    • 11
    • 10,581
    LizzyJ
    08-28-2014, 04:48 AM Go to last post

  27. Help...Need to modify data within a column in a .csv file

    Started by [email protected]‎, 10-24-2005 03:05 PM
    • 11
    • 808
    Ken Wright
    10-26-2005, 07:05 PM Go to last post

  28. Create Pop-up Error

    Started by garretonufer‎, 08-11-2009 07:10 PM
    • 11
    • 1,447
    JBeaucaire
    08-11-2009, 07:56 PM Go to last post

  29. Match,VlookUp & Highlight

    Started by seanyeap‎, 08-17-2009 06:53 AM
    2 Attachment(s)
    • 11
    • 2,760
    seanyeap
    08-19-2009, 04:10 AM Go to last post

  30. Find concurrent usage durations based on number of systems utilized simultaneously

    Started by ninsine‎, 11-22-2012 02:32 PM
    concurrent, duration, usage 3 Attachment(s)
    • 11
    • 937
    ninsine
    11-26-2012, 08:46 PM Go to last post

  31. [SOLVED] Working out a grade average using a lookup table

    Started by kitkatkin‎, 11-29-2012 05:59 PM
    1 Attachment(s)
    • 11
    • 1,174
    kitkatkin
    11-29-2012, 07:48 PM Go to last post

  32. Question Formula to search sheet for 2 indicators in same row and return specific info to cell

    Started by ThaGonz‎, 11-30-2012 06:20 PM
    2 Attachment(s)
    • 11
    • 893
    ThaGonz
    11-30-2012, 08:04 PM Go to last post

  33. [SOLVED] Calculating dates

    Started by trosasco‎, 09-17-2013 01:55 PM
    • 11
    • 763
    newdoverman
    09-17-2013, 03:36 PM Go to last post

  34. Help with an AVERAGE Formula

    Started by map_man‎, 09-19-2013 04:00 AM
    • 11
    • 696
    Tony Valko
    09-19-2013, 03:00 PM Go to last post

  35. [SOLVED] Formula to subtract duration from fixed time

    Started by TopDog0310‎, 09-19-2013 06:30 PM
    6 Attachment(s)
    • 11
    • 1,902
    Greg M
    09-22-2013, 04:19 PM Go to last post

  36. Question about counting cell thats have two different text in two different columns

    Started by rgrocks‎, 09-19-2013 07:44 PM
    1 Attachment(s)
    • 11
    • 784
    Tony Valko
    09-20-2013, 10:13 AM Go to last post

  37. Unique Values by month in date range

    Started by kerrynyc‎, 09-25-2013 10:47 AM
    3 Attachment(s)
    • 11
    • 1,125
    daffodil11
    09-25-2013, 04:53 PM Go to last post

  38. [SOLVED] Referencing a formula that will automatically update several cells

    Started by joevan‎, 08-22-2014 12:25 PM
    5 Attachment(s)
    • 11
    • 808
    Glenn Kennedy
    08-28-2014, 05:33 PM Go to last post

  39. [SOLVED] Difficulty figuring out were to put IFNA

    Started by TheBakerBoy‎, 02-22-2016 07:25 PM
    • 11
    • 1,226
    David A Coop
    02-25-2016, 03:00 AM Go to last post

  40. [SOLVED] Dynamic Print Area that doesn't start at the top of the page.

    Started by mstoto‎, 08-20-2014 11:53 AM
    3 Attachment(s)
    • 11
    • 1,216
    mstoto
    08-29-2014, 05:28 AM Go to last post

  41. Formula to calculate # of hours based on date range and employee ID code

    Started by r0man3‎, 09-02-2014 11:57 AM
    1 Attachment(s)
    • 11
    • 1,075
    Tony Valko
    09-02-2014, 08:04 PM Go to last post

  42. Filling in matching info in blank cell offset

    Started by lunaraven‎, 09-02-2014 08:21 PM
    fill blanks, match, offset, skip 2 Attachment(s)
    • 11
    • 1,001
    AlKey
    09-03-2014, 08:27 AM Go to last post

  43. [SOLVED] Counting how many times a range of key words come up in a range of cells

    Started by Piepongwong‎, 09-04-2014 10:58 AM
    1 Attachment(s)
    • 11
    • 801
    XOR LX
    09-04-2014, 02:38 PM Go to last post

  44. Calculating a cost using the information in 2 colums

    Started by dwalters‎, 01-28-2016 05:22 AM
    2 Attachment(s)
    • 11
    • 853
    BadlySpelledBuoy
    01-28-2016, 01:22 PM Go to last post

  45. HOUR function in a COUNTIF

    Started by rojamilo123‎, 01-29-2016 05:05 AM
    countif, date, hour, ifs 1 Attachment(s)
    • 11
    • 2,378
    Kaper
    02-08-2016, 01:11 PM Go to last post

  46. Post Index Match with Two Criteria, Mix of Multiple Correct Rows and Greater than Rows

    Started by hochpoch‎, 01-31-2016 04:31 PM
    1 Attachment(s)
    • 11
    • 1,632
    hochpoch
    02-01-2016, 04:58 PM Go to last post

  47. [SOLVED] INDEX Array Formula with multiple criteria in multiple columns, is it possible?

    Started by jparve3283‎, 02-01-2016 08:00 PM
    2 Attachment(s)
    • 11
    • 957
    Tony Valko
    02-11-2016, 05:51 PM Go to last post

  48. Use text string as formula

    Started by goranimo‎, 02-04-2016 05:25 AM
    • 11
    • 729
    sandy666
    02-04-2016, 09:24 AM Go to last post

  49. Combining Excel columns

    Started by oball23‎, 02-04-2016 02:03 PM
    breaks, excel, formula 1 Attachment(s)
    • 11
    • 926
    oball23
    02-05-2016, 05:44 PM Go to last post

  50. Resize Range - Macro

    Started by Danny‎, 10-20-2005 03:05 PM
    • 11
    • 3,249
    Dave Peterson
    10-21-2005, 08:05 PM Go to last post
+ Post New Thread
Page 451 of 5614 FirstFirst ... 451 ...

Forum Information and Options

Users Browsing this Forum

There are currently 66 users browsing this forum. (3 members & 63 guests)

  1. dbyler,
  2. Rick Rothstein,
  3. rockson78

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