+ Post New Thread
Page 1500 of 5615 FirstFirst ... 1500 ...
Threads 74951 to 75000 of 280708

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

  1. Custom data validation drop down lists

    Started by Basil85‎, 02-05-2017 10:26 PM
    data validation list, excel 1 Attachment(s)
    • 1
    • 648
    CAntosh
    02-06-2017, 03:22 PM Go to last post

  2. Discount Formula

    Started by WSheehey‎, 02-06-2017 01:14 PM
    1 Attachment(s)
    • 9
    • 1,256
    JohnTopley
    02-06-2017, 03:08 PM Go to last post

  3. Pull data before a "-"

    Started by tfagan1978‎, 02-06-2017 01:39 PM
    1 Attachment(s)
    • 5
    • 710
    tfagan1978
    02-06-2017, 03:07 PM Go to last post

  4. Getting 2/3 day old data from a database using a query

    Started by xduy‎, 02-06-2017 02:37 PM
    • 0
    • 264
    xduy
    02-06-2017, 02:37 PM Go to last post

  5. Calculate days excluding some days between dates

    Started by sam16‎, 02-04-2017 03:50 PM
    • 2
    • 790
    sam16
    02-06-2017, 02:35 PM Go to last post

  6. [SOLVED] formula to split data in respective columns

    Started by JEAN1972‎, 02-06-2017 02:14 PM
    1 Attachment(s)
    • 1
    • 471
    Kaper
    02-06-2017, 02:21 PM Go to last post

  7. [SOLVED] Array Functions from Alan Beban

    Started by Josh O.‎, 02-04-2005 01:06 PM
    • 18
    • 4,057
    KanwalNo1
    02-06-2017, 01:36 PM Go to last post

  8. [SOLVED] Calculating Correlation from Summary Table

    Started by McStagger‎, 02-03-2017 01:16 PM
    1 Attachment(s)
    • 13
    • 568
    McStagger
    02-06-2017, 01:28 PM Go to last post

  9. [SOLVED] Formula to add data for define date

    Started by rizmomin‎, 02-06-2017 12:21 PM
    2 Attachment(s)
    • 5
    • 458
    rizmomin
    02-06-2017, 01:25 PM Go to last post

  10. MAX Value with multiple criteria using Sumproduct or Equivalent

    Started by djfatboyfats‎, 02-06-2017 10:48 AM
    • 7
    • 619
    José Augusto
    02-06-2017, 12:28 PM Go to last post

  11. Formula in a drop-down list

    Started by cyankee‎, 02-06-2017 12:17 PM
    • 1
    • 440
    JohnTopley
    02-06-2017, 12:24 PM Go to last post

  12. how to make forumla that treat blank cells as a zero?

    Started by Bingsmart‎, 08-04-2012 03:06 PM
    • 12
    • 23,900
    cyankee
    02-06-2017, 11:58 AM Go to last post

  13. [SOLVED] Check if values are within a list of ranges

    Started by Tayque_J_Holmes‎, 02-06-2017 10:40 AM
    1 Attachment(s)
    • 2
    • 379
    ImranBhatti
    02-06-2017, 11:03 AM Go to last post

  14. Question find the first value and the last in row

    Started by ravitbore7‎, 02-06-2017 09:19 AM
    • 5
    • 366
    ravitbore7
    02-06-2017, 10:13 AM Go to last post

  15. How to create a file where my raw data file then transfers into metrics in another file

    Started by milkiewiczj‎, 02-03-2017 10:42 AM
    • 2
    • 368
    milkiewiczj
    02-06-2017, 10:11 AM Go to last post

  16. Extract numbers from 4 sheets if date available

    Started by Sekars‎, 02-03-2017 02:39 AM
    2 Attachment(s)
    • 4
    • 389
    Sekars
    02-06-2017, 10:03 AM Go to last post

  17. [SOLVED] I want to use SUMIF function to give me prices separately for + n -ve values in column A

    Started by omega0010‎, 02-06-2017 09:36 AM
    1 Attachment(s)
    • 4
    • 326
    omega0010
    02-06-2017, 10:00 AM Go to last post

  18. VLookup Hyperlink not opening specified file

    Started by Nick2512‎, 02-05-2017 09:54 AM
    • 3
    • 3,514
    Nick2512
    02-06-2017, 09:50 AM Go to last post

  19. Question How to determine the slope for non-linear curves

    Started by Wladimir88‎, 02-06-2017 01:59 AM
    • 2
    • 439
    MrShorty
    02-06-2017, 09:42 AM Go to last post

  20. Thumbs up Basic Excel lookup question

    Started by creative666‎, 02-06-2017 08:54 AM
    2 Attachment(s)
    • 3
    • 283
    JohnTopley
    02-06-2017, 09:24 AM Go to last post

  21. Calculate days where the range fall between dates

    Started by sam16‎, 02-03-2017 04:21 PM
    1 Attachment(s)
    • 1
    • 455
    avk
    02-06-2017, 09:24 AM Go to last post

  22. [SOLVED] Sales figures issue

    Started by 81186‎, 02-02-2017 10:58 AM
    2 Attachment(s)
    • 11
    • 593
    JohnTopley
    02-06-2017, 09:03 AM Go to last post

  23. [SOLVED] using Lookup to get values from external workbook, open or closed.

    Started by JaimeP‎, 02-06-2017 07:43 AM
    • 2
    • 263
    JohnTopley
    02-06-2017, 08:54 AM Go to last post

  24. Vlookup a value contained in another workbook.

    Started by JaimeP‎, 02-06-2017 06:40 AM
    vlookup
    • 2
    • 403
    JaimeP
    02-06-2017, 08:51 AM Go to last post

  25. calculate dates excluding weekends

    Started by Axmed.cm‎, 02-06-2017 06:03 AM
    • 5
    • 585
    JohnTopley
    02-06-2017, 08:19 AM Go to last post

  26. Matching of two conditions with multiple output criteria (SOD-Finance)

    Started by FrancescaM‎, 01-27-2017 11:28 AM
    1 Attachment(s)
    • 2
    • 1,009
    FrancescaM
    02-06-2017, 07:44 AM Go to last post

  27. Question month to date calculation based on month selection from list box

    Started by jamaludheen‎, 02-06-2017 04:06 AM
    3 Attachment(s)
    • 5
    • 715
    JohnTopley
    02-06-2017, 06:00 AM Go to last post

  28. How to concatenate dynamic list in one cell?

    Started by ImranBhatti‎, 02-06-2017 05:27 AM
    • 2
    • 910
    sandy666
    02-06-2017, 05:48 AM Go to last post

  29. Help piecing together with formulas

    Started by DMY852‎, 02-04-2017 08:08 AM
    4 Attachment(s)
    • 4
    • 603
    JohnTopley
    02-06-2017, 05:19 AM Go to last post

  30. INDEX MATCH Return multiple data for YTD calculation

    Started by BananaJo‎, 02-06-2017 04:46 AM
    • 1
    • 711
    sandy666
    02-06-2017, 05:16 AM Go to last post

  31. Creating custom function

    Started by NoSleepForMe‎, 02-06-2017 04:22 AM
    • 1
    • 283
    Phuocam
    02-06-2017, 04:32 AM Go to last post

  32. Request box for VBAProject Password appears on Excel exit

    Started by Tiger20‎, 06-21-2016 09:52 AM
    • 2
    • 605
    Tiger20
    02-06-2017, 04:27 AM Go to last post

  33. [SOLVED] Count the times the text is different in a column

    Started by Napoleon Dynamite‎, 02-06-2017 03:19 AM
    1 Attachment(s)
    • 2
    • 295
    Napoleon Dynamite
    02-06-2017, 03:57 AM Go to last post

  34. Slow drag and drop

    Started by JBarryD‎, 02-06-2017 02:54 AM
    • 4
    • 2,524
    FDibbins
    02-06-2017, 03:29 AM Go to last post

  35. Reference output for all members of dropdown list in another cell

    Started by DrSues02‎, 02-02-2017 11:05 PM
    1 Attachment(s)
    • 8
    • 532
    FlameRetired
    02-06-2017, 12:34 AM Go to last post

  36. Default Partial Values in a Cell

    Started by leebird‎, 02-05-2017 09:21 PM
    3 Attachment(s)
    • 5
    • 383
    sandy666
    02-05-2017, 11:26 PM Go to last post

  37. SumProduct and Indirect Forumla

    Started by Klmo‎, 02-05-2017 08:11 PM
    • 3
    • 351
    Klmo
    02-05-2017, 09:32 PM Go to last post

  38. Should I use and or or

    Started by Motoxboi26‎, 02-05-2017 08:40 PM
    1 Attachment(s)
    • 1
    • 358
    TMS
    02-05-2017, 09:27 PM Go to last post

  39. Accessing data in an external link when you dont have the source file

    Started by JFNORDEN‎, 02-05-2017 02:03 PM
    • 1
    • 473
    sandy666
    02-05-2017, 08:09 PM Go to last post

  40. Exclamation Create a formula that multiplies on a column based on a word on another column

    Started by celeazul‎, 02-05-2017 11:05 AM
    1 Attachment(s)
    • 5
    • 548
    AliGW
    02-05-2017, 05:51 PM Go to last post

  41. Converting scale descriptors to numbers

    Started by mason.robj‎, 02-04-2017 06:32 AM
    • 5
    • 9,908
    mason.robj
    02-05-2017, 05:40 PM Go to last post

  42. [SOLVED] Find text in column

    Started by Napoleon Dynamite‎, 02-05-2017 04:47 PM
    1 Attachment(s)
    • 3
    • 448
    shg
    02-05-2017, 05:38 PM Go to last post

  43. Copying formula...

    Started by Losguapos1‎, 02-05-2017 01:59 PM
    • 3
    • 373
    Amanda Wilso
    02-05-2017, 05:33 PM Go to last post

  44. Having issues averaging empty cells

    Started by Doon1‎, 02-05-2017 03:07 PM
    1 Attachment(s)
    • 3
    • 310
    Doon1
    02-05-2017, 05:00 PM Go to last post

  45. [SOLVED] Lookup based on Multiple Criteria on Multiple Table

    Started by oktovan‎, 02-03-2017 09:28 AM
    4 Attachment(s)
    • 7
    • 731
    JeteMc
    02-05-2017, 04:04 PM Go to last post

  46. [SOLVED] Formula to Sum upto certain Row

    Started by rizmomin‎, 02-05-2017 01:59 PM
    1 Attachment(s)
    • 2
    • 318
    rizmomin
    02-05-2017, 02:50 PM Go to last post

  47. Calculation by specific Columns

    Started by AaruJaan‎, 02-05-2017 12:18 PM
    calculation, if formula excel 1 Attachment(s)
    • 2
    • 558
    mahju
    02-05-2017, 01:50 PM Go to last post

  48. Time Transpired [Where do I hire?]

    Started by johnbradbury‎, 02-05-2017 12:13 PM
    • 1
    • 387
    AliGW
    02-05-2017, 01:26 PM Go to last post

  49. Time Transpired [Where do I hire?]

    Started by johnbradbury‎, 02-05-2017 12:14 PM
    • 1
    • 446
    AliGW
    02-05-2017, 01:23 PM Go to last post

  50. Calculation by specific Columns

    Started by AaruJaan‎, 02-05-2017 12:17 PM
    calcuation, if formula excel, specific columns 1 Attachment(s)
    • 2
    • 494
    AliGW
    02-05-2017, 01:20 PM Go to last post
+ Post New Thread
Page 1500 of 5615 FirstFirst ... 1500 ...

Forum Information and Options

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