+ Post New Thread
Page 11 of 5611 FirstFirst ... 11 ...
Threads 501 to 550 of 280545

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. [SOLVED] vlookup on pivot table results = #N/A

    Started by Louis‎, 05-24-2006 11:50 AM
    • 4
    • 32,098
    Louis
    05-24-2006, 05:20 PM Go to last post

  2. Talking extracting numbers from alphanumeric strings

    Started by brockk‎, 08-16-2008 08:22 AM
    • 25
    • 32,098
    aasunshine
    08-22-2016, 10:43 PM Go to last post

  3. tertiles

    Started by Sriram‎, 07-02-2006 08:55 PM
    • 2
    • 32,064
    [email protected]
    07-03-2006, 06:50 AM Go to last post

  4. How to average a set of values but ignore zero and error values (#N/A)?

    Started by klchoy‎, 11-17-2006 06:01 AM
    • 7
    • 32,060
    klchoy
    11-17-2006, 08:02 AM Go to last post

  5. PPk calculation in Excel

    Started by gsweta‎, 09-08-2009 03:25 PM
    • 2
    • 32,051
    Paul
    09-08-2009, 03:51 PM Go to last post

  6. [SOLVED] Autocalculate Age from Identity Card Number

    Started by suriawati‎, 01-04-2012 05:15 AM
    autocalculate age 5 Attachment(s)
    • 13
    • 32,018
    TMS
    02-13-2017, 08:26 AM Go to last post

  7. Replace part of a cell (first two digits)

    Started by mattandrew‎, 11-21-2007 07:27 AM
    • 12
    • 31,987
    mattandrew
    11-21-2007, 10:49 AM Go to last post

  8. Question if statement using left and right conditions

    Started by Set_Shot_Dave‎, 02-16-2010 04:11 PM
    if statement
    • 5
    • 31,912
    FlameRetired
    07-22-2021, 04:18 PM Go to last post

  9. Telling excel to ignore blank cells in SUM formulas

    Started by rugbyfitz‎, 07-21-2008 10:27 AM
    • 2
    • 31,895
    olasa
    07-21-2008, 01:08 PM Go to last post

  10. Excel 2007 : SUMIF with 2 criteria

    Started by pansovic‎, 08-30-2010 06:58 PM
    2 Attachment(s)
    • 10
    • 31,782
    Nono Lara
    04-21-2013, 05:42 PM Go to last post

  11. COUNTIF for greater than a cell's value

    Started by SueWithQuestion‎, 04-14-2010 02:23 PM
    1 Attachment(s)
    • 2
    • 31,776
    SueWithQuestion
    04-15-2010, 07:16 AM Go to last post

  12. how do i link to a pivot table to get data dynamically

    Started by Michael001‎, 02-22-2006 04:30 AM
    • 2
    • 31,765
    Michael001
    02-23-2006, 06:30 AM Go to last post

  13. [SOLVED] Remove duplicates without removing cells (leave blank)

    Started by RobertOHare‎, 07-10-2013 09:00 AM
    • 3
    • 31,725
    RobertOHare
    07-10-2013, 09:57 AM Go to last post

  14. [SOLVED] SumIf Font Color

    Started by spider_min‎, 02-12-2018 06:47 PM
    2 Attachment(s)
    • 6
    • 31,673
    jeffreybrown
    02-18-2020, 12:56 PM Go to last post

  15. split cell into two cells

    Started by Jaymond Flurrie‎, 09-17-2007 02:41 AM
    • 5
    • 31,664
    Jaymond Flurrie
    09-17-2007, 08:06 AM Go to last post

  16. how do I make an excel comment box bigger?

    Started by Shel‎, 05-17-2006 10:30 PM
    • 5
    • 31,662
    Andy Pope
    05-18-2006, 12:45 PM Go to last post

  17. Paste Values Keyboard Shortcut Key Combo???

    Started by Bradley Bland‎, 04-17-2007 12:30 PM
    • 4
    • 31,632
    Speshul
    08-26-2014, 08:30 AM Go to last post

  18. [SOLVED] Why can't I scroll down?

    Started by JenniLynne‎, 01-13-2006 06:25 PM
    • 3
    • 31,591
    JenniLynne
    01-13-2006, 06:50 PM Go to last post

  19. [SOLVED] can I execute and 'substring' function in Excel

    Started by Larry‎, 12-31-2005 02:50 AM
    • 4
    • 31,534
    Larry
    01-01-2006, 04:20 PM Go to last post

  20. Find First Occurrence Of A Value In A Range Of Cells And Return The Leftmost Column Value

    Started by jaelex‎, 03-22-2015 01:06 PM
    excel, find value, formulas in 2007, lookup 2 Attachment(s)
    • 6
    • 31,532
    jaelex
    03-23-2015, 07:17 AM Go to last post

  21. [SOLVED] VLOOKUP multiple results in a drop down list

    Started by tnfire‎, 02-12-2009 09:24 PM
    8 Attachment(s)
    • 23
    • 31,515
    gransjo
    07-14-2012, 12:31 PM Go to last post

  22. [SOLVED] Weighted Average Standard Deviation

    Started by kthenning‎, 10-01-2005 04:05 PM
    • 4
    • 31,498
    [email protected]
    10-02-2005, 12:05 PM Go to last post

  23. extract year from the date in a cell

    Started by DKY‎, 03-16-2006 02:45 PM
    • 7
    • 31,486
    Bernard Liengme
    03-17-2006, 03:10 PM Go to last post

  24. allowing group/ungroup function in protected sheet

    Started by Elainefish‎, 06-14-2013 01:43 AM
    3 Attachment(s)
    • 11
    • 31,463
    Metrologistish
    03-13-2023, 02:05 PM Go to last post

  25. Line break using Concatenate

    Started by kys2000‎, 02-27-2007 04:27 PM
    • 3
    • 31,383
    oldchippy
    02-27-2007, 06:03 PM Go to last post

  26. Question VLOOKUP search from bottom to top ?

    Started by KASTEO‎, 06-04-2007 03:47 AM
    2 Attachment(s)
    • 10
    • 31,381
    arlu1201
    05-26-2012, 02:39 AM Go to last post

  27. VLOOKUP for multiple results

    Started by Steamboat‎, 04-27-2005 03:22 PM
    • 9
    • 31,352
    Ron Coderre
    04-29-2005, 10:27 PM Go to last post

  28. [SOLVED] formula to calculate MTBF and MTTR

    Started by watabe112‎, 12-06-2018 09:53 AM
    excel formula, mtbf, mttr 11 Attachment(s)
    • 40
    • 31,339
    AliGW
    01-19-2022, 10:10 AM Go to last post

  29. Angry Excel 2007 : IF functions with Date ranges

    Started by ortiz718‎, 04-30-2010 01:01 PM
    • 4
    • 31,338
    swapsarkar
    01-24-2014, 03:20 PM Go to last post

  30. Cumulative Sums in Pivot Tables

    Started by Laura‎, 01-10-2006 02:10 PM
    • 8
    • 31,298
    Roger Govier
    01-11-2006, 02:00 PM Go to last post

  31. [SOLVED] Using The Average Function if a cell has NA

    Started by carl‎, 01-10-2005 05:06 PM
    • 5
    • 31,268
    JE McGimpsey
    01-10-2005, 10:06 PM Go to last post

  32. Convert multiple columns to rows

    Started by Lois Lane‎, 01-09-2005 03:06 PM
    • 9
    • 31,260
    wael_abdelhamid
    10-13-2015, 03:05 AM Go to last post

  33. Remove middle name for end of a name string

    Started by maacmaac‎, 07-06-2011 02:04 PM
    1 Attachment(s)
    • 8
    • 31,260
    AliGW
    08-30-2022, 04:44 PM Go to last post

  34. [SOLVED] Data Validation: Phone Number

    Started by PolarX‎, 07-29-2013 11:32 AM
    data validation formula
    • 9
    • 31,252
    jeffreybrown
    07-29-2013, 12:49 PM Go to last post

  35. [SOLVED] how to copy an excel sheet from one xls to another without links

    Started by Anne‎, 03-17-2005 03:06 PM
    • 6
    • 31,167
    thx1138010101
    02-26-2014, 05:24 PM Go to last post

  36. SUMPRODUCT to exclude values?

    Started by tangcla‎, 09-28-2008 10:13 PM
    exclude, sumproduct, values
    • 5
    • 31,146
    AliGW
    01-29-2020, 09:16 AM Go to last post

  37. Index Match within a range!

    Started by sachinshah1‎, 09-18-2016 05:18 PM
    index, index match, match, vlookup 2 Attachment(s)
    • 10
    • 31,120
    FlameRetired
    07-10-2019, 10:20 PM Go to last post

  38. [SOLVED] alt+enter does not work

    Started by shazza‎, 09-22-2005 11:05 PM
    • 7
    • 31,087
    AliGW
    02-20-2021, 10:26 AM Go to last post

  39. Match function doesn't find BLANK cells?

    Started by ssudekum‎, 10-27-2009 09:53 PM
    match 1 Attachment(s)
    • 2
    • 31,077
    degaston
    01-31-2014, 07:35 PM Go to last post

  40. Concatenate TODAY() function

    Started by joodkap‎, 02-23-2010 02:48 PM
    • 2
    • 31,053
    joodkap
    02-23-2010, 02:52 PM Go to last post

  41. [SOLVED] How do I calculate the area under the curve using Excel?

    Started by munster909‎, 09-06-2005 02:05 AM
    • 1
    • 30,999
    munster909
    09-06-2005, 02:05 AM Go to last post

  42. [SOLVED] How Many Times Can a Number Go Into Another Number

    Started by djfatboyfats‎, 10-10-2012 07:56 AM
    • 3
    • 30,993
    djfatboyfats
    10-10-2012, 08:32 AM Go to last post

  43. [SOLVED] how to make a formula ignore blank cells

    Started by Snap‎, 06-05-2006 08:25 PM
    • 6
    • 30,973
    MyVeryOwnSelf
    06-07-2006, 08:00 PM Go to last post

  44. Solver Binary Contraints problem

    Started by Rick Kaullen‎, 07-06-2006 02:45 PM
    • 1
    • 30,961
    Tushar Mehta
    07-08-2006, 10:15 AM Go to last post

  45. Error: The number in this cell is formatted as text or preceded by an apostrophe?

    Started by ks100‎, 09-12-2013 11:22 AM
    • 8
    • 30,954
    Fayyaz Ahmed
    10-01-2017, 02:09 PM Go to last post

  46. Adding Military time formula

    Started by Homeuser66‎, 03-10-2007 12:08 AM
    1 Attachment(s)
    • 7
    • 30,947
    Homeuser66
    01-20-2014, 03:04 PM Go to last post

  47. SumIf by day of the week.

    Started by GeoffCJ‎, 07-17-2007 04:41 PM
    • 5
    • 30,880
    GeoffCJ
    07-17-2007, 06:03 PM Go to last post

  48. Wanting to copy cells if condition is met

    Started by terisab12‎, 12-08-2016 12:10 PM
    copy & paste from sheets, excel 2013, if function
    • 2
    • 30,800
    Pete_UK
    12-08-2016, 12:29 PM Go to last post

  49. [SOLVED] sumif with multiple sum range

    Started by Vivek2705‎, 12-01-2018 05:48 AM
    mutiple sum ranges, sumif
    • 3
    • 30,800
    Bo_Ry
    12-01-2018, 06:25 AM Go to last post

  50. vlookup question, if N/A then = 0???

    Started by txbullets‎, 11-29-2007 11:39 AM
    • 3
    • 30,772
    txbullets
    11-29-2007, 12:30 PM Go to last post
+ Post New Thread
Page 11 of 5611 FirstFirst ... 11 ...

Forum Information and Options

Users Browsing this Forum

There are currently 99 users browsing this forum. (6 members & 93 guests)

  1. alansidman,
  2. JohnTopley,
  3. Martin Aston,
  4. paulma1960,
  5. rjj920,
  6. Shaybay01

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