+ Post New Thread
Page 1 of 5613 1 ...
Threads 1 to 50 of 280638

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,875
    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,035
    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,612
    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,680
    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,571
    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,415
    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,008
    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,638
    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,364
    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,347
    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,043
    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,308
    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,403
    protonLeah
    07-23-2015, 05:36 PM Go to last post

  14. How to calculate an inverse of log base 10

    Started by Mike Middleton‎, 09-06-2005 01:05 AM
    • 2
    • 166,076
    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,052
    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,441
    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,559
    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,327
    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,974
    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,653
    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,618
    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,643
    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,558
    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,951
    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,731
    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,724
    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,729
    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,234
    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,177
    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,935
    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,904
    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,722
    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,518
    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,507
    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,255
    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,707
    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,893
    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,478
    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,548
    Charles Williams
    04-16-2006, 04:50 AM Go to last post

  44. [SOLVED] Conditional Formatting - Thick Border?

    Started by fedude‎, 05-17-2006 03:35 PM
    • 11
    • 111,488
    spenlinhauer
    04-03-2023, 01:17 PM 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,381
    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,245
    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,835
    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,452
    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,931
    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,200
    PvtBeaker
    11-28-2013, 01:45 PM Go to last post
+ Post New Thread
Page 1 of 5613 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 74 users browsing this forum. (4 members & 70 guests)

  1. finallymint,
  2. Gregb11,
  3. qsetya,
  4. 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