+ Post New Thread
Page 1 of 5611 1 ...
Threads 1 to 50 of 280524

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,844
    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,983
    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,610
    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,659
    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,560
    protonLeah
    06-05-2015, 12:18 AM Go to last post

  5. howto select distinct values from list

    Started by chris‎, 04-16-2005 03:07 AM
    • 8
    • 245,361
    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,470
    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,634
    phoenixtiger
    02-11-2014, 09:53 AM Go to last post

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

    Started by Doug‎, 08-29-2005 06:05 PM
    • 13
    • 189,353
    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,034
    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,295
    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,387
    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,900
    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,025
    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,426
    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
    • 161,164
    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,196
    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,967
    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,637
    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,593
    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,541
    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,507
    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,418
    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,929
    Wegener
    10-23-2013, 04:10 PM Go to last post

  27. count if not equal to zero

    Started by ellebelle‎, 06-23-2005 05:05 AM
    • 13
    • 136,730
    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,725
    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,226
    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,169
    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,932
    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,495
    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,424
    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,494
    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,239
    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,698
    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,768
    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,436
    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,533
    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,226
    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
    • 111,026
    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,810
    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,260
    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,895
    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,147
    PvtBeaker
    11-28-2013, 01:45 PM Go to last post
+ Post New Thread
Page 1 of 5611 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 90 users browsing this forum. (3 members & 87 guests)

  1. felixrioux13,
  2. pbruyere

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