+ Post New Thread
Page 1 of 5604 1 2 3 11 51 101 501 1001 ...
Threads 1 to 50 of 280188

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,757
    10-10-2007, 11:36 AM Go to last post
    • 23
    • 362,866
    04-17-2018, 11:52 PM Go to last post
  1. [SOLVED] If cell contains...

    Started by Tim Sampson‎, 02-16-2005 10:57 AM
    • 10
    • 359,601
    09-10-2009, 03:17 PM Go to last post
  2. [SOLVED] Count Distinct Values?

    Started by bill_morgan‎, 04-26-2005 08:06 AM
    • 8
    • 309,597
    04-26-2005, 10:06 PM Go to last post
  3. Remove leading space

    Started by Karidre‎, 10-24-2005 12:05 AM
    • 12
    • 257,535
    06-05-2015, 12:18 AM Go to last post
  4. [SOLVED] howto select distinct values from list

    Started by chris‎, 04-16-2005 03:07 AM
    • 8
    • 245,342
    06-05-2015, 12:16 AM Go to last post
  5. [SOLVED] HELP!! "Calculating 4 threads" nightmare problem!

    Started by jackblack2‎, 06-18-2018 04:23 PM
    • 73
    • 211,647
    02-05-2024, 10:48 AM Go to last post
  6. Question If between function...

    Started by killertofu‎, 08-16-2006 09:19 PM
    • 12
    • 205,173
    08-14-2015, 01:47 PM Go to last post
  7. how to get the name of the sheet in a cell?

    Started by Alexandra‎, 08-27-2005 04:56 AM
    • 158
    • 192,616
    02-11-2014, 09:53 AM Go to last post
  8. [SOLVED] [SOLVED] How do I find address of cell containing maximum value

    Started by Doug‎, 08-29-2005 06:05 PM
    • 13
    • 189,287
    04-14-2008, 09:17 AM Go to last post
  9. [SOLVED] Calculate the CAGR

    Started by Bruce‎, 06-07-2005 06:05 AM
    • 6
    • 184,339
    06-07-2005, 10:05 AM Go to last post
  10. Creating a macro to find and replace text

    Started by Louise‎, 06-07-2005 10:05 AM
    • 17
    • 171,015
    06-27-2014, 05:18 AM Go to last post
  11. How to Calculate ANTILOG in EXCEL SHEET?

    Started by Parag‎, 03-31-2006 06:55 AM
    • 4
    • 170,226
    01-29-2015, 12:49 AM Go to last post
  12. Exclamation Using color coding in a drop down menu.

    Started by Glossgurl7‎, 02-12-2008 11:19 AM
    • 15
    • 167,366
    07-23-2015, 05:36 PM Go to last post
  13. [SOLVED] How to calculate an inverse of log base 10

    Started by Mike Middleton‎, 09-06-2005 01:05 AM
    • 2
    • 165,363
    09-06-2005, 07:05 AM Go to last post
  14. [SOLVED] can't delete worksheet--grayed out!

    Started by TDiesel216‎, 04-30-2006 12:25 PM
    • 12
    • 164,943
    05-20-2015, 02:40 AM Go to last post
  15. How to convert date/time to seconds

    Started by [email protected]‎, 08-18-2006 07:30 PM
    • 2
    • 164,380
    08-18-2006, 08:30 PM Go to last post
  16. Find the first value in a row greater than zero

    Started by Algeraist‎, 04-09-2009 01:35 AM
    • 13
    • 160,118
    01-16-2020, 10:34 PM Go to last post
  17. SUMIF not working properly

    Started by opeyemi1‎, 01-08-2010 05:49 PM
    • 13
    • 158,754
    12-11-2018, 08:29 AM Go to last post
  18. [SOLVED] calculate number of days between a date and today

    Started by South texas man‎, 05-18-2006 07:40 PM
    • 9
    • 157,921
    02-20-2020, 04:58 PM Go to last post
  19. Exclamation Round to nearest 100?

    Started by twixthecat‎, 10-29-2010 12:36 PM
    • 6
    • 156,561
    09-01-2014, 05:10 PM Go to last post
  20. add a character to every cell

    Started by pikaz‎, 07-23-2007 04:07 PM
    • 6
    • 153,911
    08-25-2015, 12:16 PM Go to last post
  21. Exclamation Insert CheckBox

    Started by vbehler‎, 04-22-2007 09:31 PM
    • 1
    • 153,573
    04-23-2007, 10:04 PM Go to last post
  22. Date Function: How to convert MM-DD-YYYY to DD-MM-YYYY

    Started by ramki‎, 06-07-2008 08:09 AM
    • 7
    • 145,301
    04-23-2014, 12:03 AM Go to last post
  23. Value if "Today" greater than stated Date

    Started by knowtrump‎, 04-04-2008 11:29 AM
    • 5
    • 140,012
    03-17-2013, 02:37 PM Go to last post
  24. Concatenate to form a hyperlink

    Started by CPixie‎, 04-14-2008 05:12 PM
    • 7
    • 137,900
    02-16-2010, 11:18 PM Go to last post
  25. [SOLVED] sum formula equals zero

    Started by bpeltzer‎, 09-06-2005 12:05 AM
    • 6
    • 136,858
    10-23-2013, 04:10 PM Go to last post
  26. count if not equal to zero

    Started by ellebelle‎, 06-23-2005 05:05 AM
    • 13
    • 136,721
    04-12-2012, 05:19 PM Go to last post
  27. SumProduct IF

    Started by jpx‎, 03-23-2009 01:09 PM
    • 9
    • 132,715
    08-24-2015, 10:36 AM Go to last post
  28. SUMIF function - can it sum multiple columns

    Started by sarabella‎, 04-21-2008 02:52 PM
    • 6
    • 131,706
    08-20-2015, 08:56 AM Go to last post
  29. [SOLVED] how do I use vlookup for multiple occurrences of the same value

    Started by Edith F‎, 04-27-2005 07:06 PM
    • 18
    • 126,221
    10-13-2011, 06:37 PM Go to last post
  30. 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,144
    10-02-2018, 09:39 PM Go to last post
  31. Extract number from alphanumeric string

    Started by laichiwai‎, 01-20-2008 04:35 PM
    • 11
    • 120,920
    01-12-2010, 01:40 AM Go to last post
  32. Formula to change font color

    Started by logan_fernandes‎, 01-17-2010 01:39 PM
    • 15
    • 119,894
    11-05-2013, 11:58 AM Go to last post
  33. Extracting Month and Year from Date

    Started by aquinn_21‎, 05-02-2007 06:06 AM
    • 5
    • 119,429
    01-27-2016, 06:37 PM Go to last post
  34. [SOLVED] Round up to nearest quarter

    Started by Dunderlin‎, 11-16-2006 08:18 AM
    • 13
    • 118,505
    06-04-2018, 10:08 AM Go to last post
  35. COUNTIF AND Statement

    Started by LLori998‎, 10-11-2007 05:37 PM
    • 11
    • 117,726
    09-01-2011, 07:17 AM Go to last post
  36. [SOLVED] how do i add 1 year to a date formatted cell?

    Started by rogerm‎, 09-03-2005 08:05 PM
    • 7
    • 117,463
    03-21-2019, 02:29 PM Go to last post
  37. Convert bytes to gigabytes

    Started by mandg‎, 08-07-2007 01:35 PM
    • 3
    • 116,168
    09-16-2010, 05:02 AM Go to last post
  38. Calculating time difference

    Started by TomBP‎, 09-29-2006 04:17 AM
    • 7
    • 115,256
    09-02-2010, 04:59 AM Go to last post
  39. Find cell address within a table?

    Started by Sean Anderson‎, 03-03-2007 03:09 PM
    • 17
    • 114,643
    09-02-2010, 01:41 PM Go to last post
  40. [SOLVED] Remove Hidden Characters in Excel

    Started by jameskinguk‎, 05-09-2013 10:10 AM
    • 13
    • 113,322
    04-15-2022, 06:02 AM Go to last post
  41. [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,304
    06-15-2020, 11:46 AM Go to last post
    • 2
    • 111,499
    04-16-2006, 04:50 AM Go to last post
  42. Remove Specific Characters From Text Cell

    Started by chasfh‎, 04-19-2010 09:59 AM
    • 6
    • 111,232
    03-18-2014, 10:38 AM Go to last post
  43. 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,733
    09-05-2012, 12:02 AM Go to last post
  44. Conditional Formatting - Thick Border?

    Started by fedude‎, 05-17-2006 03:35 PM
    • 11
    • 110,545
    04-03-2023, 01:17 PM Go to last post
    • 9
    • 109,893
    10-13-2022, 12:40 PM Go to last post
  45. [SOLVED] What does the symbol ^ mean in Excel formulas?

    Started by Desert Rat‎, 02-11-2006 08:10 AM
    • 7
    • 109,719
    03-25-2013, 03:04 PM Go to last post
  46. Formula to minus VAT at 20%

    Started by EmStar‎, 11-06-2012 09:41 AM
    • 15
    • 109,633
    09-16-2023, 05:19 AM Go to last post
  47. Unhappy How to match values in one column to values in another?

    Started by trib‎, 07-24-2006 02:10 AM
    • 7
    • 107,112
    11-28-2013, 01:45 PM Go to last post

+ Post New Thread
Page 1 of 5604 1 2 3 11 51 101 501 1001 ...

Forum Information and Options

Users Browsing this Forum

There are currently 86 users browsing this forum. (6 members & 80 guests)

  1. atreus,
  2. ExcelDavid5,
  3. j bliss,
  4. LVHNJames,
  5. rizwanulhasan,
  6. stefan.g

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1