+ Post New Thread
Page 1491 of 5614 FirstFirst ... 1491 ...
Threads 74501 to 74550 of 280696

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. VLOOKUP connecting cells that have slightly different spellings

    Started by poonam.ss‎, 02-17-2017 03:41 PM
    2 Attachment(s)
    • 5
    • 310
    JohnTopley
    02-17-2017, 05:28 PM Go to last post

  2. Counting a range of cells with dates within a certain range

    Started by MSE‎, 02-17-2017 11:01 AM
    2 Attachment(s)
    • 7
    • 602
    MSE
    02-17-2017, 05:03 PM Go to last post

  3. [SOLVED] Alternative to using an array in an Index or similar function?

    Started by aquixano‎, 02-17-2017 04:15 PM
    1 Attachment(s)
    • 2
    • 387
    aquixano
    02-17-2017, 04:57 PM Go to last post

  4. Can you help tansposing this formula...

    Started by kikola123‎, 02-17-2017 03:57 PM
    1 Attachment(s)
    • 2
    • 218
    kikola123
    02-17-2017, 04:28 PM Go to last post

  5. [SOLVED] data validation formula

    Started by max_max‎, 02-15-2017 02:15 PM
    3 Attachment(s)
    • 28
    • 1,048
    max_max
    02-17-2017, 04:13 PM Go to last post

  6. How to Lock a Row once Text is entered into a particular column

    Started by WayOverMyHead‎, 02-17-2017 01:44 PM
    • 1
    • 290
    mehmetcik
    02-17-2017, 03:08 PM Go to last post

  7. [SOLVED] sumif ?

    Started by stuhendry‎, 02-16-2017 01:50 PM
    • 9
    • 442
    AliGW
    02-17-2017, 02:02 PM Go to last post

  8. [SOLVED] Rearranging VLOOKUP formula

    Started by Catsonheat‎, 02-17-2017 01:05 PM
    • 2
    • 346
    Catsonheat
    02-17-2017, 01:53 PM Go to last post

  9. [SOLVED] Vlookup

    Started by Hmutual‎, 02-17-2017 12:50 PM
    • 4
    • 264
    AliGW
    02-17-2017, 01:41 PM Go to last post

  10. [SOLVED] Fill range of cells based on matches in multiple cells

    Started by VidOs‎, 02-17-2017 12:50 PM
    1 Attachment(s)
    • 3
    • 333
    BillyRaySpivy
    02-17-2017, 01:08 PM Go to last post

  11. Question GetPivotData #REF error

    Started by Dave.Taylor‎, 02-15-2017 03:38 PM
    2 Attachment(s)
    • 4
    • 4,960
    Dave.Taylor
    02-17-2017, 01:05 PM Go to last post

  12. Template for calculating overtime over time periods--semi monthly pay

    Started by smiley22124‎, 09-12-2015 06:41 PM
    • 2
    • 706
    JohnTopley
    02-17-2017, 12:50 PM Go to last post

  13. Using an Array formula within a standard one

    Started by pjwhitfield‎, 02-17-2017 11:46 AM
    • 3
    • 297
    bebo021999
    02-17-2017, 12:50 PM Go to last post

  14. Use VLOOKUP and conditional formatting?

    Started by Bow To The Robots‎, 02-14-2017 06:36 PM
    2 Attachment(s)
    • 6
    • 1,278
    Tbez
    02-17-2017, 12:48 PM Go to last post

  15. Semi monthly overtime tracker

    Started by melanieh‎, 02-17-2017 12:25 PM
    • 1
    • 697
    JohnTopley
    02-17-2017, 12:32 PM Go to last post

  16. Cool Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

    Started by amthyst826‎, 02-17-2017 11:59 AM
    • 4
    • 1,928
    Arkadi
    02-17-2017, 12:26 PM Go to last post

  17. Returning an answer based on most recent date

    Started by eizkam‎, 02-17-2017 11:23 AM
    date, search and display 2 Attachment(s)
    • 6
    • 620
    Pete_UK
    02-17-2017, 12:26 PM Go to last post

  18. Find missing values - interpolate data

    Started by marielouise1‎, 02-17-2017 05:08 AM
    2 Attachment(s)
    • 3
    • 1,593
    JeteMc
    02-17-2017, 12:20 PM Go to last post

  19. [SOLVED] Match, Hlookup or?? to relocate and match up data to sorted data

    Started by greenfox74‎, 02-16-2017 03:52 AM
    2 Attachment(s)
    • 11
    • 648
    FlameRetired
    02-17-2017, 12:19 PM Go to last post

  20. Independent cell fill colour formula from one set of 4 standard list options

    Started by Fisayo‎, 02-17-2017 09:34 AM
    2 Attachment(s)
    • 2
    • 406
    Fisayo
    02-17-2017, 11:27 AM Go to last post

  21. [SOLVED] Circular Reference with HYPERLINK and FORMULATEXT: why?

    Started by Requin‎, 02-17-2017 07:22 AM
    circular reference error, formulatext, hyperlink 1 Attachment(s)
    • 4
    • 2,648
    Requin
    02-17-2017, 11:07 AM Go to last post

  22. IF Formula to Highlight Sales Order

    Started by MEDIUMRARESTEAK‎, 02-16-2017 10:28 PM
    1 Attachment(s)
    • 2
    • 464
    MEDIUMRARESTEAK
    02-17-2017, 11:04 AM Go to last post

  23. [SOLVED] Cannot get date to change down column.

    Started by scudo‎, 02-17-2017 07:28 AM
    1 Attachment(s)
    • 6
    • 423
    scudo
    02-17-2017, 10:52 AM Go to last post

  24. Formula: Split text + number

    Started by ScaniaR730‎, 02-17-2017 07:10 AM
    7 Attachment(s)
    • 11
    • 1,154
    AlKey
    02-17-2017, 10:42 AM Go to last post

  25. Icon Sets on a different cell based on formulas and/or values on different cells

    Started by dluhut‎, 02-16-2017 05:54 PM
    2 Attachment(s)
    • 1
    • 435
    bernieburnham
    02-17-2017, 10:25 AM Go to last post

  26. Create a summary report of ordered items from multiple worksheets help

    Started by scsuflyboy‎, 02-16-2017 05:56 PM
    4 Attachment(s)
    • 3
    • 553
    scsuflyboy
    02-17-2017, 10:23 AM Go to last post

  27. Help with finding and copying

    Started by mada34‎, 02-16-2017 12:09 PM
    1 Attachment(s)
    • 3
    • 437
    mada34
    02-17-2017, 09:29 AM Go to last post

  28. [SOLVED] Populate cells when a cell matches another criteria

    Started by Catsonheat‎, 02-16-2017 08:21 PM
    • 6
    • 394
    Pete_UK
    02-17-2017, 09:23 AM Go to last post

  29. [SOLVED] How Many Days Fall in Each Month Between Two Dates

    Started by skate1991‎, 02-17-2017 05:21 AM
    1 Attachment(s)
    • 5
    • 553
    Pete_UK
    02-17-2017, 09:21 AM Go to last post

  30. Help needed for fender bender budget sheet! Formulas

    Started by Jamie5358‎, 02-17-2017 08:56 AM
    accounting in excel, formula and functions, formula and if statement, geriatric! 1 Attachment(s)
    • 2
    • 434
    Jamie5358
    02-17-2017, 09:11 AM Go to last post

  31. Compare two time values and copy data

    Started by nnish‎, 02-17-2017 08:40 AM
    1 Attachment(s)
    • 2
    • 280
    nnish
    02-17-2017, 09:06 AM Go to last post

  32. Adding "Zeros" to Make a uniform Numberic Code ( Not Text) Only zeros as number

    Started by MQKAMAL‎, 02-17-2017 08:18 AM
    3 Attachment(s)
    • 5
    • 351
    avk
    02-17-2017, 08:51 AM Go to last post

  33. Applying a Conditional Formula to a Subtotaled Column

    Started by two_bone35‎, 02-16-2017 06:50 PM
    2 Attachment(s)
    • 3
    • 319
    two_bone35
    02-17-2017, 08:23 AM Go to last post

  34. [SOLVED] Tweaking SUMPRODUCT formua to include SUBTOTAL

    Started by chilli76‎, 02-17-2017 06:44 AM
    • 9
    • 488
    Haseeb Avarakkan
    02-17-2017, 08:16 AM Go to last post

  35. [SOLVED] Smallest date in 10 columns

    Started by Travman1986‎, 02-17-2017 07:04 AM
    1 Attachment(s)
    • 5
    • 345
    Travman1986
    02-17-2017, 07:59 AM Go to last post

  36. Hyperlink that opens a file with different extensions (VBA)

    Started by Scavenger102‎, 02-17-2017 04:03 AM
    2 Attachment(s)
    • 8
    • 330
    Scavenger102
    02-17-2017, 07:51 AM Go to last post

  37. How do I calculate the average of a column so that it automatically changes?

    Started by Imanob‎, 02-17-2017 04:58 AM
    average
    • 3
    • 466
    Imanob
    02-17-2017, 06:31 AM Go to last post

  38. Conditional Formatting

    Started by vainhitman‎, 02-17-2017 04:52 AM
    conditional, conditional formatting, formatting cells from vba 1 Attachment(s)
    • 2
    • 558
    davsth
    02-17-2017, 05:11 AM Go to last post

  39. [SOLVED] Saving An Excel File With A Cell Value

    Started by Streaky‎, 02-17-2017 04:18 AM
    • 2
    • 3,629
    Streaky
    02-17-2017, 04:34 AM Go to last post

  40. [SOLVED] how to count cells with values but ignore blank cells with formula and in a month?

    Started by Imran Magsi‎, 02-16-2017 04:03 AM
    2 Attachment(s)
    • 10
    • 968
    Imran Magsi
    02-17-2017, 03:58 AM Go to last post

  41. [SOLVED] Calculating weighted average with looked up values

    Started by simz92‎, 02-13-2017 01:53 AM
    3 Attachment(s)
    • 7
    • 629
    JohnTopley
    02-17-2017, 03:42 AM Go to last post

  42. [SOLVED] Add 1 to a number from the worksheet before it

    Started by SVTF‎, 02-17-2017 02:51 AM
    1 Attachment(s)
    • 5
    • 276
    AliGW
    02-17-2017, 03:31 AM Go to last post

  43. [SOLVED] Match a cell value in another sheet and copy values below the cell (Index Match)

    Started by naga‎, 02-17-2017 01:41 AM
    1 Attachment(s)
    • 5
    • 467
    FDibbins
    02-17-2017, 03:14 AM Go to last post

  44. How to repeat row for a specific number of times (specifed in last column)

    Started by Matteo83‎, 02-16-2017 10:16 AM
    5 Attachment(s)
    • 7
    • 928
    canapone
    02-17-2017, 02:45 AM Go to last post

  45. Worksheet to record input and output of expenses and returns

    Started by Syed Ali Khalil‎, 02-17-2017 01:12 AM
    • 1
    • 429
    AliGW
    02-17-2017, 02:36 AM Go to last post

  46. sum unique values with multiple criteria

    Started by tahas‎, 02-17-2017 01:41 AM
    • 1
    • 336
    samba_ravi
    02-17-2017, 02:03 AM Go to last post

  47. Calculating Handicaps

    Started by blarmour‎, 02-16-2017 08:34 AM
    1 Attachment(s)
    • 4
    • 4,541
    guru008
    02-16-2017, 11:08 PM Go to last post

  48. [SOLVED] If value of one cell is in nth number lowest values of a range

    Started by naimickmac23‎, 02-16-2017 04:56 PM
    small 1 Attachment(s)
    • 4
    • 440
    naimickmac23
    02-16-2017, 11:05 PM Go to last post

  49. [SOLVED] Vlookup of a date across sheets using two columns

    Started by adam_d_john‎, 02-16-2017 08:56 PM
    1 Attachment(s)
    • 3
    • 266
    jeffreybrown
    02-16-2017, 09:58 PM Go to last post

  50. Use Indirect Formula Correctly

    Started by rodcryderman‎, 02-16-2017 07:00 PM
    1 Attachment(s)
    • 5
    • 278
    rodcryderman
    02-16-2017, 09:22 PM Go to last post
+ Post New Thread
Page 1491 of 5614 FirstFirst ... 1491 ...

Forum Information and Options

Users Browsing this Forum

There are currently 56 users browsing this forum. (4 members & 52 guests)

  1. ExcelNewbie92,
  2. GregKr,
  3. JohnTopley,
  4. Rick Rothstein

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