+ Post New Thread
Page 1 of 5614 1 ...
Threads 1 to 50 of 280668

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,899
    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
    • 363,047
    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,613
    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,686
    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,577
    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,458
    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
    • 214,140
    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,198
    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,642
    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,368
    Figment
    04-14-2008, 09:17 AM Go to last post

  10. [SOLVED] Calculate the CAGR

    Started by Bruce‎, 06-07-2005 06:05 AM
    • 6
    • 184,348
    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,045
    Fotis1991
    06-27-2014, 05:18 AM Go to last post

  12. How to Calculate ANTILOG in EXCEL SHEET?

    Started by Parag‎, 03-31-2006 06:55 AM
    • 4
    • 170,321
    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,411
    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
    • 166,120
    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,056
    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,442
    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,681
    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,360
    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,978
    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,663
    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,926
    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,594
    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,629
    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,679
    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,609
    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,958
    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,733
    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,730
    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,732
    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,237
    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,180
    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,936
    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,908
    Mriley13
    11-05-2013, 11:58 AM Go to last post

  34. [SOLVED] Round up to nearest quarter

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

  35. Extracting Month and Year from Date

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

  36. COUNTIF AND Statement

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

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

    Started by rogerm‎, 09-03-2005 08:05 PM
    • 7
    • 117,516
    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,262
    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,266
    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,711
    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,921
    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,484
    DawieP
    06-15-2020, 11:46 AM Go to last post

  43. [SOLVED] Conditional Formatting - Thick Border?

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

  44. 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,549
    Charles Williams
    04-16-2006, 04:50 AM Go to last post

  45. 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,463
    Floooo
    10-13-2022, 12:40 PM Go to last post

  46. Remove Specific Characters From Text Cell

    Started by chasfh‎, 04-19-2010 09:59 AM
    • 6
    • 111,251
    jik_ff
    03-18-2014, 10:38 AM 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,836
    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,511
    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,943
    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,239
    PvtBeaker
    11-28-2013, 01:45 PM Go to last post
+ Post New Thread
Page 1 of 5614 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 67 users browsing this forum. (5 members & 62 guests)

  1. ExcelNewbie92,
  2. jlesco89,
  3. Kaper,
  4. LawsonC

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