+ Post New Thread
Page 2501 of 5615 FirstFirst ... 2501 ...
Threads 125001 to 125050 of 280713

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. Formula to Separate Values in Execel

    Started by bjnockle‎, 02-26-2014 09:55 PM
    • 9
    • 1,237
    bebo021999
    02-28-2014, 05:40 AM Go to last post

  2. [SOLVED] Multiple cells to get value into one cell

    Started by Bunny Screen‎, 02-27-2014 11:03 AM
    2 Attachment(s)
    • 4
    • 434
    Bunny Screen
    02-28-2014, 05:30 AM Go to last post

  3. Copy cell value from another worksheet and duplicate value to two rows

    Started by wintheranders‎, 02-28-2014 04:55 AM
    2 Attachment(s)
    • 2
    • 434
    :) Sixthsense :)
    02-28-2014, 05:16 AM Go to last post

  4. Unhappy IF Formular with Average Formular

    Started by Ginger2k9‎, 02-25-2014 12:22 PM
    • 12
    • 1,020
    Ginger2k9
    02-28-2014, 04:56 AM Go to last post

  5. [SOLVED] IF function to return a number value based on various text options

    Started by metrohike‎, 02-27-2014 08:03 AM
    8 Attachment(s)
    • 31
    • 1,975
    metrohike
    02-28-2014, 04:47 AM Go to last post

  6. Count how often value changes in a column, ignoring blank cells

    Started by flyaway‎, 02-27-2014 09:41 AM
    1 Attachment(s)
    • 1
    • 1,424
    :) Sixthsense :)
    02-28-2014, 04:09 AM Go to last post

  7. formula to create a new table based on two source table

    Started by krazyhype19‎, 02-28-2014 03:59 AM
    1 Attachment(s)
    • 1
    • 531
    :) Sixthsense :)
    02-28-2014, 04:04 AM Go to last post

  8. duplicate serial numbers with multiple cells of text

    Started by drawdejay‎, 02-27-2014 12:54 PM
    4 Attachment(s)
    • 3
    • 900
    azumi
    02-28-2014, 02:36 AM Go to last post

  9. Question How to calculate daily hourly rate as well as overtime rate on a weekly basis?!

    Started by DanGeorge‎, 02-27-2014 10:12 PM
    • 1
    • 953
    David A Coop
    02-28-2014, 02:31 AM Go to last post

  10. Help with arrary formula

    Started by ammartino44‎, 02-24-2014 06:44 PM
    • 6
    • 682
    AliGW
    02-28-2014, 02:29 AM Go to last post

  11. [SOLVED] Rounding by Varying Multiples

    Started by ldoherty‎, 02-27-2014 06:47 PM
    1 Attachment(s)
    • 3
    • 627
    FDibbins
    02-28-2014, 02:13 AM Go to last post

  12. [SOLVED] Vlookup throwing incorrect value when pulled up

    Started by smvsiyer‎, 02-28-2014 01:10 AM
    vlookup
    • 3
    • 529
    smvsiyer
    02-28-2014, 01:54 AM Go to last post

  13. [SOLVED] Variable Cell Reference

    Started by Tyr@work‎, 11-16-2007 06:43 PM
    • 5
    • 42,570
    arlu1201
    02-28-2014, 01:23 AM Go to last post

  14. [SOLVED] Vlookup or another way? Ideas please

    Started by lcartwright‎, 02-27-2014 11:53 PM
    2 Attachment(s)
    • 3
    • 381
    NeedForExcel
    02-28-2014, 12:55 AM Go to last post

  15. How to stop =Today() from update after EOM

    Started by LolaLee‎, 02-27-2014 04:51 PM
    =today(), run rate
    • 3
    • 778
    NeedForExcel
    02-28-2014, 12:48 AM Go to last post

  16. [SOLVED] Sum cells adjacent to LARGE cells.

    Started by Toonce‎, 02-27-2014 02:57 AM
    • 9
    • 650
    Toonce
    02-28-2014, 12:45 AM Go to last post

  17. [SOLVED] Calculate best Margin

    Started by cell-dweller‎, 02-27-2014 09:13 PM
    1 Attachment(s)
    • 3
    • 611
    shg
    02-28-2014, 12:40 AM Go to last post

  18. [SOLVED] problem with countifs

    Started by albert28‎, 02-27-2014 03:58 AM
    3 Attachment(s)
    • 9
    • 935
    vlady
    02-27-2014, 11:16 PM Go to last post

  19. [SOLVED] Determining what "zone" a value falls in a scatter plot

    Started by janeml‎, 02-27-2014 10:42 PM
    1 Attachment(s)
    • 1
    • 528
    MarvinP
    02-27-2014, 11:04 PM Go to last post

  20. Lightbulb Put items with hours into a category of Hourly, Daily, Weekly

    Started by bluelulu‎, 02-27-2014 07:15 PM
    1 Attachment(s)
    • 2
    • 485
    bluelulu
    02-27-2014, 09:27 PM Go to last post

  21. [SOLVED] vlookup

    Started by lamdl‎, 02-27-2014 08:47 PM
    1 Attachment(s)
    • 1
    • 386
    vlady
    02-27-2014, 08:53 PM Go to last post

  22. [SOLVED] Function to match contents of comments ?

    Started by elgato74‎, 02-27-2014 06:45 PM
    2 Attachment(s)
    • 7
    • 643
    AlKey
    02-27-2014, 08:28 PM Go to last post

  23. Inconsistent results for formula

    Started by Maxwel‎, 02-27-2014 11:49 AM
    • 2
    • 558
    Maxwel
    02-27-2014, 08:04 PM Go to last post

  24. [SOLVED] Matching two tables, copying data for matching value

    Started by Gatis‎, 02-27-2014 06:02 PM
    looking up data, matching, two tables 1 Attachment(s)
    • 2
    • 674
    ajryan88
    02-27-2014, 07:51 PM Go to last post

  25. [SOLVED] Using Indirect to link dynamically with another work book

    Started by Journeyman3000‎, 02-27-2014 06:07 PM
    • 5
    • 762
    ajryan88
    02-27-2014, 07:31 PM Go to last post

  26. Post Excel IF function shows incorrect result

    Started by johnhotrod‎, 02-27-2014 05:45 PM
    • 5
    • 7,513
    johnhotrod
    02-27-2014, 06:59 PM Go to last post

  27. [SOLVED] Vlookup across two instances of Excel (2 seperate workbooks)

    Started by Metrazal‎, 02-27-2014 06:11 PM
    • 1
    • 1,807
    Izandol
    02-27-2014, 06:39 PM Go to last post

  28. Looking to sum every 3rd column (that's showing) but stop after 6 of them (rolling 6 weeks

    Started by epiphany33‎, 02-27-2014 03:38 PM
    1 Attachment(s)
    • 5
    • 867
    FDibbins
    02-27-2014, 06:34 PM Go to last post

  29. Having Issues with Conditional Formatting...

    Started by tatumrae‎, 02-27-2014 02:28 PM
    1 Attachment(s)
    • 3
    • 538
    protonLeah
    02-27-2014, 06:30 PM Go to last post

  30. Index/Match with multiple criteria

    Started by ccwynar‎, 02-27-2014 01:01 PM
    1 Attachment(s)
    • 2
    • 608
    ccwynar
    02-27-2014, 06:25 PM Go to last post

  31. Struggling with using IF and IF(AND) formulas

    Started by jbw1975‎, 02-27-2014 01:28 PM
    • 3
    • 484
    jbw1975
    02-27-2014, 05:56 PM Go to last post

  32. Help with formula - Cant understand the numbers

    Started by constructionsheets‎, 02-27-2014 05:35 PM
    formula, math
    • 0
    • 537
    constructionsheets
    02-27-2014, 05:35 PM Go to last post

  33. Another data validation list issue...

    Started by Syntagma‎, 02-26-2014 07:15 PM
    2 Attachment(s)
    • 7
    • 697
    Syntagma
    02-27-2014, 05:30 PM Go to last post

  34. [SOLVED] Lookup with 2 criteria

    Started by Excel_learner‎, 02-27-2014 01:06 PM
    2 Attachment(s)
    • 9
    • 529
    Tony Valko
    02-27-2014, 05:29 PM Go to last post

  35. looking up values from different sheets into one.

    Started by RozieTK‎, 02-25-2014 04:36 AM
    excel & macro, if then excell, vba, vlookup 1 Attachment(s)
    • 2
    • 502
    RozieTK
    02-27-2014, 05:23 PM Go to last post

  36. Creating an external reference with a variable

    Started by ruslruslrusl‎, 02-27-2014 12:10 PM
    external reference, variable cell reference
    • 9
    • 4,105
    alansidman
    02-27-2014, 05:12 PM Go to last post

  37. Post Conditional Formatting/ Scheduling Trade Partners

    Started by johnplyer‎, 02-27-2014 03:32 PM
    1 Attachment(s)
    • 2
    • 428
    johnplyer
    02-27-2014, 05:06 PM Go to last post

  38. [SOLVED] Easier way to reference other cells for the end and start points for average formulas?

    Started by joeGBL‎, 02-27-2014 04:19 PM
    • 4
    • 494
    Pete_UK
    02-27-2014, 04:58 PM Go to last post

  39. [SOLVED] Current CST time formula

    Started by shiva_reshs‎, 02-27-2014 12:53 PM
    • 7
    • 1,372
    shiva_reshs
    02-27-2014, 04:25 PM Go to last post

  40. Inventory Problem

    Started by LMOORE‎, 02-27-2014 03:15 PM
    2 Attachment(s)
    • 7
    • 524
    LMOORE
    02-27-2014, 04:17 PM Go to last post

  41. [SOLVED] Formula to find the MODE and AVERAGE of Roman Numerals

    Started by nwb‎, 02-26-2014 05:24 PM
    • 4
    • 1,145
    ajryan88
    02-27-2014, 03:47 PM Go to last post

  42. [SOLVED] Networkdays formula

    Started by Lukael‎, 02-27-2014 03:36 AM
    • 7
    • 775
    Pepe Le Mokko
    02-27-2014, 03:47 PM Go to last post

  43. [SOLVED] Networkdays formula - negative result

    Started by Lukael‎, 02-27-2014 03:09 PM
    • 3
    • 1,669
    Lukael
    02-27-2014, 03:47 PM Go to last post

  44. [SOLVED] Count Formula for Matches in One Column and Mismatches in Another

    Started by xcel-noob‎, 02-25-2014 03:40 PM
    1 Attachment(s)
    • 4
    • 1,712
    Tony Valko
    02-27-2014, 03:46 PM Go to last post

  45. [SOLVED] Using a formula for "value_if_true"

    Started by GoldDawn‎, 02-27-2014 02:26 PM
    formula, value_if_true
    • 5
    • 859
    Tony Valko
    02-27-2014, 03:45 PM Go to last post

  46. [SOLVED] Format numbers on the x-axis of Chart

    Started by maacmaac‎, 02-27-2014 02:56 PM
    1 Attachment(s)
    • 1
    • 1,676
    Kaper
    02-27-2014, 03:31 PM Go to last post

  47. [SOLVED] Convert Date/Time Difference to total Minutes

    Started by Beachmonkey‎, 02-27-2014 02:30 PM
    • 3
    • 410
    Tony Valko
    02-27-2014, 03:05 PM Go to last post

  48. Lightbulb [SOLVED] Saving to Different Columns on Sucessive Clicks (Excel 07)

    Started by dsmith7610‎, 02-26-2014 04:17 PM
    saving data, shift cells 1 Attachment(s)
    • 7
    • 696
    tigeravatar
    02-27-2014, 02:52 PM Go to last post

  49. Separating a range of values into equal sum groups

    Started by SMUSIC07‎, 02-27-2014 02:17 PM
    1 Attachment(s)
    • 2
    • 2,099
    Moo the Dog
    02-27-2014, 02:36 PM Go to last post

  50. Count with multiple criteria from a closed workbook

    Started by rcharity23‎, 02-25-2014 11:14 PM
    closed workbook, countifs, multiple criteria
    • 9
    • 3,862
    rcharity23
    02-27-2014, 02:33 PM Go to last post
+ Post New Thread
Page 2501 of 5615 FirstFirst ... 2501 ...

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