+ Post New Thread
Page 1551 of 5615 FirstFirst ... 1551 ...
Threads 77501 to 77550 of 280712

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. Very odd!!

    Started by Victorthesecond‎, 11-15-2016 03:01 PM
    1 Attachment(s)
    • 11
    • 413
    zbor
    11-15-2016, 05:11 PM Go to last post

  2. Question Need to import a single cell value from thousands of csv - Without opening a dialog box ev

    Started by joshneedscoffee‎, 11-15-2016 04:20 PM
    csv import, excel 2010, hyperlink, import data, import data to excel
    • 1
    • 531
    cytop
    11-15-2016, 04:51 PM Go to last post

  3. check in which range a date falls and return a specific value

    Started by beltzer‎, 11-15-2016 04:11 PM
    1 Attachment(s)
    • 4
    • 412
    Tony Valko
    11-15-2016, 04:29 PM Go to last post

  4. Question [SOLVED] Formula not using decimal value for compare

    Started by WiredDriver‎, 11-15-2016 03:27 PM
    2 Attachment(s)
    • 3
    • 263
    WiredDriver
    11-15-2016, 03:52 PM Go to last post

  5. Formula which give you start position based on input

    Started by vba1234‎, 11-15-2016 02:57 PM
    2 Attachment(s)
    • 6
    • 428
    vba1234
    11-15-2016, 03:41 PM Go to last post

  6. Populate cell based on lookup

    Started by magdalenakuf‎, 11-15-2016 02:42 PM
    excel, lookup
    • 1
    • 981
    Richard Buttrey
    11-15-2016, 02:46 PM Go to last post

  7. [SOLVED] Manually editing a cell from a drop down list without effecting VLOOKUP values

    Started by Sweet Vickster‎, 11-05-2016 06:55 PM
    1 Attachment(s)
    • 10
    • 1,014
    Sweet Vickster
    11-15-2016, 02:16 PM Go to last post

  8. Can this be right? Excel has no XOR function???

    Started by LSB M‎, 07-25-2006 03:17 AM
    • 8
    • 51,320
    zweiblumen
    11-15-2016, 01:11 PM Go to last post

  9. Calculating Percentages based on certain criteria

    Started by NimaHak85‎, 11-15-2016 12:37 PM
    multiple conditions, percentages
    • 2
    • 483
    JohnTopley
    11-15-2016, 01:08 PM Go to last post

  10. interest calculations for delayed payments made in parts.

    Started by rakeshshethia‎, 11-11-2016 03:13 AM
    3 Attachment(s)
    • 6
    • 1,406
    JeteMc
    11-15-2016, 12:35 PM Go to last post

  11. Exclamation Vlookup with Left function help!

    Started by vlookup7‎, 11-15-2016 12:09 PM
    1 Attachment(s)
    • 2
    • 469
    AlKey
    11-15-2016, 12:23 PM Go to last post

  12. [SOLVED] Want changes in "if" function

    Started by rajeshn_in‎, 11-15-2016 09:17 AM
    2 Attachment(s)
    • 6
    • 356
    rajeshn_in
    11-15-2016, 12:22 PM Go to last post

  13. How to Convert " ## to ##" to "##"?

    Started by excelLent101‎, 11-14-2016 11:29 PM
    • 4
    • 411
    JBeaucaire
    11-15-2016, 12:08 PM Go to last post

  14. Help with CountIf (assuming it is countif)

    Started by ClawzCTR‎, 11-15-2016 10:39 AM
    1 Attachment(s)
    • 5
    • 276
    Glenn Kennedy
    11-15-2016, 11:58 AM Go to last post

  15. Question PASTE into a locked cell on a protected sheet

    Started by scottli‎, 11-11-2016 06:07 PM
    • 3
    • 1,313
    scottli
    11-15-2016, 11:51 AM Go to last post

  16. [SOLVED] Top three risults for every value

    Started by dielug‎, 11-14-2016 10:44 AM
    2 Attachment(s)
    • 4
    • 456
    dielug
    11-15-2016, 11:44 AM Go to last post

  17. [SOLVED] Index Match function for Bonus Payout table

    Started by Alphabex‎, 11-15-2016 09:27 AM
    1 Attachment(s)
    • 3
    • 409
    Alphabex
    11-15-2016, 11:28 AM Go to last post

  18. Counting the number of cells between two cells - NOT Countif

    Started by formexcel‎, 11-15-2016 10:38 AM
    1 Attachment(s)
    • 4
    • 448
    Glenn Kennedy
    11-15-2016, 10:52 AM Go to last post

  19. Formula pulling data from rows and columns, or another way to concatenate - HELP PLEASE!

    Started by brienne‎, 11-15-2016 09:29 AM
    • 2
    • 249
    igormigor
    11-15-2016, 10:38 AM Go to last post

  20. Exclamation How to use Pivot table showing rows of data?

    Started by Ftsoi‎, 11-14-2016 10:37 PM
    pivot, pivot chart formatting 3 Attachment(s)
    • 2
    • 578
    Ftsoi
    11-15-2016, 10:19 AM Go to last post

  21. HLookup (reverse engineering assistance)

    Started by Jill Pleau‎, 11-15-2016 09:49 AM
    2 Attachment(s)
    • 4
    • 612
    Jonmo1
    11-15-2016, 10:15 AM Go to last post

  22. Vlookup with IF

    Started by dzarur‎, 11-15-2016 07:24 AM
    2 Attachment(s)
    • 9
    • 366
    dzarur
    11-15-2016, 10:00 AM Go to last post

  23. Group each set of duplicate numbers

    Started by bennieboi20‎, 11-15-2016 08:20 AM
    1 Attachment(s)
    • 2
    • 258
    bennieboi20
    11-15-2016, 09:53 AM Go to last post

  24. How to compare two values to pull data from another sheet?

    Started by keychain‎, 11-15-2016 05:24 AM
    3 Attachment(s)
    • 8
    • 476
    JohnTopley
    11-15-2016, 08:03 AM Go to last post

  25. How to compare two values to pull data from another sheet?

    Started by keychain‎, 11-15-2016 05:17 AM
    2 Attachment(s)
    • 4
    • 482
    avk
    11-15-2016, 07:56 AM Go to last post

  26. [SOLVED] drag-down of indirect function does not change cell reference within " "

    Started by alsan‎, 11-14-2016 04:24 PM
    1 Attachment(s)
    • 3
    • 442
    alsan
    11-15-2016, 07:09 AM Go to last post

  27. [SOLVED] Function or Macro to Sum data from a production plan report

    Started by tompee29‎, 11-15-2016 06:21 AM
    2 Attachment(s)
    • 5
    • 353
    tompee29
    11-15-2016, 07:06 AM Go to last post

  28. [SOLVED] Formula Sumifs with Index Match not working

    Started by vba1234‎, 11-15-2016 05:59 AM
    1 Attachment(s)
    • 7
    • 1,062
    JohnTopley
    11-15-2016, 06:37 AM Go to last post

  29. Dr or Cr Custom Number Format - Explanation Needed

    Started by Alienontherun‎, 11-15-2016 06:07 AM
    • 3
    • 617
    Alienontherun
    11-15-2016, 06:20 AM Go to last post

  30. [SOLVED] how to sum up amount of books' price using "x" marked?

    Started by pejoi‎, 11-15-2016 05:23 AM
    sum up, x marked 1 Attachment(s)
    • 3
    • 444
    pejoi
    11-15-2016, 05:42 AM Go to last post

  31. [SOLVED] Check for date conflicts when resources are assigned to them

    Started by TinyDamooge‎, 11-15-2016 04:37 AM
    conflict, date, dates, formula 1 Attachment(s)
    • 4
    • 738
    José Augusto
    11-15-2016, 05:27 AM Go to last post

  32. [SOLVED] Help with Linear Programming Problem (Solver function)

    Started by smotwani_‎, 11-14-2016 11:54 AM
    excel, linear, linear programming, programming, solver 1 Attachment(s)
    • 5
    • 1,299
    Alf
    11-15-2016, 04:51 AM Go to last post

  33. [SOLVED] Left formula with if conditional

    Started by minayat‎, 11-14-2016 05:21 PM
    • 5
    • 380
    Phuocam
    11-15-2016, 03:48 AM Go to last post

  34. Returning the values of a column, in increasing value, based on one additional criteria

    Started by jgray‎, 11-14-2016 02:01 AM
    based on criteria, formula, increasing order, return values 1 Attachment(s)
    • 8
    • 774
    JohnTopley
    11-15-2016, 03:47 AM Go to last post

  35. Creating a tiered summary

    Started by fleecej‎, 11-14-2016 11:53 PM
    1 Attachment(s)
    • 5
    • 372
    FlameRetired
    11-15-2016, 01:23 AM Go to last post

  36. Sliding Scale

    Started by Brad0910‎, 11-14-2016 11:24 PM
    excel 2 Attachment(s)
    • 3
    • 470
    FlameRetired
    11-15-2016, 12:31 AM Go to last post

  37. Multiple SUMIFs

    Started by traveler911‎, 11-14-2016 07:35 PM
    counting categories, multiple sumif 2 Attachment(s)
    • 2
    • 379
    traveler911
    11-14-2016, 10:51 PM Go to last post

  38. [SOLVED] Having trouble with getting COUNTIF to work.

    Started by Roco‎, 11-14-2016 07:37 PM
    • 3
    • 373
    Sam Capricci
    11-14-2016, 08:02 PM Go to last post

  39. Trying a formula that changes the % it multiplies it by depending on the value of the cell

    Started by ryankelley318‎, 11-14-2016 06:34 PM
    • 9
    • 519
    Tony Valko
    11-14-2016, 07:39 PM Go to last post

  40. Excel equivalent to Google Sheets' FILTER(range, condition)?

    Started by Trille‎, 11-14-2016 06:09 PM
    database, filter, retrieve data
    • 0
    • 1,236
    Trille
    11-14-2016, 06:09 PM Go to last post

  41. [SOLVED] offset

    Started by jrtaylor‎, 11-14-2016 04:57 PM
    offset
    • 2
    • 539
    jrtaylor
    11-14-2016, 05:59 PM Go to last post

  42. [SOLVED] IF <=0 INDEX MATCH LARGE otherwise return blank

    Started by augr‎, 10-18-2016 02:30 PM
    3 Attachment(s)
    • 22
    • 2,228
    JohnTopley
    11-14-2016, 05:34 PM Go to last post

  43. Rollover Budget with negative numbers by category

    Started by ksayet‎, 11-14-2016 03:37 PM
    • 1
    • 410
    JohnTopley
    11-14-2016, 04:09 PM Go to last post

  44. SUMIF to add number of occurrences of same word

    Started by john.fries‎, 11-14-2016 03:01 PM
    • 4
    • 351
    Tony Valko
    11-14-2016, 03:32 PM Go to last post

  45. A Challenge Just For You!

    Started by bboy_sproutz‎, 11-14-2016 01:22 PM
    2 Attachment(s)
    • 2
    • 368
    protonLeah
    11-14-2016, 03:21 PM Go to last post

  46. Form controls publish to web page?

    Started by watkincm‎, 11-14-2016 03:17 PM
    • 0
    • 608
    watkincm
    11-14-2016, 03:17 PM Go to last post

  47. [SOLVED] Extract data from merged cells in adjacent rows

    Started by hoss88‎, 03-07-2014 04:57 AM
    1 Attachment(s)
    • 4
    • 10,901
    protonLeah
    11-14-2016, 03:09 PM Go to last post

  48. Question Sumproduct to exclude subtotal(9,...)

    Started by Sagittarius1978‎, 11-08-2016 02:54 PM
    1 Attachment(s)
    • 10
    • 2,438
    Sagittarius1978
    11-14-2016, 03:00 PM Go to last post

  49. [SOLVED] Countif help

    Started by ethornto2346‎, 11-14-2016 11:15 AM
    1 Attachment(s)
    • 2
    • 358
    ethornto2346
    11-14-2016, 02:46 PM Go to last post

  50. Exclamation how to take value of variable data with time.

    Started by nnish‎, 11-11-2016 02:55 PM
    2 Attachment(s)
    • 16
    • 705
    JohnTopley
    11-14-2016, 02:46 PM Go to last post
+ Post New Thread
Page 1551 of 5615 FirstFirst ... 1551 ...

Forum Information and Options

Users Browsing this Forum

There are currently 102 users browsing this forum. (6 members & 96 guests)

  1. andyjay_4,
  2. CK76,
  3. fysty0102,
  4. swdude12,
  5. td3201

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