+ Post New Thread
Page 5 of 5619 FirstFirst ... 5 ...
Threads 201 to 250 of 280904

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

  1. How to make the cell or font color red if the number is negative?

    Started by Bob T‎, 01-05-2005 12:06 PM
    • 25
    • 49,702
    RODY
    09-06-2005, 07:05 PM Go to last post

  2. how do I find prime factors of a number

    Started by Jeff‎, 11-28-2005 10:30 PM
    2 Attachment(s)
    • 19
    • 49,695
    alansidman
    02-10-2024, 12:00 PM Go to last post

  3. Generating Automatic Serial Number in Excel

    Started by vajeehu‎, 08-15-2007 04:00 PM
    • 1
    • 49,543
    Ron Coderre
    08-15-2007, 04:11 PM Go to last post

  4. [SOLVED] What do { } brackets mean when they encompass a function?

    Started by BedeviledByBrackets‎, 06-20-2006 04:10 PM
    • 3
    • 49,533
    JMB
    06-20-2006, 10:40 PM Go to last post

  5. [SOLVED] Count cells based on color without VBA

    Started by Perk1961‎, 01-22-2016 03:21 PM
    2 Attachment(s)
    • 15
    • 49,456
    swvogt
    10-11-2017, 04:40 PM Go to last post

  6. [SOLVED] Using Countifs/Match/Index formula to count data in different columns

    Started by satania‎, 08-19-2014 03:34 PM
    1 Attachment(s)
    • 7
    • 49,341
    Sudhakarslr
    06-09-2023, 04:00 AM Go to last post

  7. [SOLVED] SUMIF (cell color)

    Started by snowb46‎, 01-25-2013 11:20 AM
    color as condition, sumif
    • 5
    • 49,291
    pgwatbok
    01-21-2014, 07:31 PM Go to last post

  8. Formula to calculate SLA by excluding non-business hours, weekends and holidays

    Started by [email protected]‎, 08-07-2013 09:10 AM
    • 9
    • 49,117
    FDibbins
    07-04-2016, 11:42 PM Go to last post

  9. How to use the Linear Interpolation Formula in Excel 2010

    Started by emmanuelsekimpi‎, 05-09-2013 02:35 AM
    • 1
    • 48,905
    XOR LX
    05-09-2013, 04:41 AM Go to last post

  10. Convert ASCII Character strings into HEX Strings

    Started by Chris Mathers‎, 03-04-2008 09:03 PM
    • 5
    • 48,871
    squiggler47
    11-13-2010, 12:25 PM Go to last post

  11. Copy cell copies correct formula, but displays incorrect values

    Started by willzzzzzzzz‎, 04-19-2010 11:13 AM
    • 4
    • 48,651
    GLEMCOPARTS
    06-10-2016, 05:28 PM Go to last post

  12. Roulette data

    Started by stephenhughes99‎, 08-24-2008 08:57 AM
    7 Attachment(s)
    • 28
    • 48,639
    AliGW
    11-19-2019, 04:04 AM Go to last post

  13. Convert text to date dd/mm/yyyy hh:mm:ss

    Started by Scottish2‎, 05-04-2007 03:50 AM
    • 5
    • 48,572
    daddylonglegs
    05-04-2007, 07:59 AM Go to last post

  14. Question IF to calculate if one date is greater than another

    Started by Tin‎, 11-18-2006 01:38 PM
    • 23
    • 48,470
    Tin
    11-18-2006, 06:19 PM Go to last post

  15. vLOOKUP returning #NA until I double click in the lookup value cell

    Started by Riehl‎, 08-15-2013 02:54 PM
    • 6
    • 48,281
    JohnTopley
    01-16-2018, 09:27 AM Go to last post

  16. decimal to 16 bits binary conversion in Excel?

    Started by xcgames‎, 03-26-2006 06:20 PM
    • 3
    • 48,035
    SKMullick
    09-05-2019, 09:15 AM Go to last post

  17. If Statement and Dates

    Started by Toys‎, 12-19-2005 08:40 AM
    • 5
    • 47,939
    Ron Rosenfeld
    12-21-2005, 08:35 AM Go to last post

  18. Insert value from cell in middle of a sentence

    Started by jw191‎, 10-19-2006 08:54 AM
    • 4
    • 47,938
    FDibbins
    12-22-2019, 12:53 AM Go to last post

  19. [SOLVED] What is the shortcut for Delete, Shift cells up?

    Started by steveyeoks‎, 07-07-2013 11:48 PM
    • 6
    • 47,923
    AliGW
    02-27-2024, 12:26 PM Go to last post

  20. Thumbs down How to get the average of multiple VLOOKUP findings

    Started by jur78‎, 01-23-2008 04:43 AM
    • 3
    • 47,743
    protonLeah
    04-27-2013, 01:17 AM Go to last post

  21. How do I calculate pro-rata formulas?

    Started by dukes‎, 11-09-2005 08:40 PM
    • 3
    • 47,694
    [email protected]
    11-10-2005, 12:10 AM Go to last post

  22. [SOLVED] Conditional Formatting - Hiding a row.

    Started by fitzt70‎, 05-19-2013 11:40 PM
    cell, conditional format, row deletions
    • 5
    • 47,678
    FDibbins
    06-03-2013, 02:02 PM Go to last post

  23. [SOLVED] How do I copy multiple worksheets into a new workbook?

    Started by twizzle‎, 02-13-2006 08:55 PM
    • 2
    • 47,654
    EdMac
    02-14-2006, 07:31 AM Go to last post

  24. Check if cell starts with certain character

    Started by ericc‎, 09-09-2010 12:35 AM
    formula, help needed, if formula, left, mid
    • 5
    • 47,636
    Paul
    09-10-2010, 04:47 PM Go to last post

  25. Array formula doesn't work (CTRL+SHIFT+ENTER)

    Started by Ztv‎, 02-20-2014 04:43 AM
    6 Attachment(s)
    • 65
    • 47,569
    searchmaster2010
    04-07-2021, 12:29 AM Go to last post

  26. Question Carriage returns in a concatenate formula ?

    Started by SimonL‎, 10-26-2010 03:22 PM
    • 8
    • 47,498
    arlu1201
    04-03-2013, 01:31 AM Go to last post

  27. [SOLVED] Excel should have a tan^-1 Cos^-1 and sin^-1

    Started by Mark D T Jones‎, 09-10-2005 06:05 AM
    • 3
    • 47,379
    Bernard Liengme
    09-11-2005, 03:05 PM Go to last post

  28. How to automatically move/copy data from one sheet to another if certain criteria met

    Started by KINNEY0201‎, 08-24-2010 07:23 AM
    • 19
    • 47,094
    arlu1201
    02-27-2014, 02:42 AM Go to last post

  29. [SOLVED] VLOOKUP with sheet name as cell reference

    Started by boogyman33‎, 03-18-2013 04:16 PM
    funcion 1 Attachment(s)
    • 9
    • 47,080
    FDibbins
    01-28-2018, 04:38 AM Go to last post

  30. Phone Bill for my company's monthly cell usage.

    Started by Jesse H‎, 01-02-2014 12:57 PM
    2 Attachment(s)
    • 4
    • 47,069
    Jesse H
    01-02-2014, 01:43 PM Go to last post

  31. VLOOKUP with contains function?

    Started by DannyG‎, 02-22-2008 07:23 AM
    • 5
    • 47,067
    DannyG
    02-27-2008, 06:04 AM Go to last post

  32. [SOLVED] Convert Date Bikram Sambat to AD using excel formula?

    Started by Indra Rai‎, 01-30-2012 01:29 AM
    4 Attachment(s)
    • 17
    • 47,051
    Radheshyam
    10-31-2018, 01:13 AM Go to last post

  33. [SOLVED] SUM of Hex?

    Started by GeeB‎, 07-08-2005 12:05 PM
    • 15
    • 47,040
    GeeB
    07-09-2005, 10:05 AM Go to last post

  34. Last day of the year

    Started by barefoot152‎, 10-04-2007 10:48 AM
    • 2
    • 46,838
    davis6774
    11-25-2014, 06:40 PM Go to last post

  35. How do you search an entire column with an if statement?

    Started by pitufo‎, 05-04-2010 02:15 PM
    • 5
    • 46,752
    NBVC
    05-05-2010, 01:55 PM Go to last post

  36. Conditional grey-out and disabling of cells

    Started by jman0707‎, 10-01-2008 05:26 PM
    2 Attachment(s)
    • 26
    • 46,749
    AliGW
    04-05-2021, 06:23 AM Go to last post

  37. [SOLVED] Can VLOOKUP ignore or skip certain data?

    Started by xrajncajnx‎, 07-17-2014 02:52 PM
    2 Attachment(s)
    • 13
    • 46,622
    FDibbins
    03-01-2018, 03:08 AM Go to last post

  38. "inconsistent formula" error!

    Started by grannygamer‎, 09-13-2007 04:29 PM
    • 2
    • 46,622
    grannygamer
    09-14-2007, 03:33 AM Go to last post

  39. [SOLVED] how do i get the equivalent of maxif(range,criteria)?

    Started by CHRIS K‎, 06-03-2005 09:05 AM
    • 13
    • 46,606
    DonkeyOte
    08-12-2009, 03:44 AM Go to last post

  40. count function not working, keeps displaying 0

    Started by DaveB‎, 09-06-2005 12:05 AM
    • 4
    • 46,521
    dnm
    09-06-2005, 06:05 AM Go to last post

  41. Question Calculating Half Days in Attendance

    Started by EphraimD‎, 12-02-2014 06:50 AM
    1 Attachment(s)
    • 18
    • 46,459
    Felix_I
    12-07-2018, 08:09 AM Go to last post

  42. [SOLVED] Formula - Excluding weekends & holidays

    Started by Connie Martin‎, 02-24-2005 01:06 PM
    • 9
    • 46,391
    Myrna Larson
    02-25-2005, 01:06 AM Go to last post

  43. How to keep referencing same cell after sorting.

    Started by matrex‎, 04-16-2009 09:11 PM
    1 Attachment(s)
    • 10
    • 46,301
    Pepe Le Mokko
    06-12-2021, 10:05 AM Go to last post

  44. Convert text to formula.

    Started by keb75‎, 02-28-2008 09:14 AM
    • 4
    • 46,212
    darkyam
    01-13-2010, 10:16 PM Go to last post

  45. [SOLVED] how do I get STDEV() 2 sigma?

    Started by jimbo‎, 01-24-2006 01:15 PM
    • 4
    • 46,208
    [email protected]
    01-25-2006, 03:55 AM Go to last post

  46. [SOLVED] Create a print macro that would automatically select print area?

    Started by wastedwings‎, 08-22-2005 03:05 PM
    • 7
    • 46,029
    wastedwings
    08-22-2005, 06:05 PM Go to last post

  47. Activating Multiple Array Formulas at Once...

    Started by pipsturbo‎, 05-14-2009 02:49 AM
    3 Attachment(s)
    • 32
    • 46,026
    Fotis1991
    05-30-2014, 03:14 AM Go to last post

  48. [SOLVED] COUNTIFS With Date Range

    Started by OlYeller21‎, 09-21-2009 09:52 AM
    • 9
    • 45,892
    OhioTBear24
    12-03-2013, 08:32 AM Go to last post

  49. How to use IF and VLOOKUP together in a formula

    Started by I_hate_excel_1979‎, 02-05-2014 12:30 AM
    4 Attachment(s)
    • 9
    • 45,816
    geovanwork
    08-09-2016, 04:01 AM Go to last post

  50. How to count hours

    Started by Pr0bl3m‎, 09-29-2008 11:56 AM
    5 Attachment(s)
    • 20
    • 45,745
    Skipa72
    12-27-2013, 11:37 PM Go to last post
+ Post New Thread
Page 5 of 5619 FirstFirst ... 5 ...

Forum Information and Options

Users Browsing this Forum

There are currently 85 users browsing this forum. (3 members & 82 guests)

  1. jfjoyner3,
  2. Phuocam,
  3. Wartrace

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