+ Post New Thread
Page 500 of 5614 FirstFirst ... 500 ...
Threads 24951 to 25000 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. [SOLVED] Need blank cell to = 0 for AVG function

    Started by thebutlerdidit‎, 04-21-2017 02:21 PM
    • 10
    • 358
    TMS
    04-21-2017, 04:26 PM Go to last post

  2. [SOLVED] Display without rounding

    Started by dr01allen‎, 06-24-2015 05:44 PM
    • 10
    • 3,323
    dr01allen
    06-25-2015, 03:35 PM Go to last post

  3. [SOLVED] Count number of text without duplicates and blank

    Started by Lan Tran‎, 06-26-2015 02:29 AM
    4 Attachment(s)
    • 10
    • 649
    NeedForExcel
    06-26-2015, 07:49 AM Go to last post

  4. Cool IF based on Array Numbers

    Started by tangomj‎, 06-22-2015 02:40 PM
    3 Attachment(s)
    • 10
    • 425
    DBY
    06-22-2015, 04:10 PM Go to last post

  5. [SOLVED] Autofill 1A 2A 3A and So On

    Started by uckycool‎, 07-02-2015 09:53 PM
    4 Attachment(s)
    • 10
    • 8,765
    FDibbins
    07-03-2015, 10:11 AM Go to last post

  6. Angry See if an customer number is repeated and if so is it on the same route.

    Started by onebeatdrummer‎, 04-09-2017 11:45 AM
    5 Attachment(s)
    • 10
    • 771
    BoredWorker
    04-26-2017, 11:19 PM Go to last post

  7. Smile [SOLVED] Subtotal Function in Array formula

    Started by sanjuss2‎, 04-29-2017 01:56 AM
    2 Attachment(s)
    • 10
    • 3,771
    sanjuss2
    04-29-2017, 07:20 AM Go to last post

  8. Calculating Difference in Business Days

    Started by bdav1216‎, 04-14-2017 06:42 PM
    4 Attachment(s)
    • 10
    • 948
    Logit
    04-18-2017, 11:17 AM Go to last post

  9. [SOLVED] Vlookup and concatenate results - possible with formulas?

    Started by nautilia‎, 04-17-2017 12:31 PM
    concatenate, formula, mac excel, vlookup 7 Attachment(s)
    • 10
    • 868
    Glenn Kennedy
    04-20-2017, 06:43 AM Go to last post

  10. [SOLVED] Search returns column header or error if value not found

    Started by leovfx‎, 04-29-2017 08:31 AM
    1 Attachment(s)
    • 10
    • 716
    leovfx
    04-30-2017, 04:25 PM Go to last post

  11. If statement is true then display dropdown menu

    Started by Padgoi‎, 04-20-2017 03:18 PM
    1 Attachment(s)
    • 10
    • 451
    alansidman
    04-20-2017, 04:44 PM Go to last post

  12. [SOLVED] #NAME? error with IFS formula

    Started by Jisa‎, 04-21-2017 02:25 PM
    1 Attachment(s)
    • 10
    • 3,401
    TMS
    04-21-2017, 05:31 PM Go to last post

  13. [SOLVED] Need Some Help Guys..Want to find max value and some values above and below it

    Started by Haidar123‎, 03-21-2014 07:45 AM
    1 Attachment(s)
    • 10
    • 521
    AZ-XL
    03-21-2014, 01:40 PM Go to last post

  14. IF statement: 3 options

    Started by dtb419‎, 04-27-2017 10:03 AM
    3 options 1 Attachment(s)
    • 10
    • 1,476
    dtb419
    04-27-2017, 10:53 AM Go to last post

  15. [SOLVED] sum and transfer corrsponding data from sheet to other according to product name

    Started by mazan2010‎, 04-28-2017 05:39 AM
    4 Attachment(s)
    • 10
    • 380
    mazan2010
    04-28-2017, 11:37 AM Go to last post

  16. Need formula to locate a value in another worksheet

    Started by felio‎, 04-10-2020 02:58 PM
    5 Attachment(s)
    • 10
    • 367
    XOR LX
    04-12-2020, 07:31 AM Go to last post

  17. Sum duration for each day based on text

    Started by twjolson‎, 04-13-2020 03:22 PM
    2 Attachment(s)
    • 10
    • 339
    twjolson
    04-15-2020, 01:35 PM Go to last post

  18. Arrange random number in ascending format

    Started by hkbhansali‎, 04-15-2020 10:14 AM
    1 Attachment(s)
    • 10
    • 253
    MrShorty
    04-16-2020, 02:09 PM Go to last post

  19. Question [SOLVED] Formula that matches reference cell no matter then input and updates when changed

    Started by swerner1‎, 04-15-2020 12:51 PM
    1 Attachment(s)
    • 10
    • 428
    swerner1
    04-22-2020, 03:23 PM Go to last post

  20. How to display the latest 20 dates from a data sheet? (golf handicap index calculation)

    Started by TXT007‎, 04-17-2020 03:21 PM
    5 Attachment(s)
    • 10
    • 412
    TXT007
    04-19-2020, 08:14 AM Go to last post

  21. [SOLVED] Calculate Mode based on separated cells excluding 0 and text. if two modes return highest

    Started by Boudene‎, 04-23-2020 03:13 AM
    2 Attachment(s)
    • 10
    • 445
    XOR LX
    04-23-2020, 07:39 AM Go to last post

  22. [SOLVED] Trying to get the newest date if there are multiple rows

    Started by Phlegon_of_Tralles‎, 04-23-2020 11:55 AM
    countif, index + match 1 Attachment(s)
    • 10
    • 631
    Bernie Deitrick
    04-24-2020, 01:03 PM Go to last post

  23. Leaderboard Duplicate Scores

    Started by mtoreilly‎, 05-02-2020 09:57 AM
    3 Attachment(s)
    • 10
    • 1,125
    AliGW
    05-03-2020, 10:20 AM Go to last post

  24. Question [SOLVED] Extract IP Address from heavily populated cell

    Started by reem01‎, 05-06-2020 12:01 PM
    1 Attachment(s)
    • 10
    • 550
    Bo_Ry
    05-06-2020, 02:23 PM Go to last post

  25. Highlight cells based on value of 1 other cell

    Started by tomdegezelle‎, 05-08-2020 11:02 PM
    3 Attachment(s)
    • 10
    • 525
    JeteMc
    05-11-2020, 12:33 PM Go to last post

  26. ADDING TIMES

    Started by Bob Phillips‎, 09-06-2005 01:05 AM
    • 10
    • 586
    John C. Harris, MPA
    09-06-2005, 07:05 AM Go to last post

  27. Help writing a formula

    Started by paul‎, 09-06-2005 01:05 AM
    • 10
    • 631
    Adam
    09-06-2005, 07:05 AM Go to last post

  28. Shortcut keys assigned to macros/functions in excel

    Started by Max‎, 09-06-2005 01:05 AM
    • 10
    • 659
    Aussie CPA
    09-06-2005, 07:05 AM Go to last post

  29. subtracting based on available values

    Started by Max‎, 09-06-2005 01:05 AM
    • 10
    • 622
    Ted Metro
    09-06-2005, 07:05 AM Go to last post

  30. get a count of numbers whose value falls within a given range

    Started by Trevor Shuttleworth‎, 09-06-2005 01:05 AM
    • 10
    • 523
    LyleB_Austin
    09-06-2005, 07:05 AM Go to last post

  31. [SOLVED] help me write function?

    Started by bj‎, 09-06-2005 01:05 AM
    • 10
    • 597
    Zach
    09-06-2005, 07:05 AM Go to last post

  32. [SOLVED] How do I sum cells that have values from a countif formula?

    Started by Trevor Shuttleworth‎, 09-06-2005 01:05 AM
    • 10
    • 669
    Cheri
    09-06-2005, 07:05 AM Go to last post

  33. [SOLVED] cube root

    Started by Lewis Clark‎, 09-06-2005 01:05 AM
    • 10
    • 4,957
    derskell
    09-06-2005, 07:05 AM Go to last post

  34. [SOLVED] sumif criteria reference

    Started by Roger Govier‎, 09-06-2005 01:05 AM
    • 10
    • 476
    TimH
    09-06-2005, 07:05 AM Go to last post

  35. [SOLVED] Need to reference existing functions in a custom function: possibl

    Started by Max‎, 09-06-2005 01:05 AM
    • 10
    • 601
    dofnup
    09-06-2005, 07:05 AM Go to last post

  36. Elapsed time in days

    Started by Bernie Deitrick‎, 09-06-2005 01:05 AM
    • 10
    • 503
    Steve M via OfficeKB.com
    09-06-2005, 07:05 AM Go to last post

  37. [SOLVED] sort dates

    Started by Bob Phillips‎, 09-06-2005 01:05 AM
    • 10
    • 654
    Debgala
    09-06-2005, 07:05 AM Go to last post

  38. [SOLVED] Upper case

    Started by Bob Phillips‎, 09-06-2005 01:05 AM
    • 10
    • 547
    Beginner2005
    09-06-2005, 07:05 AM Go to last post

  39. If Function 4 variables and 2 outputs

    Started by CamDim‎, 06-29-2015 04:44 AM
    • 10
    • 1,165
    oeldere
    06-29-2015, 06:15 AM Go to last post

  40. Trace Precedent and Dependent Cells

    Started by nicolachen‎, 10-21-2007 07:08 PM
    1 Attachment(s)
    • 10
    • 1,939
    VBA Noob
    10-22-2007, 05:42 AM Go to last post

  41. [SOLVED] how to learn Array Formulas...

    Started by vishnu01445‎, 08-22-2012 12:36 AM
    • 10
    • 753
    MarvinP
    08-22-2012, 11:11 AM Go to last post

  42. [SOLVED] MATCHING UP OF MULTIPLE SHEETS.....Pls Pls Pls Help.............

    Started by samuella‎, 08-11-2012 06:06 AM
    2 Attachment(s)
    • 10
    • 1,028
    samuella
    08-14-2012, 01:45 AM Go to last post

  43. Add percentage to figures then show on a secon tab

    Started by pete brown‎, 08-15-2012 09:57 AM
    • 10
    • 462
    pete brown
    08-16-2012, 04:40 AM Go to last post

  44. [SOLVED] Assigning Numerical Values to Letters and Multiplying Them

    Started by DNAguy‎, 08-16-2012 05:44 PM
    1 Attachment(s)
    • 10
    • 769
    Cutter
    08-16-2012, 09:57 PM Go to last post

  45. [SOLVED] Auto fill cells getting value from different worksheet but only if conditions met

    Started by zigojacko‎, 04-16-2013 06:31 AM
    1 Attachment(s)
    • 10
    • 1,923
    zigojacko
    04-17-2013, 03:55 AM Go to last post

  46. [SOLVED] How can the sum formula possibly add 12 extra decimal places?

    Started by Tamarissa‎, 03-19-2014 12:27 PM
    1 Attachment(s)
    • 10
    • 5,017
    Tamarissa
    03-19-2014, 01:46 PM Go to last post

  47. [SOLVED] Nested IF difficulty.

    Started by Drayde‎, 03-13-2014 10:59 AM
    • 10
    • 700
    Kaper
    03-13-2014, 12:10 PM Go to last post

  48. Countifs if Left starts with "T"

    Started by DoodlesMama‎, 03-14-2014 01:14 PM
    countifs 1 Attachment(s)
    • 10
    • 1,068
    AlKey
    03-17-2014, 12:37 PM Go to last post

  49. [SOLVED] Using SUMPRODUCT, MATCH and INDEX together

    Started by codyryan‎, 03-18-2014 07:54 PM
    2 Attachment(s)
    • 10
    • 1,445
    daddylonglegs
    03-19-2014, 08:08 AM Go to last post

  50. Number of Items open longer than 1 week but less than 2 weeks

    Started by Roger Govier‎, 09-06-2005 01:05 AM
    • 10
    • 581
    Andibevan
    09-06-2005, 07:05 AM Go to last post
+ Post New Thread
Page 500 of 5614 FirstFirst ... 500 ...

Forum Information and Options

Users Browsing this Forum

There are currently 56 users browsing this forum. (1 members & 55 guests)

  1. Dtromdtrom

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