+ Post New Thread
Page 1001 of 5611 FirstFirst ... 1001 ...
Threads 50001 to 50050 of 280532

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

  1. slope of a line (x coefficient of trend line ) in chart & coordinate

    Started by fakhteh‎, 05-01-2020 01:27 PM
    3 Attachment(s)
    • 7
    • 576
    JeteMc
    05-11-2020, 05:44 PM Go to last post

  2. Produce multiple lists from one list

    Started by buzzbee‎, 10-03-2016 08:44 AM
    1 Attachment(s)
    • 7
    • 508
    Tony Valko
    10-05-2016, 11:17 AM Go to last post

  3. Conditional Formatting help - Highlighting row containing text

    Started by doc flash‎, 10-05-2016 09:01 AM
    conditional formatting, contains a certain word, highlight entire row 7 Attachment(s)
    • 7
    • 678
    doc flash
    10-20-2016, 07:05 AM Go to last post

  4. Question Calculate the Week in the quarter using Fiscal week and a Date

    Started by dalfane177‎, 10-12-2016 10:11 AM
    • 7
    • 3,264
    Glenn Kennedy
    10-14-2016, 04:09 PM Go to last post

  5. Finding missing values of a list

    Started by forestavekids‎, 10-13-2016 05:11 PM
    1 Attachment(s)
    • 7
    • 538
    Tony Valko
    10-13-2016, 05:52 PM Go to last post

  6. [SOLVED] Search list for cell value, return or highlight cells that contain value

    Started by dusty90‎, 10-16-2016 08:41 PM
    3 Attachment(s)
    • 7
    • 538
    jeffreybrown
    10-16-2016, 09:40 PM Go to last post

  7. [SOLVED] Need a workable IFAND function formula for multiple criteria or maybe an Array formula?

    Started by jeptik‎, 10-18-2016 09:19 AM
    1 Attachment(s)
    • 7
    • 604
    JohnTopley
    10-18-2016, 02:13 PM Go to last post

  8. [SOLVED] Finding intersection value of specific row and column that match a certain value

    Started by Nikox9‎, 10-19-2016 11:44 AM
    index, match, offset 2 Attachment(s)
    • 7
    • 1,280
    AliGW
    10-20-2016, 02:48 AM Go to last post

  9. Better formula than combined Vlookup & Hlookup

    Started by lozg43‎, 10-19-2016 04:46 PM
    2 Attachment(s)
    • 7
    • 745
    FlameRetired
    10-20-2016, 03:30 PM Go to last post

  10. [SOLVED] Sumif or sumproduct formula for a rolling calendar

    Started by cartica‎, 10-21-2016 10:24 AM
    3 Attachment(s)
    • 7
    • 870
    cartica
    10-21-2016, 10:47 AM Go to last post

  11. [SOLVED] checking multiple rows for a string and copy alternate column data

    Started by esaji‎, 05-14-2020 09:56 AM
    3 Attachment(s)
    • 7
    • 290
    MRUTOR
    05-18-2020, 03:12 AM Go to last post

  12. Smile [SOLVED] Conditional format on timeline not working right

    Started by MattExcelLearner‎, 05-15-2020 07:00 AM
    3 Attachment(s)
    • 7
    • 442
    MattExcelLearner
    05-21-2020, 02:05 PM Go to last post

  13. Conditional Drop Down / Auto Fill Option - is this possible?

    Started by dgrissom‎, 05-01-2020 11:28 AM
    5 Attachment(s)
    • 7
    • 358
    Estevaoba
    05-12-2020, 06:41 PM Go to last post

  14. [SOLVED] Index Match Duplicate Values With No Helper Cells

    Started by Kerik‎, 11-21-2015 04:30 PM
    1 Attachment(s)
    • 7
    • 4,518
    AliGW
    05-23-2020, 11:28 AM Go to last post

  15. [SOLVED] Detecting schedule conflicts

    Started by shoefits‎, 05-03-2020 08:16 PM
    2 Attachment(s)
    • 7
    • 732
    JeteMc
    05-13-2020, 04:01 PM Go to last post

  16. [SOLVED] Conditional formatting Progress Bar if Date is in Cell

    Started by JTinKC‎, 05-06-2020 07:41 PM
    4 Attachment(s)
    • 7
    • 1,427
    6StringJazzer
    05-11-2020, 02:08 PM Go to last post

  17. [SOLVED] Time stamp overlap between two columns and identify such rows with "Yes"

    Started by kjaikishan‎, 05-09-2020 04:36 AM
    3 Attachment(s)
    • 7
    • 318
    PCI
    05-12-2020, 02:55 PM Go to last post

  18. [SOLVED] Index Match with 3 criteria

    Started by Limor_OP‎, 05-09-2020 06:03 PM
    3 Attachment(s)
    • 7
    • 272
    AliGW
    05-10-2020, 06:21 AM Go to last post

  19. [SOLVED] I'm trying to create a hyperlink that always points to the last worksheet in a workbook

    Started by ajbeam33‎, 05-09-2020 10:20 PM
    1 Attachment(s)
    • 7
    • 321
    AliGW
    05-10-2020, 09:26 AM Go to last post

  20. how to look up a name and return heading.

    Started by (T_T)‎, 05-11-2020 05:02 AM
    loockup, look up function 2 Attachment(s)
    • 7
    • 392
    (T_T)
    05-12-2020, 06:12 AM Go to last post

  21. [SOLVED] Reverse match values with a source table

    Started by cmav‎, 05-11-2020 06:45 AM
    1 Attachment(s)
    • 7
    • 358
    cmav
    05-11-2020, 11:37 AM Go to last post

  22. [SOLVED] How to Return nth Date of a Value Occuring in a Table

    Started by chasfh‎, 05-12-2020 01:49 PM
    1 Attachment(s)
    • 7
    • 306
    Limor_OP
    05-12-2020, 05:38 PM Go to last post

  23. [SOLVED] Aggregate Function-Multiple

    Started by chad328‎, 05-13-2020 08:03 AM
    2 Attachment(s)
    • 7
    • 252
    CK76
    05-13-2020, 08:28 AM Go to last post

  24. Formula to extract value for Region/Company

    Started by j21‎, 05-13-2020 05:38 PM
    2 Attachment(s)
    • 7
    • 419
    Fluff13
    05-15-2020, 10:02 AM Go to last post

  25. [SOLVED] days excluding off period

    Started by nd4spd‎, 05-14-2020 10:12 AM
    2 Attachment(s)
    • 7
    • 294
    Bo_Ry
    05-14-2020, 11:44 AM Go to last post

  26. Need to use ERFC in formula. Homework help, please!

    Started by nmwaggoner‎, 11-23-2012 11:19 AM
    2 Attachment(s)
    • 7
    • 633
    nmwaggoner
    11-23-2012, 08:54 PM Go to last post

  27. Date comparison

    Started by Darkdrew‎, 03-16-2006 05:10 PM
    • 7
    • 842
    Darkdrew
    03-23-2006, 12:25 PM Go to last post

  28. Take data from 1 cell to create a new cell

    Started by [email protected]‎, 03-10-2006 12:10 AM
    • 7
    • 432
    Biff
    03-17-2006, 07:30 PM Go to last post

  29. cell referencing

    Started by michaelkwc‎, 07-29-2008 02:06 AM
    • 7
    • 797
    michaelkwc
    09-09-2008, 05:41 AM Go to last post

  30. Delete everything before and after a "."

    Started by Slomaro2000‎, 09-02-2008 11:40 AM
    • 7
    • 593
    Slomaro2000
    09-02-2008, 02:17 PM Go to last post

  31. Countif with Merged Cells

    Started by Alexander_Read‎, 09-05-2008 06:28 AM
    3 Attachment(s)
    • 7
    • 30,039
    Alexander_Read
    09-08-2008, 07:29 AM Go to last post

  32. [SOLVED] Formula to return blank (no value) if no date available to calculate

    Started by DKAbi‎, 11-26-2012 04:29 PM
    1 Attachment(s)
    • 7
    • 519
    Moo the Dog
    11-26-2012, 04:50 PM Go to last post

  33. [SOLVED] combine SUMIF and SUMPRODUCT

    Started by brownn‎, 11-25-2012 10:35 PM
    sumproduct column sumif
    • 7
    • 11,684
    jeffreybrown
    11-25-2012, 11:16 PM Go to last post

  34. How can I use Countif based on the frequency of a certain column?

    Started by dcolceriu‎, 11-22-2012 04:41 AM
    4 Attachment(s)
    • 7
    • 667
    simeon.hruby
    11-22-2012, 05:44 PM Go to last post

  35. Cool [SOLVED] Embedding Image based on the calculation

    Started by jamesjessie117‎, 11-12-2012 03:47 AM
    4 Attachment(s)
    • 7
    • 572
    jamesjessie117
    11-22-2012, 02:11 AM Go to last post

  36. Cool [SOLVED] Matching multiple values from 1 worksheet to another worksheet

    Started by jamesjessie117‎, 11-20-2012 03:18 AM
    2 Attachment(s)
    • 7
    • 588
    dredwolf
    11-25-2012, 11:15 AM Go to last post

  37. [SOLVED] Remove Duplicate Text

    Started by Bharatdubole‎, 11-19-2012 05:00 AM
    1 Attachment(s)
    • 7
    • 508
    Bharatdubole
    11-21-2012, 04:53 AM Go to last post

  38. Question [SOLVED] What function to use to match a column against other and if matches value of another colum

    Started by kps01‎, 11-21-2012 03:07 AM
    excel fuction 2 Attachment(s)
    • 7
    • 591
    FDibbins
    11-22-2012, 02:56 AM Go to last post

  39. Question % Markup Issue

    Started by Tagliaboo‎, 05-11-2016 10:20 AM
    formula, markup, percentage, strange
    • 7
    • 902
    Tagliaboo
    10-19-2016, 03:37 PM Go to last post

  40. [SOLVED] SUMPRODUCT not working

    Started by User3‎, 10-01-2013 06:13 AM
    2 Attachment(s)
    • 7
    • 679
    User3
    10-01-2013, 06:31 AM Go to last post

  41. Vlookup for partial words

    Started by Elizabethd1012‎, 09-30-2013 12:44 PM
    1 Attachment(s)
    • 7
    • 1,214
    FDibbins
    09-30-2013, 07:02 PM Go to last post

  42. [SOLVED] Pulling data from a master list

    Started by Kevin Stewart‎, 09-24-2013 05:20 PM
    5 Attachment(s)
    • 7
    • 2,759
    xwarlock10x
    09-27-2013, 03:54 PM Go to last post

  43. [SOLVED] Sumproduct with multiple criteria

    Started by Groovicles‎, 09-26-2013 10:42 AM
    1 Attachment(s)
    • 7
    • 630
    JosephP
    09-27-2013, 10:41 AM Go to last post

  44. Lightbulb [SOLVED]Calculating Percent Complete on Dashboard with multiple dates

    Started by communistflamingo‎, 12-26-2014 01:39 PM
    excel, function help 1 Attachment(s)
    • 7
    • 1,455
    BadlySpelledBuoy
    12-26-2014, 02:45 PM Go to last post

  45. [SOLVED] Help with Countif

    Started by dreddster‎, 12-28-2014 07:40 PM
    2 Attachment(s)
    • 7
    • 533
    dreddster
    12-29-2014, 01:49 AM Go to last post

  46. [SOLVED] Alert Raises when repeat invoices is entered

    Started by brandedadnan‎, 12-30-2014 04:52 AM
    4 Attachment(s)
    • 7
    • 621
    brandedadnan
    12-30-2014, 05:51 AM Go to last post

  47. Looking for a formula that will give me the result. When entering customer account #

    Started by jerry1253‎, 12-30-2014 12:09 PM
    1 Attachment(s)
    • 7
    • 807
    FDibbins
    12-30-2014, 05:25 PM Go to last post

  48. Creating an If Statement to calculate another if statement

    Started by bbogner‎, 01-12-2015 04:09 PM
    • 7
    • 743
    JeteMc
    10-05-2016, 10:59 AM Go to last post

  49. Counter number automatic

    Started by R0CKY‎, 10-15-2016 05:18 PM
    4 Attachment(s)
    • 7
    • 652
    Richard Buttrey
    10-15-2016, 07:06 PM Go to last post

  50. [SOLVED] Calendar Control

    Started by Roleeb‎, 03-17-2006 02:30 PM
    • 7
    • 864
    Ron de Bruin
    03-19-2006, 05:20 AM Go to last post
+ Post New Thread
Page 1001 of 5611 FirstFirst ... 1001 ...

Forum Information and Options

Users Browsing this Forum

There are currently 82 users browsing this forum. (11 members & 71 guests)

  1. bohai,
  2. Daftattitude,
  3. DarrylBurge,
  4. dummy777,
  5. dxfoxd,
  6. finallymint,
  7. hawka100,
  8. samba_ravi,
  9. tungten9x,
  10. weishida

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