+ Post New Thread
Page 4 of 5614 FirstFirst ... 4 ...
Threads 151 to 200 of 280687

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

  1. How to compress excel file.

    Started by [email protected]‎, 12-19-2010 01:21 AM
    • 5
    • 58,143
    [email protected]
    12-19-2010, 11:32 AM Go to last post

  2. [SOLVED] Can you delete multiple worksheets with one command?

    Started by pebel‎, 03-17-2005 07:06 PM
    • 2
    • 58,141
    Gord Dibben
    03-17-2005, 10:06 PM Go to last post

  3. Returning the date for last Friday

    Started by MasterMonk‎, 02-12-2008 01:15 PM
    • 9
    • 58,096
    AliGW
    07-31-2020, 05:49 PM Go to last post

  4. How do I count how many times names appear

    Started by bmunoz64‎, 10-28-2008 11:18 AM
    • 5
    • 57,918
    bmunoz64
    10-29-2008, 01:27 PM Go to last post

  5. [SOLVED] Average only cells that contain numbers

    Started by April‎, 04-10-2006 09:10 PM
    • 5
    • 57,669
    Tony Valko
    03-17-2014, 03:46 PM Go to last post

  6. Angry IF STATEMENT returns False, even though the results are true

    Started by Biolu527‎, 10-28-2013 11:11 AM
    headache, if statement formula, please help me, vacation accruals, value error 1 Attachment(s)
    • 4
    • 57,622
    ben_hensel
    10-28-2013, 11:21 AM Go to last post

  7. [SOLVED] Explain =LOOKUP(2,1/(A2:A10=D2),B2:B10)

    Started by sakmsb‎, 10-14-2014 11:09 AM
    1 Attachment(s)
    • 19
    • 57,263
    Pepe Le Mokko
    05-27-2021, 11:38 AM Go to last post

  8. Clear all filters

    Started by crs245‎, 10-17-2008 03:46 PM
    • 5
    • 56,961
    Sebghatullah
    10-24-2013, 06:58 AM Go to last post

  9. Blended Rate Formula

    Started by Josh_123456‎, 04-05-2007 10:47 AM
    • 4
    • 56,769
    Josh_123456
    04-05-2007, 06:18 PM Go to last post

  10. [SOLVED] how to convert rpt files to xls

    Started by AV‎, 05-06-2005 02:06 AM
    • 1
    • 56,414
    AV
    05-06-2005, 02:06 AM Go to last post

  11. How do you ignore hidden rows in a countif() function

    Started by Scott buckwalter‎, 08-10-2005 11:05 AM
    • 9
    • 56,330
    Domenic
    08-11-2005, 04:05 PM Go to last post

  12. Question [SOLVED] Using IF function to compare dates of two cells

    Started by Mr.WalterJones‎, 04-12-2012 10:43 AM
    • 3
    • 56,280
    tigeravatar
    04-12-2012, 11:15 AM Go to last post

  13. [SOLVED] Pivot Table - divide two results

    Started by Pete Petersen‎, 01-06-2005 06:06 PM
    • 5
    • 55,866
    Sunryzz
    05-04-2005, 02:06 PM Go to last post

  14. Export single sheet in csv format?

    Started by bluefrog‎, 06-07-2008 01:01 PM
    1 Attachment(s)
    • 5
    • 55,786
    bluefrog
    06-08-2008, 06:55 AM Go to last post

  15. Question Calculate future dates at 6 month intvls...?

    Started by ederoche‎, 07-20-2007 02:35 PM
    • 6
    • 55,748
    Badger123
    08-06-2007, 05:15 PM Go to last post

  16. Exclamation Error? VLOOKUP returns 0 instead of proper value.

    Started by Hatchiman‎, 10-17-2010 07:05 AM
    2 Attachment(s)
    • 4
    • 55,498
    Hatchiman
    10-18-2010, 02:42 AM Go to last post

  17. Formula using arrow icons to show trend

    Started by casdaq‎, 11-16-2009 07:04 PM
    1 Attachment(s)
    • 7
    • 54,864
    flowerflower
    11-30-2012, 05:04 PM Go to last post

  18. [SOLVED] What is the formula for converting farenheit to celsius?

    Started by swpt4330‎, 06-16-2005 02:05 AM
    • 8
    • 54,471
    bj
    06-16-2005, 04:05 PM Go to last post

  19. Adjacent cells omitted warning, why?

    Started by simusphere‎, 09-11-2013 12:15 PM
    1 Attachment(s)
    • 7
    • 54,055
    kmsmith222
    11-18-2019, 01:55 PM Go to last post

  20. If cell is not blank, insert number

    Started by NathanLedet‎, 08-18-2008 04:05 PM
    • 6
    • 54,027
    NathanLedet
    08-18-2008, 04:36 PM Go to last post

  21. [SOLVED] centre across selection shortcut

    Started by Martin B‎, 04-17-2006 01:50 PM
    • 3
    • 53,995
    Don Guillett
    04-17-2006, 04:15 PM Go to last post

  22. Using Bold and Italic on certain text in formula

    Started by pakida‎, 03-05-2013 08:18 PM
    • 9
    • 53,844
    6StringJazzer
    07-27-2014, 07:53 PM Go to last post

  23. Question [SOLVED] Investment Max Drawdown (1-Cell) Formula without VBA

    Started by thecrell‎, 11-09-2012 09:15 AM
    array formula, drawdown, investment 3 Attachment(s)
    • 9
    • 53,833
    FDibbins
    02-12-2021, 02:22 AM Go to last post

  24. How do I use a pivot table to present data, not sum or count it.

    Started by Rick‎, 07-13-2006 04:45 PM
    • 4
    • 53,667
    step_andy
    08-20-2006, 08:20 PM Go to last post

  25. [SOLVED] DATEDIF function is not working in Excell 2013

    Started by SoftwareUzer‎, 12-28-2015 05:53 PM
    • 15
    • 53,413
    King Mak
    05-12-2020, 01:28 PM Go to last post

  26. Unhappy [SOLVED] VLOOKUP returning wrong value

    Started by marykayejn‎, 03-02-2017 06:19 PM
    vlookup
    • 3
    • 53,393
    marykayejn
    03-02-2017, 06:36 PM Go to last post

  27. Merge Workbooks Grayed Out

    Started by Bill Barber‎, 05-05-2006 04:10 PM
    • 1
    • 53,016
    Gord Dibben
    05-05-2006, 08:10 PM Go to last post

  28. What is the function opposite of LOG

    Started by erik‎, 01-26-2006 11:45 PM
    • 3
    • 52,922
    [email protected]
    01-28-2006, 04:55 AM Go to last post

  29. [SOLVED] is 10^3 equals 10E3

    Started by Excel_learner‎, 03-10-2015 04:32 PM
    • 7
    • 52,637
    Excel_learner
    03-10-2015, 05:07 PM Go to last post

  30. Find row number of text string in a range of cells

    Started by Steven Fleck‎, 02-01-2008 08:35 AM
    • 7
    • 52,535
    protonLeah
    01-06-2013, 08:38 PM Go to last post

  31. Today minus 1 day

    Started by MB‎, 08-11-2006 02:10 PM
    • 3
    • 52,200
    MB
    08-11-2006, 03:00 PM Go to last post

  32. Thumbs down Automatically get next Friday's date

    Started by andrew short‎, 06-09-2008 11:49 AM
    1 Attachment(s)
    • 7
    • 51,957
    arlu1201
    05-10-2012, 06:06 AM Go to last post

  33. Cumulative Return

    Started by Natalie‎, 05-23-2006 04:10 AM
    • 2
    • 51,888
    Fred Smith
    05-24-2006, 08:20 PM Go to last post

  34. Calculate formulas with feet & inches

    Started by Wayne hof‎, 01-06-2005 03:06 PM
    • 11
    • 51,863
    vtm
    10-19-2012, 11:16 AM Go to last post

  35. How can I copy and paste an entire workbook?

    Started by Jordon‎, 01-10-2006 06:50 PM
    • 4
    • 51,825
    Janeap89
    09-06-2017, 05:35 PM Go to last post

  36. [SOLVED] How can I draw a Parabola in Excel? like y = x^2 + 3

    Started by Max‎, 03-13-2006 12:40 PM
    • 7
    • 51,751
    Mike Middleton
    03-13-2006, 03:25 PM Go to last post

  37. Question [SOLVED] Search for String in Range, If Match, Return Matching Cell Value

    Started by ryanb909‎, 08-21-2013 12:58 AM
    • 6
    • 51,544
    Fotis1991
    08-21-2013, 02:27 AM Go to last post

  38. Red face [SOLVED] Copy & Paste Array Formula

    Started by Karen615‎, 09-11-2013 10:05 AM
    2 Attachment(s)
    • 12
    • 51,456
    Jonmo1
    09-11-2013, 02:43 PM Go to last post

  39. Can this be right? Excel has no XOR function???

    Started by LSB M‎, 07-25-2006 03:17 AM
    • 8
    • 51,319
    zweiblumen
    11-15-2016, 01:11 PM Go to last post

  40. Calculate relative frequency?

    Started by mlh0654‎, 06-10-2006 07:45 PM
    • 4
    • 51,083
    Dana DeLouis
    06-11-2006, 11:15 AM Go to last post

  41. How to count the number of "#N/A"

    Started by rogerbacon‎, 10-19-2006 11:16 AM
    • 4
    • 51,056
    rogerbacon
    10-19-2006, 02:30 PM Go to last post

  42. reversing first name and last name in same cell

    Started by gunsmokegirl‎, 08-01-2008 11:04 AM
    • 11
    • 50,985
    NBVC
    12-01-2009, 11:10 AM Go to last post

  43. Pull left and right until space

    Started by maxthebear‎, 09-10-2009 07:54 PM
    1 Attachment(s)
    • 5
    • 50,651
    maxthebear
    09-11-2009, 10:40 AM Go to last post

  44. Reference a Cell for Tab name in VLOOKUP Table Array

    Started by gabem‎, 05-27-2009 12:14 PM
    tab, table array, vlookup
    • 3
    • 50,531
    JBeaucaire
    05-27-2009, 02:15 PM Go to last post

  45. [SOLVED] How do I calculate the inflection point?

    Started by rgoyan‎, 08-22-2006 06:00 PM
    • 3
    • 50,192
    Gary''s Student
    08-22-2006, 09:20 PM Go to last post

  46. How to break ties in the RANK function

    Started by ducecoop‎, 12-08-2008 08:17 AM
    2 Attachment(s)
    • 10
    • 50,104
    samktlim
    10-20-2013, 12:38 AM Go to last post

  47. [SOLVED] Need excel formula to sum 1+2+3...+N given a number N

    Started by LAdekoya‎, 05-26-2005 05:15 PM
    • 7
    • 49,881
    LAdekoya
    05-26-2005, 05:15 PM Go to last post

  48. 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,677
    RODY
    09-06-2005, 07:05 PM Go to last post

  49. Finding unknown X value from known Y value from curve of best fit

    Started by sep87‎, 10-12-2012 10:49 AM
    1 Attachment(s)
    • 6
    • 49,631
    MrShorty
    10-13-2012, 09:19 AM Go to last post

  50. Generating Automatic Serial Number in Excel

    Started by vajeehu‎, 08-15-2007 04:00 PM
    • 1
    • 49,539
    Ron Coderre
    08-15-2007, 04:11 PM Go to last post
+ Post New Thread
Page 4 of 5614 FirstFirst ... 4 ...

Forum Information and Options

Users Browsing this Forum

There are currently 45 users browsing this forum. (0 members & 45 guests)

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