+ Post New Thread
Page 1951 of 5615 FirstFirst ... 1951 ...
Threads 97501 to 97550 of 280710

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. Attendance Tracking

    Started by JoeHan‎, 07-20-2015 09:50 AM
    2 Attachment(s)
    • 1
    • 540
    BlindAlley
    07-20-2015, 10:20 AM Go to last post

  2. [SOLVED] Condional Format using a Formula

    Started by wysbob‎, 07-20-2015 08:46 AM
    • 4
    • 469
    Aardigspook
    07-20-2015, 10:01 AM Go to last post

  3. [SOLVED] Lookup Date minus 1 day and return Values from the Matching Headings in 2 Worksheets

    Started by hammer2‎, 07-20-2015 08:38 AM
    1 Attachment(s)
    • 2
    • 1,606
    hammer2
    07-20-2015, 09:07 AM Go to last post

  4. Date Formula

    Started by kmt1609‎, 07-17-2015 08:57 AM
    3 Attachment(s)
    • 6
    • 599
    GeneralDisarray
    07-20-2015, 08:47 AM Go to last post

  5. Compounding Values within an array

    Started by cmore‎, 07-19-2015 09:11 AM
    1 Attachment(s)
    • 9
    • 2,204
    cmore
    07-20-2015, 08:45 AM Go to last post

  6. Shade a Selection of columns based on a TIME in one of them

    Started by AGPLily‎, 07-20-2015 04:05 AM
    2 Attachment(s)
    • 7
    • 653
    JohnTopley
    07-20-2015, 08:36 AM Go to last post

  7. Creating a forumula to pick up values in other cells...

    Started by wench02‎, 10-03-2012 09:20 AM
    • 2
    • 627
    Tet Htut Naing
    07-20-2015, 08:34 AM Go to last post

  8. [SOLVED] Excel lookups and counts

    Started by jiteshmehta2k1‎, 07-20-2015 07:58 AM
    1 Attachment(s)
    • 2
    • 350
    jiteshmehta2k1
    07-20-2015, 08:21 AM Go to last post

  9. Averaging with a blank cell, needs to show blank calculation

    Started by Pstreicher‎, 06-29-2015 04:41 AM
    • 2
    • 647
    Faustocruz
    07-20-2015, 08:08 AM Go to last post

  10. How to quickly add 1,2,3... to a filtered list?

    Started by yugo23‎, 07-20-2015 07:08 AM
    • 2
    • 516
    yugo23
    07-20-2015, 07:47 AM Go to last post

  11. Ignore blank cells

    Started by ACrossley1‎, 07-20-2015 06:45 AM
    • 4
    • 455
    TMS
    07-20-2015, 07:40 AM Go to last post

  12. [SOLVED] Vacation tacking Sheet

    Started by RobinSK‎, 07-17-2015 04:16 AM
    3 Attachment(s)
    • 8
    • 611
    RobinSK
    07-20-2015, 07:27 AM Go to last post

  13. How to sum value only on currently filtered rows

    Started by yugo23‎, 07-13-2015 02:12 AM
    3 Attachment(s)
    • 7
    • 626
    yugo23
    07-20-2015, 07:05 AM Go to last post

  14. Countif value in cell is found in another range whilst two sets of dates also match..

    Started by Barking_Mad‎, 07-20-2015 06:27 AM
    countif, dates, range 1 Attachment(s)
    • 4
    • 736
    cbatrody
    07-20-2015, 06:44 AM Go to last post

  15. [SOLVED] If Statement for date by year

    Started by guy13‎, 07-17-2015 11:14 AM
    • 6
    • 600
    guy13
    07-20-2015, 04:31 AM Go to last post

  16. [SOLVED] VLOOKUP Question

    Started by Steven811‎, 07-19-2015 05:09 AM
    3 Attachment(s)
    • 8
    • 709
    Steven811
    07-20-2015, 03:46 AM Go to last post

  17. Sum values based on multiple criteria in rows and columns

    Started by mattadler22‎, 07-17-2015 11:42 AM
    2 Attachment(s)
    • 4
    • 992
    Glenn Kennedy
    07-20-2015, 03:09 AM Go to last post

  18. Rank function with countif

    Started by jninyo‎, 07-19-2015 02:25 PM
    2 Attachment(s)
    • 6
    • 1,814
    joeu2004
    07-20-2015, 03:06 AM Go to last post

  19. [SOLVED] Need to average collection of years grades into one.

    Started by JNAC‎, 07-19-2015 01:17 AM
    1 Attachment(s)
    • 3
    • 614
    JNAC
    07-20-2015, 02:28 AM Go to last post

  20. [SOLVED] Conditional Formatting w/ Data Bars

    Started by NoMotion‎, 07-19-2015 03:25 AM
    conditional formatting, data bars 2 Attachment(s)
    • 4
    • 731
    Aardigspook
    07-20-2015, 02:24 AM Go to last post

  21. Auto Fill

    Started by baker_pro‎, 07-19-2015 08:18 AM
    • 6
    • 552
    baker_pro
    07-20-2015, 02:16 AM Go to last post

  22. [SOLVED] alphagram

    Started by makinmomb‎, 07-19-2015 10:48 AM
    2 Attachment(s)
    • 5
    • 899
    makinmomb
    07-20-2015, 01:27 AM Go to last post

  23. Search for text substring

    Started by Matt_Gerathy‎, 07-20-2015 01:14 AM
    • 1
    • 396
    FDibbins
    07-20-2015, 01:19 AM Go to last post

  24. [SOLVED] Rounding up to the nearest 5 or 0

    Started by RachelMads02‎, 07-19-2015 11:32 PM
    1 Attachment(s)
    • 2
    • 921
    RachelMads02
    07-19-2015, 11:42 PM Go to last post

  25. [SOLVED] Total of Years and Month Formula Needed, Please

    Started by LrngExcel‎, 07-19-2015 01:11 PM
    1 Attachment(s)
    • 31
    • 2,055
    LrngExcel
    07-19-2015, 08:27 PM Go to last post

  26. Count Uniques with String Matching

    Started by PedalPusher‎, 07-19-2015 03:20 PM
    countif
    • 2
    • 634
    Tony Valko
    07-19-2015, 07:40 PM Go to last post

  27. VLOOKUP bringing up #N/A in some cells despite reference value matching in source table?

    Started by staineve‎, 07-19-2015 01:20 PM
    3 Attachment(s)
    • 7
    • 916
    lydia1008
    07-19-2015, 07:34 PM Go to last post

  28. Data validation with dependent

    Started by Haha88‎, 07-19-2015 07:01 PM
    1 Attachment(s)
    • 2
    • 396
    Tony Valko
    07-19-2015, 07:10 PM Go to last post

  29. [SOLVED] Search a column within 1 sheet for text values if true copy that row to sheet 2

    Started by m77wls‎, 07-19-2015 03:47 PM
    2 Attachment(s)
    • 6
    • 754
    Pete_UK
    07-19-2015, 05:32 PM Go to last post

  30. defining cell number with formula in another formula

    Started by rastlin‎, 07-19-2015 04:12 PM
    • 2
    • 395
    rastlin
    07-19-2015, 04:45 PM Go to last post

  31. sum only cells in a column if the adjacent cell is blank

    Started by JeffW012‎, 07-19-2015 03:28 PM
    1 Attachment(s)
    • 4
    • 777
    JeffW012
    07-19-2015, 03:45 PM Go to last post

  32. Formula to identify from list team members not playing

    Started by cph8‎, 07-07-2015 04:36 PM
    4 Attachment(s)
    • 6
    • 905
    cph8
    07-19-2015, 03:34 PM Go to last post

  33. [SOLVED] Does box A fit into box B

    Started by Milcoi‎, 07-16-2015 09:58 AM
    6 Attachment(s)
    • 18
    • 5,274
    Milcoi
    07-19-2015, 02:38 PM Go to last post

  34. [SOLVED] Formula with if, isodd & and

    Started by elloco240866_Alsdorf‎, 07-19-2015 08:08 AM
    • 9
    • 1,800
    elloco240866_Alsdorf
    07-19-2015, 02:16 PM Go to last post

  35. [SOLVED] help calculating TIME in different cell formats

    Started by pjump‎, 07-18-2015 09:49 PM
    time percentages 2 Attachment(s)
    • 3
    • 646
    FDibbins
    07-19-2015, 01:55 PM Go to last post

  36. [SOLVED] Extract information -multiple criteria

    Started by Shareez Saleem‎, 07-19-2015 12:23 PM
    2 Attachment(s)
    • 4
    • 834
    Shareez Saleem
    07-19-2015, 01:51 PM Go to last post

  37. Question How to search from a range of cells using the IF function

    Started by Winterfell‎, 07-18-2015 04:14 AM
    5 Attachment(s)
    • 18
    • 1,192
    Glenn Kennedy
    07-19-2015, 01:42 PM Go to last post

  38. [SOLVED] circular reference results from a simple problem

    Started by really old guy‎, 07-11-2015 02:39 PM
    13 Attachment(s)
    • 38
    • 1,787
    JohnTopley
    07-19-2015, 01:39 PM Go to last post

  39. [SOLVED] Sumifs with OR/AND array using cell references

    Started by baijixu‎, 07-17-2015 10:00 PM
    1 Attachment(s)
    • 5
    • 3,597
    Tony Valko
    07-19-2015, 11:04 AM Go to last post

  40. Overwrite conditioning to highlight cell

    Started by AmazingTrans‎, 07-18-2015 10:56 PM
    2 Attachment(s)
    • 1
    • 797
    DBY
    07-19-2015, 10:27 AM Go to last post

  41. Working out median whilst filtering on participant number and trial type

    Started by Rachel_King‎, 07-19-2015 09:27 AM
    1 Attachment(s)
    • 2
    • 628
    Rachel_King
    07-19-2015, 10:14 AM Go to last post

  42. [SOLVED] INDEX - MATCH on two Criteria with wildcard

    Started by SrDurham‎, 07-18-2015 05:18 PM
    2 Attachment(s)
    • 2
    • 5,824
    Czeslaw
    07-19-2015, 09:04 AM Go to last post

  43. [help] how to sum up values for every day/week/weekday

    Started by BigRo‎, 07-18-2015 12:02 PM
    • 2
    • 617
    BigRo
    07-19-2015, 09:00 AM Go to last post

  44. Unhappy [SOLVED] Help with error #n/a when using dates as cell values

    Started by navanee‎, 07-17-2015 09:32 AM
    3 Attachment(s)
    • 15
    • 932
    Glenn Kennedy
    07-19-2015, 07:45 AM Go to last post

  45. [SOLVED] sum of total identical DC numbers

    Started by Syed Waqar Ali‎, 07-19-2015 04:29 AM
    sum, total idential dc 3 Attachment(s)
    • 9
    • 963
    cbatrody
    07-19-2015, 07:25 AM Go to last post

  46. [SOLVED] Formula to show a reminder

    Started by Saturn‎, 07-16-2015 08:24 AM
    2 Attachment(s)
    • 6
    • 614
    cbatrody
    07-19-2015, 05:57 AM Go to last post

  47. Extract values based on two (2) criteria

    Started by bjnockle‎, 07-16-2015 09:37 PM
    7 Attachment(s)
    • 18
    • 1,404
    bjnockle
    07-19-2015, 04:14 AM Go to last post

  48. CHOOSE function

    Started by fzz‎, 07-18-2015 11:40 PM
    • 1
    • 594
    MarvinP
    07-18-2015, 11:59 PM Go to last post

  49. Using VLookup when the Lookup Value cell contains a formula

    Started by davidshears‎, 07-18-2015 05:39 PM
    • 3
    • 807
    Tony Valko
    07-18-2015, 08:42 PM Go to last post

  50. [SOLVED] Use last calculated data in non-adjacent formula

    Started by rafcaf‎, 07-18-2015 05:19 PM
    1 Attachment(s)
    • 4
    • 511
    Tony Valko
    07-18-2015, 08:41 PM Go to last post
+ Post New Thread
Page 1951 of 5615 FirstFirst ... 1951 ...

Forum Information and Options

Users Browsing this Forum

There are currently 68 users browsing this forum. (2 members & 66 guests)

  1. jarkametelka007,
  2. Lafsen

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