+ Post New Thread
Page 1111 of 5614 FirstFirst ... 1111 ...
Threads 55501 to 55550 of 280698

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. How to use Lookup/Index

    Started by QuantEdge‎, 08-30-2018 12:48 PM
    1 Attachment(s)
    • 8
    • 205
    63falcondude
    08-30-2018, 01:17 PM Go to last post

  2. return negative array number?

    Started by QuantEdge‎, 08-29-2018 04:40 PM
    4 Attachment(s)
    • 11
    • 1,435
    QuantEdge
    08-30-2018, 01:11 PM Go to last post

  3. [SOLVED] Need help with percentages

    Started by Zach_A‎, 08-30-2018 12:36 PM
    1 Attachment(s)
    • 3
    • 220
    63falcondude
    08-30-2018, 01:02 PM Go to last post

  4. Using IF AND OR with multiple critera

    Started by 3345james‎, 08-30-2018 12:26 PM
    • 2
    • 238
    3345james
    08-30-2018, 12:46 PM Go to last post

  5. Unhappy Dynamic sourcing for ltm and ytd

    Started by Baliar‎, 08-30-2018 10:19 AM
    1 Attachment(s)
    • 1
    • 386
    tim201110
    08-30-2018, 12:43 PM Go to last post

  6. Exclamation Help! Execute Function As Of Specified Date

    Started by AlexiC‎, 08-28-2018 02:31 PM
    1 Attachment(s)
    • 4
    • 280
    Logit
    08-30-2018, 12:41 PM Go to last post

  7. Determining Late collections over midnight....

    Started by daveyo32‎, 08-29-2018 11:27 AM
    1 Attachment(s)
    • 3
    • 237
    Glenn Kennedy
    08-30-2018, 11:53 AM Go to last post

  8. Use of formula =IF(ISNUMBER(SEARCH...

    Started by Szyfrow‎, 08-30-2018 08:47 AM
    1 Attachment(s)
    • 14
    • 1,554
    Szyfrow
    08-30-2018, 11:50 AM Go to last post

  9. [SOLVED] Trouble with various formulas for order tracking

    Started by Klea‎, 08-29-2018 12:32 PM
    2016, formulas, orders, tracking 4 Attachment(s)
    • 11
    • 695
    BadlySpelledBuoy
    08-30-2018, 11:17 AM Go to last post

  10. Split from string

    Started by tax112‎, 08-30-2018 10:46 AM
    1 Attachment(s)
    • 2
    • 298
    tax112
    08-30-2018, 10:59 AM Go to last post

  11. [SOLVED] Help making cell CF match on same sheet

    Started by Sirlaughsalot‎, 08-30-2018 09:38 AM
    1 Attachment(s)
    • 4
    • 199
    63falcondude
    08-30-2018, 10:47 AM Go to last post

  12. PMT Function - Annually or Monthly

    Started by maxhecht2‎, 08-30-2018 09:59 AM
    • 6
    • 2,203
    Richard Buttrey
    08-30-2018, 10:47 AM Go to last post

  13. [SOLVED] Formula or Function to get mirror numbers

    Started by lmcc007‎, 08-30-2018 09:17 AM
    1 Attachment(s)
    • 5
    • 973
    63falcondude
    08-30-2018, 10:33 AM Go to last post

  14. Spreadsheet Optimization

    Started by DAULT‎, 08-13-2018 09:26 AM
    15 Attachment(s)
    • 36
    • 811
    Mumps1
    08-30-2018, 10:21 AM Go to last post

  15. [SOLVED] Stuck creating formula that sorts highest to lowest then sum quantity

    Started by ZMAFC94‎, 08-30-2018 05:11 AM
    2 Attachment(s)
    • 4
    • 390
    ZMAFC94
    08-30-2018, 10:06 AM Go to last post

  16. Populate excel fields with data based on matching numbers from other sheet

    Started by River99‎, 08-30-2018 09:31 AM
    combine data 1 Attachment(s)
    • 1
    • 268
    Kaper
    08-30-2018, 10:05 AM Go to last post

  17. Getpivotdata - dragging issues

    Started by NoWizkid‎, 08-29-2018 11:55 PM
    3 Attachment(s)
    • 10
    • 853
    NoWizkid
    08-30-2018, 10:02 AM Go to last post

  18. purchase sale deposit margin - simple but complex

    Started by contoso‎, 08-30-2018 09:53 AM
    1 Attachment(s)
    • 0
    • 253
    contoso
    08-30-2018, 09:53 AM Go to last post

  19. [SOLVED] Numbers More Than a Specific number

    Started by soleimani1967‎, 08-30-2018 08:16 AM
    1 Attachment(s)
    • 6
    • 304
    soleimani1967
    08-30-2018, 09:27 AM Go to last post

  20. checklist which, upon completion, adds a name to a list

    Started by daniel.szemeti‎, 08-30-2018 08:18 AM
    • 4
    • 242
    daniel.szemeti
    08-30-2018, 09:08 AM Go to last post

  21. List with prices and suppliers sorted by lowest price and which supplier has it

    Started by SjoisW‎, 08-30-2018 08:23 AM
    1 Attachment(s)
    • 2
    • 676
    alansidman
    08-30-2018, 08:30 AM Go to last post

  22. [SOLVED] How to remove or hide #VALUE!

    Started by VisionSmart‎, 08-28-2018 06:30 AM
    3 Attachment(s)
    • 6
    • 1,770
    VisionSmart
    08-30-2018, 02:53 AM Go to last post

  23. "Terminated" if marked absent continuously for 5 days

    Started by amitkr3855‎, 08-30-2018 02:13 AM
    1 Attachment(s)
    • 5
    • 329
    BadlySpelledBuoy
    08-30-2018, 02:37 AM Go to last post

  24. IF and Offset Formula

    Started by Aristillus‎, 08-24-2018 05:04 AM
    4 Attachment(s)
    • 8
    • 395
    Aristillus
    08-30-2018, 02:17 AM Go to last post

  25. 3 IF's into one

    Started by dache416‎, 08-29-2018 02:31 PM
    1 Attachment(s)
    • 3
    • 248
    FDibbins
    08-30-2018, 01:47 AM Go to last post

  26. Question [SOLVED] Help with a formula

    Started by Jake_1‎, 08-29-2018 06:46 PM
    • 4
    • 295
    FDibbins
    08-30-2018, 01:45 AM Go to last post

  27. Question Help how to add function itself like A1 to be A5 at C2

    Started by fahmizohir‎, 08-29-2018 11:43 AM
    • 4
    • 439
    FDibbins
    08-30-2018, 01:41 AM Go to last post

  28. Index Match based on multiple colums

    Started by Crawfy‎, 08-29-2018 01:38 AM
    3 Attachment(s)
    • 8
    • 429
    FDibbins
    08-30-2018, 01:33 AM Go to last post

  29. [SOLVED] Need formula to provide search criteria from table

    Started by zenix‎, 08-29-2018 10:27 PM
    2 Attachment(s)
    • 3
    • 270
    congnt92
    08-30-2018, 12:34 AM Go to last post

  30. [SOLVED] date generation question

    Started by k1dr0ck‎, 08-29-2018 10:52 PM
    • 2
    • 283
    k1dr0ck
    08-29-2018, 11:12 PM Go to last post

  31. [SOLVED] Sum a range of cells based on Formula drive reference cell

    Started by Vibro‎, 08-29-2018 10:10 PM
    2 Attachment(s)
    • 1
    • 258
    jtakw
    08-29-2018, 10:53 PM Go to last post

  32. [SOLVED] date manipulation

    Started by k1dr0ck‎, 08-16-2018 10:00 PM
    3 Attachment(s)
    • 8
    • 367
    k1dr0ck
    08-29-2018, 10:48 PM Go to last post

  33. [SOLVED] How to list down the Serial No. by date range

    Started by pakida‎, 08-29-2018 12:43 AM
    2 Attachment(s)
    • 3
    • 416
    FlameRetired
    08-29-2018, 10:29 PM Go to last post

  34. [SOLVED] Couting Duplicate Values as 1 and summing total

    Started by rslush91‎, 08-29-2018 11:02 AM
    2 Attachment(s)
    • 2
    • 259
    FlameRetired
    08-29-2018, 10:09 PM Go to last post

  35. Question Scheduling changes by increments of time within a cell

    Started by lizziemac‎, 08-29-2018 04:01 PM
    formula, schedule, scheduling, time 1 Attachment(s)
    • 2
    • 454
    lizziemac
    08-29-2018, 05:57 PM Go to last post

  36. [SOLVED] Combining Percentile, IF functions with Positive and Negative values

    Started by VenatusNocte‎, 08-29-2018 04:13 PM
    • 2
    • 3,473
    VenatusNocte
    08-29-2018, 05:00 PM Go to last post

  37. Change multiple variables respective column values in rows

    Started by vikram1690‎, 08-29-2018 01:35 PM
    • 1
    • 209
    VenatusNocte
    08-29-2018, 04:54 PM Go to last post

  38. Formula to measure whether or not both teams have scored for football data

    Started by Jim.water‎, 08-29-2018 10:58 AM
    1 Attachment(s)
    • 6
    • 265
    AliGW
    08-29-2018, 04:39 PM Go to last post

  39. Identify who requires training based on score

    Started by mlbrenes‎, 08-21-2018 12:06 PM
    4 Attachment(s)
    • 6
    • 548
    JeteMc
    08-29-2018, 04:34 PM Go to last post

  40. How to Highlight cell with Date Value Greater Than 6 months

    Started by Burner01‎, 08-29-2018 11:46 AM
    1 Attachment(s)
    • 5
    • 49,503
    johnmpl
    08-29-2018, 04:20 PM Go to last post

  41. Change drop down based on cell value

    Started by nolandavis513‎, 08-29-2018 01:03 PM
    dependent, dropdown 2 Attachment(s)
    • 6
    • 573
    BadlySpelledBuoy
    08-29-2018, 04:15 PM Go to last post

  42. dynamic ranging exclusing spaces and first column

    Started by SHUTTEHFACE‎, 08-27-2018 06:28 PM
    2 Attachment(s)
    • 6
    • 301
    FlameRetired
    08-29-2018, 03:21 PM Go to last post

  43. Extracting rows with cell values separated by a number

    Started by Elee101‎, 08-27-2018 04:58 PM
    excel formula vba 4 Attachment(s)
    • 14
    • 608
    Elee101
    08-29-2018, 02:39 PM Go to last post

  44. [SOLVED] Matching highlighting conditional formatting between sheets

    Started by Sirlaughsalot‎, 08-29-2018 01:13 PM
    1 Attachment(s)
    • 2
    • 275
    Sirlaughsalot
    08-29-2018, 02:21 PM Go to last post

  45. Formula simplification needed.

    Started by Sekars‎, 08-21-2018 05:20 AM
    4 Attachment(s)
    • 16
    • 768
    FlameRetired
    08-29-2018, 02:08 PM Go to last post

  46. Dynamically change formula range

    Started by 119luke‎, 08-28-2018 02:35 PM
    • 7
    • 403
    FDibbins
    08-29-2018, 01:44 PM Go to last post

  47. Re: Extract subarray from table column based on criteria matched-structure table reference

    Started by jaryszek‎, 08-21-2018 06:00 AM
    8 Attachment(s)
    • 40
    • 1,919
    jaryszek
    08-29-2018, 01:36 PM Go to last post

  48. Question [SOLVED] Conditional Formatting - Apply Cell Style if a column cell is "string1" or "string2"

    Started by Tunnel_Snakes‎, 08-29-2018 11:27 AM
    conditional formatting, text
    • 3
    • 552
    6StringJazzer
    08-29-2018, 01:27 PM Go to last post

  49. Find a number that matches the most significant digits and provide row / column result

    Started by Bobbbo‎, 08-24-2018 07:02 PM
    4 Attachment(s)
    • 8
    • 506
    shg
    08-29-2018, 12:30 PM Go to last post

  50. Separate numbers from group of numbers

    Started by QuantEdge‎, 08-29-2018 10:44 AM
    2 Attachment(s)
    • 12
    • 526
    Pete_UK
    08-29-2018, 11:43 AM Go to last post
+ Post New Thread
Page 1111 of 5614 FirstFirst ... 1111 ...

Forum Information and Options

Users Browsing this Forum

There are currently 66 users browsing this forum. (4 members & 62 guests)

  1. colin wiz,
  2. Glenn Kennedy,
  3. TMS

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