+ Post New Thread
Page 2012 of 5620 FirstFirst ... 2012 ...
Threads 100551 to 100600 of 280956

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

  1. [SOLVED] Return occurences of similar values from text string

    Started by GreenWheels‎, 05-19-2015 07:33 PM
    2 Attachment(s)
    • 17
    • 766
    FlameRetired
    05-21-2015, 11:04 AM Go to last post

  2. [SOLVED] concatenate text values for duplicate entries

    Started by SAsplin‎, 05-21-2015 07:45 AM
    1 Attachment(s)
    • 9
    • 753
    SAsplin
    05-21-2015, 10:44 AM Go to last post

  3. [SOLVED] When using formula SUM it won't show the sum of ALL cells in the column

    Started by lil_malin‎, 05-21-2015 04:49 AM
    2 Attachment(s)
    • 13
    • 562
    lil_malin
    05-21-2015, 10:35 AM Go to last post

  4. [SOLVED] Multi choice formula for time sheet totals not working, wont sum hours

    Started by Dantro‎, 05-21-2015 06:15 AM
    1 Attachment(s)
    • 13
    • 526
    Glenn Kennedy
    05-21-2015, 09:58 AM Go to last post

  5. Win / Loss / draw analysis

    Started by olubitkabuu‎, 05-21-2015 06:17 AM
    • 2
    • 597
    olubitkabuu
    05-21-2015, 09:45 AM Go to last post

  6. Smile Sumif multiple values

    Started by alfi83‎, 05-21-2015 09:25 AM
    sumif critera from list 1 Attachment(s)
    • 2
    • 621
    etaf
    05-21-2015, 09:35 AM Go to last post

  7. [SOLVED] Vlookup with 2 sheets?

    Started by kellyfirth‎, 05-21-2015 09:19 AM
    • 3
    • 352
    kellyfirth
    05-21-2015, 09:32 AM Go to last post

  8. INDEX MATCH IF Between Two Dates - Comparing Two Tables

    Started by #N/A‎, 05-21-2015 09:02 AM
    index, match 1 Attachment(s)
    • 5
    • 1,955
    samba_ravi
    05-21-2015, 09:32 AM Go to last post

  9. [SOLVED] Determine how many minutes exist between start and end time split into hourly bands

    Started by friedgoldmole‎, 05-21-2015 07:31 AM
    1 Attachment(s)
    • 3
    • 421
    friedgoldmole
    05-21-2015, 08:56 AM Go to last post

  10. Create list from lookup

    Started by froggeja‎, 05-20-2015 09:53 AM
    index, lookup, match, sumif, vlookup 1 Attachment(s)
    • 4
    • 661
    Ali Kırksekiz
    05-21-2015, 08:44 AM Go to last post

  11. Question List of duplicates between 2 data sets from multible books

    Started by pardegt‎, 05-19-2015 05:56 PM
    1 Attachment(s)
    • 4
    • 341
    pardegt
    05-21-2015, 08:42 AM Go to last post

  12. Copying data from one sheet to another: only if it's not already on the first sheet?

    Started by Atwellj‎, 05-20-2015 05:12 AM
    4 Attachment(s)
    • 4
    • 414
    kvsrinivasamurthy
    05-21-2015, 08:13 AM Go to last post

  13. Finding highest placed 0 value among bottom series of 0's

    Started by a1b2c3d4e5f6g7h8i9‎, 05-21-2015 07:18 AM
    • 5
    • 385
    a1b2c3d4e5f6g7h8i9
    05-21-2015, 08:13 AM Go to last post

  14. [SOLVED] XML mapping

    Started by Sinep D‎, 05-21-2015 07:43 AM
    • 0
    • 402
    Sinep D
    05-21-2015, 07:43 AM Go to last post

  15. Question [SOLVED] Ignoring asterisk in numeric value

    Started by Mike Brewer‎, 05-21-2015 06:19 AM
    • 4
    • 1,692
    Mike Brewer
    05-21-2015, 06:43 AM Go to last post

  16. plotting max of high and min of low 210515

    Started by thilag‎, 05-21-2015 06:28 AM
    1 Attachment(s)
    • 1
    • 311
    [email protected]
    05-21-2015, 06:33 AM Go to last post

  17. sort dynamically and automatically by color

    Started by EYALIN‎, 05-21-2015 05:44 AM
    automatic sorting, dynamic sort, sort by color
    • 4
    • 485
    EYALIN
    05-21-2015, 06:14 AM Go to last post

  18. index/match formula is pre-inserted, but unable to refresh when source file added

    Started by wongth7‎, 05-21-2015 03:52 AM
    4 Attachment(s)
    • 2
    • 721
    wongth7
    05-21-2015, 05:33 AM Go to last post

  19. Finding the year and month matching todays date and returning a value from adjacent cells

    Started by steve o‎, 05-21-2015 03:40 AM
    • 3
    • 558
    Glenn Kennedy
    05-21-2015, 05:27 AM Go to last post

  20. Multiple Criteria and Multiple sheets

    Started by adpmhel24‎, 05-20-2015 02:34 AM
    5 Attachment(s)
    • 17
    • 978
    adpmhel24
    05-21-2015, 04:39 AM Go to last post

  21. [SOLVED] sumif Formula Help

    Started by gondal‎, 05-21-2015 01:12 AM
    2 Attachment(s)
    • 12
    • 419
    Glenn Kennedy
    05-21-2015, 03:25 AM Go to last post

  22. Difficult formula for Qualifying Loans

    Started by hurley665‎, 05-20-2015 08:35 PM
    • 1
    • 353
    Kaper
    05-21-2015, 02:47 AM Go to last post

  23. Multiple "IF" in One Cell

    Started by TCH86‎, 05-21-2015 01:41 AM
    3 Attachment(s)
    • 8
    • 497
    adhawan06
    05-21-2015, 02:24 AM Go to last post

  24. Unhappy excel formulas doesnt work

    Started by bulina2k‎, 05-20-2015 09:44 AM
    1 Attachment(s)
    • 2
    • 384
    bulina2k
    05-21-2015, 02:18 AM Go to last post

  25. Changing (blank) in a Pivot Table to Alternative Text

    Started by HangMan‎, 05-20-2015 03:34 PM
    • 3
    • 3,045
    adhawan06
    05-21-2015, 02:15 AM Go to last post

  26. Randomly select cells with text. (That are not Blank)

    Started by Ryder03‎, 05-19-2015 04:47 PM
    blank, ramdom, select, text 1 Attachment(s)
    • 8
    • 1,514
    [email protected]
    05-21-2015, 12:43 AM Go to last post

  27. [SOLVED] vlookup pull quantity above 10 pieces

    Started by makinmomb‎, 05-21-2015 12:12 AM
    1 Attachment(s)
    • 4
    • 470
    humdingaling
    05-21-2015, 12:34 AM Go to last post

  28. Help - returning earliest date per machine ID.

    Started by krisgibson‎, 05-18-2015 04:37 PM
    3 Attachment(s)
    • 5
    • 337
    FlameRetired
    05-20-2015, 11:29 PM Go to last post

  29. Unhappy How to average different data points of large data

    Started by Bhim Chaulagain‎, 05-20-2015 04:08 PM
    3 Attachment(s)
    • 9
    • 414
    FlameRetired
    05-20-2015, 10:52 PM Go to last post

  30. [SOLVED] Excel formula - list numbers for unique entries

    Started by jayherring86‎, 05-20-2015 06:01 PM
    excel, formula and functions
    • 6
    • 633
    Tony Valko
    05-20-2015, 10:07 PM Go to last post

  31. Using a dropdown list to check off if inventory arrived (subtract from total)

    Started by leo255‎, 05-19-2015 11:48 AM
    • 4
    • 981
    humdingaling
    05-20-2015, 08:48 PM Go to last post

  32. [SOLVED] Count number days absent for different employees with multiple date ranges.

    Started by monkeypants‎, 05-13-2015 06:55 PM
    3 Attachment(s)
    • 7
    • 1,414
    yay_excel
    05-20-2015, 08:32 PM Go to last post

  33. Auto Highlight Dates

    Started by npolito‎, 05-20-2015 08:18 PM
    • 2
    • 310
    GC Excel
    05-20-2015, 08:32 PM Go to last post

  34. Index Match not Formatting Correctly

    Started by CreamOfWheat‎, 05-20-2015 07:30 PM
    1 Attachment(s)
    • 2
    • 471
    jhren
    05-20-2015, 07:53 PM Go to last post

  35. Count Unique with Criteria

    Started by david0985‎, 05-20-2015 05:41 PM
    frequency 1 Attachment(s)
    • 1
    • 800
    daffodil11
    05-20-2015, 07:36 PM Go to last post

  36. Question Formula for moving entire row once data in entered into a column

    Started by shantelcollins‎, 05-20-2015 05:36 PM
    • 1
    • 397
    jhren
    05-20-2015, 07:35 PM Go to last post

  37. Need to Auto Format Sheet based on available data on table

    Started by dharrier‎, 05-19-2015 03:46 PM
    2 Attachment(s)
    • 5
    • 486
    FlameRetired
    05-20-2015, 07:06 PM Go to last post

  38. [SOLVED] Issue with my table not autofilling

    Started by MikeSta4ord‎, 05-19-2015 06:47 PM
    2 Attachment(s)
    • 7
    • 440
    jhren
    05-20-2015, 07:02 PM Go to last post

  39. Formula When Date Entered in One Cell Another Cell Increases or Decreases by 1

    Started by staffnu123‎, 05-19-2015 01:56 PM
    5 Attachment(s)
    • 12
    • 850
    jhren
    05-20-2015, 06:56 PM Go to last post

  40. Variable formula

    Started by lilmike14‎, 05-20-2015 06:27 PM
    • 1
    • 307
    TMS
    05-20-2015, 06:35 PM Go to last post

  41. Index/Match Return is an Error but Only at the Top of List

    Started by kate isgreat‎, 05-20-2015 03:50 PM
    • 1
    • 410
    TMS
    05-20-2015, 06:12 PM Go to last post

  42. Index Match Formula and Copy Row

    Started by CreamOfWheat‎, 05-20-2015 05:11 PM
    1 Attachment(s)
    • 4
    • 386
    CreamOfWheat
    05-20-2015, 05:55 PM Go to last post

  43. Returning Highest Value in Countif

    Started by riff100‎, 05-20-2015 03:43 PM
    • 2
    • 694
    riff100
    05-20-2015, 05:48 PM Go to last post

  44. Trying to move SUMPRODUCT formula to SUMIFS

    Started by chimelle‎, 05-20-2015 04:35 PM
    sumifs, sumproduct 1 Attachment(s)
    • 3
    • 554
    Jonmo1
    05-20-2015, 05:08 PM Go to last post

  45. Question Conditional formatting - multiple values

    Started by glassen89‎, 05-20-2015 03:52 PM
    conditional formatting, multiple search variables 4 Attachment(s)
    • 5
    • 520
    glassen89
    05-20-2015, 05:03 PM Go to last post

  46. Indirect function help

    Started by GAS-CO‎, 05-19-2015 02:56 PM
    • 2
    • 403
    GAS-CO
    05-20-2015, 05:00 PM Go to last post

  47. [SOLVED] Best method to calculate month-end balance of deferred revenue

    Started by sginsy‎, 05-20-2015 02:34 PM
    deferred, running balance 1 Attachment(s)
    • 7
    • 2,993
    samba_ravi
    05-20-2015, 04:59 PM Go to last post

  48. [SOLVED] Multiple Criteria formulas

    Started by matrixpom‎, 05-20-2015 01:21 AM
    3 Attachment(s)
    • 4
    • 496
    matrixpom
    05-20-2015, 04:24 PM Go to last post

  49. return selected Cell ; minimze function

    Started by tomstruis‎, 05-20-2015 03:50 PM
    • 6
    • 416
    tomstruis
    05-20-2015, 04:18 PM Go to last post

  50. How to merge four line graphs with each two drawn in different scales

    Started by Bhim Chaulagain‎, 05-20-2015 01:30 PM
    2 Attachment(s)
    • 4
    • 524
    Bhim Chaulagain
    05-20-2015, 03:59 PM Go to last post
+ Post New Thread
Page 2012 of 5620 FirstFirst ... 2012 ...

Forum Information and Options

Users Browsing this Forum

There are currently 111 users browsing this forum. (3 members & 108 guests)

  1. faisal02,
  2. Phuocam,
  3. wlwlwl

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