+ Post New Thread
Page 2011 of 5614 FirstFirst ... 2011 ...
Threads 100501 to 100550 of 280698

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

  1. Generate auto Timetable Randomly :confused:

    Started by pipsmultan‎, 05-17-2015 11:13 AM
    2 Attachment(s)
    • 1
    • 592
    pipsmultan
    05-17-2015, 08:23 PM Go to last post

  2. [SOLVED] Summin by shortcut

    Started by makinmomb‎, 05-17-2015 03:39 PM
    2 Attachment(s)
    • 3
    • 425
    makinmomb
    05-17-2015, 06:44 PM Go to last post

  3. [SOLVED] Count entries in a range if the ID's match and the value is between a given range

    Started by guest2013‎, 05-17-2015 03:06 PM
    count and if, count between dates 1 Attachment(s)
    • 5
    • 729
    Tony Valko
    05-17-2015, 06:39 PM Go to last post

  4. [SOLVED] Can I create 2 different dropdowns in same cell depending on another cell value?

    Started by Dibbley247‎, 05-17-2015 05:41 PM
    1 Attachment(s)
    • 4
    • 382
    FDibbins
    05-17-2015, 06:10 PM Go to last post

  5. Using Offset function

    Started by DebMath‎, 05-17-2015 01:21 PM
    • 9
    • 799
    TMS
    05-17-2015, 03:17 PM Go to last post

  6. [SOLVED] Require simple increase/decrease formual that does not result in a %

    Started by Jeromy_E‎, 05-17-2015 12:32 PM
    • 3
    • 442
    shg
    05-17-2015, 02:12 PM Go to last post

  7. [SOLVED] Array to Match on 2 Values with Unique Result

    Started by gassiusmax‎, 05-17-2015 10:44 AM
    2 Attachment(s)
    • 3
    • 500
    Tony Valko
    05-17-2015, 12:02 PM Go to last post

  8. [SOLVED] Calculating times from the given distance and speed for specific distances

    Started by naga‎, 05-17-2015 08:09 AM
    1 Attachment(s)
    • 3
    • 471
    JohnTopley
    05-17-2015, 10:09 AM Go to last post

  9. Question VLOOKUP or excel formula help Required

    Started by adnanmir‎, 05-16-2015 12:42 PM
    5 Attachment(s)
    • 16
    • 1,019
    mahju
    05-17-2015, 09:54 AM Go to last post

  10. Finding the total amount within a date range.

    Started by jcarey5225‎, 05-16-2015 07:22 AM
    2 Attachment(s)
    • 6
    • 696
    Tony Valko
    05-17-2015, 09:34 AM Go to last post

  11. Calculating Rounded Off Numbers

    Started by bins1863‎, 05-17-2015 06:40 AM
    1 Attachment(s)
    • 3
    • 438
    bins1863
    05-17-2015, 07:06 AM Go to last post

  12. Formula to look at a table and find a word and apply it to another tab

    Started by bigtwenty‎, 05-06-2015 09:27 AM
    2013, formula, search, table, text 2 Attachment(s)
    • 1
    • 751
    VLB
    05-17-2015, 06:50 AM Go to last post

  13. [SOLVED] Automate Drop Down selection

    Started by rizmomin‎, 05-16-2015 05:58 PM
    1 Attachment(s)
    • 7
    • 597
    Tony Valko
    05-17-2015, 05:55 AM Go to last post

  14. Nesting Multiple IF AND INDEX functions

    Started by CreamOfWheat‎, 05-16-2015 10:50 PM
    1 Attachment(s)
    • 4
    • 484
    VLB
    05-17-2015, 05:45 AM Go to last post

  15. [SOLVED] Sumproduct change to sumif

    Started by makinmomb‎, 05-17-2015 05:22 AM
    1 Attachment(s)
    • 6
    • 532
    makinmomb
    05-17-2015, 05:38 AM Go to last post

  16. [SOLVED] VLOOKUP Returning Wrong Values

    Started by happymonody‎, 05-16-2015 05:36 PM
    1 Attachment(s)
    • 4
    • 862
    happymonody
    05-17-2015, 04:40 AM Go to last post

  17. Count how many unique charecter in cell

    Started by Axmed.cm‎, 03-21-2015 01:40 AM
    • 6
    • 502
    Glenn Kennedy
    05-17-2015, 04:32 AM Go to last post

  18. How do I get aligned cells in a Row to Recognise text in a previous cell and convert it

    Started by Ludwell06‎, 05-15-2015 09:13 PM
    2 Attachment(s)
    • 3
    • 627
    windy58
    05-17-2015, 04:01 AM Go to last post

  19. [SOLVED] Stock Movement daily vertical and horizontal

    Started by makinmomb‎, 05-16-2015 08:12 AM
    1 Attachment(s)
    • 11
    • 633
    Glenn Kennedy
    05-17-2015, 02:00 AM Go to last post

  20. [SOLVED] Newbie Help with Index Match

    Started by mikewachtel‎, 05-15-2015 05:49 PM
    5 Attachment(s)
    • 12
    • 629
    jhren
    05-17-2015, 01:48 AM Go to last post

  21. [SOLVED] Fix Top Ten Values Formula

    Started by werko‎, 05-17-2015 12:01 AM
    1 Attachment(s)
    • 3
    • 584
    samba_ravi
    05-17-2015, 12:15 AM Go to last post

  22. reference a value from a table based on two different criteria

    Started by VBAhelp3456‎, 05-15-2015 08:20 AM
    excel, functions, vlookup 3 Attachment(s)
    • 9
    • 796
    FDibbins
    05-16-2015, 10:25 PM Go to last post

  23. Adding a leading zero to a column of data

    Started by Semper.Fi.Rob‎, 05-16-2015 09:15 PM
    1 Attachment(s)
    • 1
    • 439
    protonLeah
    05-16-2015, 09:51 PM Go to last post

  24. Bug in modified Timecode Calculator *need help*

    Started by howiechin‎, 05-12-2015 02:11 PM
    calculator, timecode, video 2 Attachment(s)
    • 2
    • 877
    howiechin
    05-16-2015, 08:54 PM Go to last post

  25. [SOLVED] vlookup is not copying down my page correctly

    Started by trfountain22‎, 05-16-2015 08:28 PM
    1 Attachment(s)
    • 5
    • 13,046
    trfountain22
    05-16-2015, 08:50 PM Go to last post

  26. Freeze two column & on row at a time

    Started by ajoy713341‎, 05-16-2015 07:47 AM
    • 2
    • 579
    FDibbins
    05-16-2015, 08:36 PM Go to last post

  27. [SOLVED] How to make named reference change depending on position in formula

    Started by SinJinQLB‎, 05-16-2015 07:14 PM
    • 4
    • 453
    FDibbins
    05-16-2015, 07:37 PM Go to last post

  28. Maths formulas to fill in the gaps

    Started by TestMailinator‎, 05-15-2015 08:22 AM
    • 6
    • 613
    MrShorty
    05-16-2015, 07:02 PM Go to last post

  29. Count Function

    Started by jorluivil‎, 05-16-2015 03:36 PM
    3 Attachment(s)
    • 8
    • 419
    FDibbins
    05-16-2015, 05:23 PM Go to last post

  30. [SOLVED] Calculating the Length of a shape to get the correct Width when the needed Area is known

    Started by Mr.GfCs‎, 05-16-2015 04:14 PM
    1 Attachment(s)
    • 3
    • 401
    popipipo
    05-16-2015, 04:42 PM Go to last post

  31. Help please entering a formula obtained by a polynomial equation trendline

    Started by Help me, I'm Simon‎, 05-16-2015 12:30 PM
    • 5
    • 861
    MrShorty
    05-16-2015, 02:51 PM Go to last post

  32. Counting Cells with two criteria

    Started by Ultracyclist‎, 05-16-2015 01:36 PM
    • 2
    • 322
    Ultracyclist
    05-16-2015, 02:48 PM Go to last post

  33. How to make it for the whole values ?

    Started by jack666sparrow‎, 05-16-2015 09:09 AM
    1 Attachment(s)
    • 2
    • 369
    JohnTopley
    05-16-2015, 01:16 PM Go to last post

  34. [SOLVED] Need to count occurrences of a text + increasing number on the same cell

    Started by Valco‎, 05-15-2015 10:29 AM
    • 4
    • 538
    Glenn Kennedy
    05-16-2015, 12:19 PM Go to last post

  35. [SOLVED] counting the total number of items which are ordered

    Started by ImTr0uBLe‎, 05-16-2015 08:47 AM
    4 Attachment(s)
    • 15
    • 1,265
    ImTr0uBLe
    05-16-2015, 12:03 PM Go to last post

  36. [SOLVED] Need help for compound interest formula

    Started by LokeshKumar‎, 05-16-2015 09:43 AM
    2 Attachment(s)
    • 2
    • 453
    JohnTopley
    05-16-2015, 11:45 AM Go to last post

  37. comparing content similarity in arrays

    Started by ramez‎, 05-16-2015 08:19 AM
    1 Attachment(s)
    • 1
    • 483
    Norie
    05-16-2015, 08:50 AM Go to last post

  38. [SOLVED] Need cell range to stay the same

    Started by HeatherBelle79‎, 05-15-2015 09:43 PM
    • 11
    • 549
    Tony Valko
    05-16-2015, 08:12 AM Go to last post

  39. [SOLVED] Conditional formatting - multiple values

    Started by emilc‎, 05-16-2015 05:51 AM
    • 4
    • 1,597
    emilc
    05-16-2015, 06:56 AM Go to last post

  40. If function and text does not work

    Started by GeorgeKerstholt‎, 05-14-2015 09:50 AM
    2 Attachment(s)
    • 9
    • 990
    GeorgeKerstholt
    05-16-2015, 06:51 AM Go to last post

  41. lookup Against Continues Serial No in Excel

    Started by silambarasan.J‎, 05-16-2015 02:44 AM
    5 Attachment(s)
    • 7
    • 383
    silambarasan.J
    05-16-2015, 06:34 AM Go to last post

  42. Populating table based on month & year only

    Started by VBAhelp3456‎, 05-16-2015 06:05 AM
    excel, formula, table 1 Attachment(s)
    • 2
    • 494
    sktneer
    05-16-2015, 06:27 AM Go to last post

  43. [SOLVED] Formula or fuction to work out total number of males females that have a specific score.

    Started by jay_midge‎, 05-16-2015 05:33 AM
    2 Attachment(s)
    • 4
    • 610
    jay_midge
    05-16-2015, 06:16 AM Go to last post

  44. Exclamation Help in Creating Daily Productivity Sheet

    Started by vivek_work‎, 05-16-2015 05:01 AM
    1 Attachment(s)
    • 0
    • 337
    vivek_work
    05-16-2015, 05:01 AM Go to last post

  45. [SOLVED] Conditional Formatting highlight duplicate values IF cell doesn't start with "XX"

    Started by deneh‎, 05-15-2015 12:47 PM
    • 2
    • 712
    deneh
    05-16-2015, 04:44 AM Go to last post

  46. Macro causing excel to crash

    Started by bradleyandrewdavis‎, 05-13-2015 06:10 PM
    • 9
    • 1,033
    Philb1
    05-16-2015, 04:29 AM Go to last post

  47. How can covert text to date Format?

    Started by Akatecho‎, 05-16-2015 02:09 AM
    • 2
    • 391
    Glenn Kennedy
    05-16-2015, 02:30 AM Go to last post

  48. [SOLVED] Convert a group of formulas to array formulas at once

    Started by coach.32‎, 05-15-2015 11:20 PM
    1 Attachment(s)
    • 5
    • 917
    Glenn Kennedy
    05-16-2015, 02:21 AM Go to last post

  49. Sum data in multiple columns

    Started by ACCOUNTINGSCORE‎, 05-15-2015 05:15 PM
    1 Attachment(s)
    • 1
    • 290
    Glenn Kennedy
    05-16-2015, 02:12 AM Go to last post

  50. If then help

    Started by boardjd‎, 05-15-2015 08:20 PM
    • 3
    • 381
    FDibbins
    05-15-2015, 10:31 PM Go to last post
+ Post New Thread
Page 2011 of 5614 FirstFirst ... 2011 ...

Forum Information and Options

Users Browsing this Forum

There are currently 50 users browsing this forum. (1 members & 49 guests)

  1. amoar

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