+ Post New Thread
Page 1 of 5610 1 ...
Threads 1 to 50 of 280471

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

  1. If a cell contains a certain text then put a specified text in another cell?

    Started by theblade24‎, 09-06-2007 12:38 PM
    1 Attachment(s)
    • 23
    • 362,962
    protonLeah
    04-17-2018, 11:52 PM Go to last post

  2. If cell contains...

    Started by Tim Sampson‎, 02-16-2005 10:57 AM
    • 10
    • 359,608
    daddylonglegs
    09-10-2009, 03:17 PM Go to last post

  3. Count Distinct Values?

    Started by bill_morgan‎, 04-26-2005 08:06 AM
    • 8
    • 309,648
    bill_morgan
    04-26-2005, 10:06 PM Go to last post

  4. [SOLVED] Remove leading space

    Started by Karidre‎, 10-24-2005 12:05 AM
    • 12
    • 257,559
    protonLeah
    06-05-2015, 12:18 AM Go to last post

  5. [SOLVED] howto select distinct values from list

    Started by chris‎, 04-16-2005 03:07 AM
    • 8
    • 245,347
    protonLeah
    06-05-2015, 12:16 AM Go to last post

  6. [SOLVED] HELP!! "Calculating 4 threads" nightmare problem!

    Started by jackblack2‎, 06-18-2018 04:23 PM
    • 73
    • 213,212
    AliGW
    02-05-2024, 10:48 AM Go to last post

  7. Question If between function...

    Started by killertofu‎, 08-16-2006 09:19 PM
    • 12
    • 205,196
    FDibbins
    08-14-2015, 01:47 PM Go to last post

  8. how to get the name of the sheet in a cell?

    Started by Alexandra‎, 08-27-2005 04:56 AM
    • 158
    • 192,633
    phoenixtiger
    02-11-2014, 09:53 AM Go to last post

  9. [SOLVED] How do I find address of cell containing maximum value

    Started by Doug‎, 08-29-2005 06:05 PM
    • 13
    • 189,345
    Figment
    04-14-2008, 09:17 AM Go to last post

  10. Calculate the CAGR

    Started by Bruce‎, 06-07-2005 06:05 AM
    • 6
    • 184,345
    N Harkawat
    06-07-2005, 10:05 AM Go to last post

  11. Creating a macro to find and replace text

    Started by Louise‎, 06-07-2005 10:05 AM
    • 17
    • 171,030
    Fotis1991
    06-27-2014, 05:18 AM Go to last post

  12. [SOLVED] How to Calculate ANTILOG in EXCEL SHEET?

    Started by Parag‎, 03-31-2006 06:55 AM
    • 4
    • 170,283
    mkershaw
    01-29-2015, 12:49 AM Go to last post

  13. Exclamation Using color coding in a drop down menu.

    Started by Glossgurl7‎, 02-12-2008 11:19 AM
    1 Attachment(s)
    • 15
    • 167,386
    protonLeah
    07-23-2015, 05:36 PM Go to last post

  14. [SOLVED] How to calculate an inverse of log base 10

    Started by Mike Middleton‎, 09-06-2005 01:05 AM
    • 2
    • 165,825
    Abdul Basit
    09-06-2005, 07:05 AM Go to last post

  15. [SOLVED] can't delete worksheet--grayed out!

    Started by TDiesel216‎, 04-30-2006 12:25 PM
    • 12
    • 165,008
    omkarve
    05-20-2015, 02:40 AM Go to last post

  16. How to convert date/time to seconds

    Started by [email protected]‎, 08-18-2006 07:30 PM
    • 2
    • 164,410
    Pete_UK
    08-18-2006, 08:30 PM Go to last post

  17. Find the first value in a row greater than zero

    Started by Algeraist‎, 04-09-2009 01:35 AM
    • 13
    • 160,989
    sktneer
    01-16-2020, 10:34 PM Go to last post

  18. SUMIF not working properly

    Started by opeyemi1‎, 01-08-2010 05:49 PM
    2 Attachment(s)
    • 13
    • 159,121
    Fotis1991
    12-11-2018, 08:29 AM Go to last post

  19. [SOLVED] calculate number of days between a date and today

    Started by South texas man‎, 05-18-2006 07:40 PM
    • 9
    • 157,962
    Joe Wilson
    02-20-2020, 04:58 PM Go to last post

  20. Exclamation Round to nearest 100?

    Started by twixthecat‎, 10-29-2010 12:36 PM
    • 6
    • 156,622
    littledobby
    09-01-2014, 05:10 PM Go to last post

  21. add a character to every cell

    Started by pikaz‎, 07-23-2007 04:07 PM
    • 6
    • 153,925
    Pete_UK
    08-25-2015, 12:16 PM Go to last post

  22. Exclamation Insert CheckBox

    Started by vbehler‎, 04-22-2007 09:31 PM
    • 1
    • 153,592
    Paul
    04-23-2007, 10:04 PM Go to last post

  23. Date Function: How to convert MM-DD-YYYY to DD-MM-YYYY

    Started by ramki‎, 06-07-2008 08:09 AM
    • 7
    • 145,511
    FDibbins
    04-23-2014, 12:03 AM Go to last post

  24. Value if "Today" greater than stated Date

    Started by knowtrump‎, 04-04-2008 11:29 AM
    • 5
    • 140,441
    Pete_UK
    03-17-2013, 02:37 PM Go to last post

  25. Concatenate to form a hyperlink

    Started by CPixie‎, 04-14-2008 05:12 PM
    • 7
    • 138,351
    bizwizkid
    02-16-2010, 11:18 PM Go to last post

  26. [SOLVED] sum formula equals zero

    Started by bpeltzer‎, 09-06-2005 12:05 AM
    • 6
    • 136,915
    Wegener
    10-23-2013, 04:10 PM Go to last post

  27. [SOLVED] count if not equal to zero

    Started by ellebelle‎, 06-23-2005 05:05 AM
    • 13
    • 136,729
    Homestar333
    04-12-2012, 05:19 PM Go to last post

  28. SumProduct IF

    Started by jpx‎, 03-23-2009 01:09 PM
    • 9
    • 132,722
    huyle2103
    08-24-2015, 10:36 AM Go to last post

  29. SUMIF function - can it sum multiple columns

    Started by sarabella‎, 04-21-2008 02:52 PM
    • 6
    • 131,722
    huyle2103
    08-20-2015, 08:56 AM Go to last post

  30. [SOLVED] how do I use vlookup for multiple occurrences of the same value

    Started by Edith F‎, 04-27-2005 07:06 PM
    2 Attachment(s)
    • 18
    • 126,225
    paulmli
    10-13-2011, 06:37 PM Go to last post

  31. Plus minus symbol

    Started by cecy_agr‎, 09-06-2013 06:59 PM
    excel for mac, excel for mac 2011, links to cells, new here, plus minus symbol
    • 17
    • 125,164
    SeaJay87
    10-02-2018, 09:39 PM Go to last post

  32. Extract number from alphanumeric string

    Started by laichiwai‎, 01-20-2008 04:35 PM
    • 11
    • 120,929
    shg
    01-12-2010, 01:40 AM Go to last post

  33. Formula to change font color

    Started by logan_fernandes‎, 01-17-2010 01:39 PM
    2 Attachment(s)
    • 15
    • 119,899
    Mriley13
    11-05-2013, 11:58 AM Go to last post

  34. Extracting Month and Year from Date

    Started by aquinn_21‎, 05-02-2007 06:06 AM
    • 5
    • 119,480
    hemesh
    01-27-2016, 06:37 PM Go to last post

  35. [SOLVED] Round up to nearest quarter

    Started by Dunderlin‎, 11-16-2006 08:18 AM
    • 13
    • 119,286
    davesexcel
    06-04-2018, 10:08 AM Go to last post

  36. COUNTIF AND Statement

    Started by LLori998‎, 10-11-2007 05:37 PM
    • 11
    • 117,730
    arthurbr
    09-01-2011, 07:17 AM Go to last post

  37. how do i add 1 year to a date formatted cell?

    Started by rogerm‎, 09-03-2005 08:05 PM
    • 7
    • 117,490
    Sam Capricci
    03-21-2019, 02:29 PM Go to last post

  38. Convert bytes to gigabytes

    Started by mandg‎, 08-07-2007 01:35 PM
    • 3
    • 116,231
    yacoubi
    09-16-2010, 05:02 AM Go to last post

  39. Calculating time difference

    Started by TomBP‎, 09-29-2006 04:17 AM
    • 7
    • 115,260
    oldchippy
    09-02-2010, 04:59 AM Go to last post

  40. Find cell address within a table?

    Started by Sean Anderson‎, 03-03-2007 03:09 PM
    • 17
    • 114,695
    shg
    09-02-2010, 01:41 PM Go to last post

  41. [SOLVED] Remove Hidden Characters in Excel

    Started by jameskinguk‎, 05-09-2013 10:10 AM
    hidden characters 3 Attachment(s)
    • 13
    • 113,701
    JohnTopley
    04-15-2022, 06:02 AM Go to last post

  42. [SOLVED] How do I figure out a pre-tax amount when I know the final total?

    Started by amk005‎, 05-27-2006 05:35 PM
    • 8
    • 113,414
    DawieP
    06-15-2020, 11:46 AM Go to last post

  43. Can I use IF function in calculated fields in a pivot table?

    Started by Bloke in Excel Trouble‎, 04-16-2006 12:55 AM
    • 2
    • 111,527
    Charles Williams
    04-16-2006, 04:50 AM Go to last post

  44. Remove Specific Characters From Text Cell

    Started by chasfh‎, 04-19-2010 09:59 AM
    • 6
    • 111,237
    jik_ff
    03-18-2014, 10:38 AM Go to last post

  45. [SOLVED] Conditional Formatting - Thick Border?

    Started by fedude‎, 05-17-2006 03:35 PM
    • 11
    • 111,124
    spenlinhauer
    04-03-2023, 01:17 PM Go to last post

  46. Pull same cell from multiple sheets into master column

    Started by mattminiat‎, 04-08-2010 01:02 PM
    excel 07, master worksheet, multiple sheets, same cell, same column
    • 9
    • 110,832
    Floooo
    10-13-2022, 12:40 PM Go to last post

  47. Unhappy [SOLVED] CTRL+SHIFT+ENTER array formula not working

    Started by frusterated‎, 09-01-2012 11:21 AM
    array, cse, ctrl+shift+enter, does not work, not working
    • 4
    • 110,802
    frusterated
    09-05-2012, 12:02 AM Go to last post

  48. Formula to minus VAT at 20%

    Started by EmStar‎, 11-06-2012 09:41 AM
    • 15
    • 110,149
    Glenn Kennedy
    09-16-2023, 05:19 AM Go to last post

  49. [SOLVED] What does the symbol ^ mean in Excel formulas?

    Started by Desert Rat‎, 02-11-2006 08:10 AM
    • 7
    • 109,881
    HaHoBe
    03-25-2013, 03:04 PM Go to last post

  50. Unhappy How to match values in one column to values in another?

    Started by trib‎, 07-24-2006 02:10 AM
    1 Attachment(s)
    • 7
    • 107,140
    PvtBeaker
    11-28-2013, 01:45 PM Go to last post
+ Post New Thread
Page 1 of 5610 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 89 users browsing this forum. (6 members & 83 guests)

  1. chen777,
  2. ExcelHelp72,
  3. Fusionista,
  4. JeteMc,
  5. jharvey87

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