+ Post New Thread
Page 1105 of 5629 FirstFirst ... 1105 ...
Threads 55201 to 55250 of 281442

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

  1. Calculation slow with current formulas.

    Started by crazymaca69‎, 10-04-2018 04:20 AM
    2 Attachment(s)
    • 6
    • 265
    avk
    10-04-2018, 07:50 AM Go to last post

  2. [SOLVED] Index Match on Two Criteria

    Started by ArtKB‎, 10-02-2018 07:01 AM
    3 Attachment(s)
    • 9
    • 322
    Bosco
    10-04-2018, 07:28 AM Go to last post

  3. Conditional formatting for Dates (Expired/Current)

    Started by Shazz‎, 10-04-2018 07:02 AM
    • 1
    • 205
    Phuocam
    10-04-2018, 07:06 AM Go to last post

  4. [SOLVED] Return all matches from two sheets

    Started by YasserKhalil‎, 10-03-2018 11:19 AM
    4 Attachment(s)
    • 16
    • 538
    YasserKhalil
    10-04-2018, 06:35 AM Go to last post

  5. Copying a Sub Array Formula to ensure action affects whole sheet

    Started by toneloke‎, 10-01-2018 11:41 AM
    • 2
    • 277
    toneloke
    10-04-2018, 06:32 AM Go to last post

  6. Question [SOLVED] VLOOKUP value

    Started by Khaldon‎, 10-03-2018 04:29 PM
    • 2
    • 252
    Aardigspook
    10-04-2018, 06:04 AM Go to last post

  7. Data Validation with option from a drop down list with a warning if repeated.

    Started by Yoepy‎, 10-02-2018 07:36 PM
    1 Attachment(s)
    • 8
    • 536
    Yoepy
    10-04-2018, 05:09 AM Go to last post

  8. [SOLVED] Return a row of data based on DropDown List

    Started by majime01‎, 10-04-2018 04:15 AM
    1 Attachment(s)
    • 2
    • 219
    majime01
    10-04-2018, 04:49 AM Go to last post

  9. Determine Incentives

    Started by jhonquazi‎, 10-04-2018 01:12 AM
    argent 1 Attachment(s)
    • 5
    • 376
    kvsrinivasamurthy
    10-04-2018, 04:21 AM Go to last post

  10. Formula to calculate SLA Breaches

    Started by Wendyaclark‎, 01-10-2013 02:36 AM
    4 Attachment(s)
    • 7
    • 8,998
    Glenn Kennedy
    10-04-2018, 04:06 AM Go to last post

  11. [SOLVED] Drop down menu - adding to them

    Started by Japhix‎, 09-30-2018 12:24 PM
    3 Attachment(s)
    • 9
    • 504
    FlameRetired
    10-04-2018, 03:13 AM Go to last post

  12. Formula containing COS

    Started by Thlian‎, 10-04-2018 02:00 AM
    • 4
    • 344
    Glenn Kennedy
    10-04-2018, 02:51 AM Go to last post

  13. Incentive calculations

    Started by jhonquazi‎, 10-04-2018 01:49 AM
    incentive
    • 1
    • 449
    AliGW
    10-04-2018, 02:16 AM Go to last post

  14. [SOLVED] IF AND OR Function help

    Started by flyby99‎, 10-03-2018 05:18 AM
    • 6
    • 340
    flyby99
    10-04-2018, 01:55 AM Go to last post

  15. [SOLVED] Blank rows based on a formula. Is this possible?

    Started by auslandstudio‎, 10-03-2018 04:03 PM
    1 Attachment(s)
    • 5
    • 346
    auslandstudio
    10-04-2018, 12:40 AM Go to last post

  16. [SOLVED] Extracting data from one column

    Started by apoje‎, 09-28-2018 05:57 AM
    5 Attachment(s)
    • 6
    • 467
    jtakw
    10-03-2018, 09:33 PM Go to last post

  17. Conditional formula to highlight one month before current month, then 2, then 3 or more

    Started by redhuny733‎, 10-03-2018 07:37 PM
    1 Attachment(s)
    • 1
    • 245
    nickytraps
    10-03-2018, 08:23 PM Go to last post

  18. Question How2: IF column a = blank and column b = y, THEN make column a = X and column b = blank

    Started by GregSimonis‎, 10-03-2018 02:58 PM
    blank, forumula, how do i fix?, how2, if then
    • 2
    • 730
    Pete_UK
    10-03-2018, 07:15 PM Go to last post

  19. COUNTIFS with Date Calculations

    Started by F1akman‎, 10-03-2018 02:10 PM
    • 8
    • 358
    F1akman
    10-03-2018, 06:53 PM Go to last post

  20. [SOLVED] Formula using multiple IF/AND/OR functions

    Started by HDL16‎, 10-03-2018 06:10 PM
    • 3
    • 245
    FDibbins
    10-03-2018, 06:48 PM Go to last post

  21. Question How to preset data to database

    Started by MoodoHarajli‎, 10-02-2018 11:39 PM
    • 8
    • 433
    alansidman
    10-03-2018, 04:58 PM Go to last post

  22. Month & Year = Month & Year does not match up

    Started by nguyenqh96‎, 10-03-2018 09:46 AM
    • 3
    • 251
    FlameRetired
    10-03-2018, 04:22 PM Go to last post

  23. [SOLVED] Convert Number into Date

    Started by John775‎, 10-03-2018 04:03 PM
    • 5
    • 261
    John775
    10-03-2018, 04:14 PM Go to last post

  24. Can someone please explain this set of functions?

    Started by tigerbanana‎, 09-26-2018 11:00 PM
    aggregate 1 Attachment(s)
    • 3
    • 496
    JeteMc
    10-03-2018, 03:09 PM Go to last post

  25. Conditional Format Keeps Splitting - shifting rows down

    Started by ARamos2‎, 10-03-2018 01:33 PM
    • 1
    • 238
    Tsjallie
    10-03-2018, 02:29 PM Go to last post

  26. [SOLVED] Multiple index+match formulas to get non-zero value data from column and return row value

    Started by excel-lent13‎, 10-02-2018 05:25 PM
    complex formula, complex formula/array, vlookup + index + match 7 Attachment(s)
    • 14
    • 1,455
    Pete_UK
    10-03-2018, 02:05 PM Go to last post

  27. Sum by Color

    Started by ceranes‎, 10-03-2018 01:22 PM
    • 3
    • 299
    Aardigspook
    10-03-2018, 01:47 PM Go to last post

  28. Exclamation Nested IF statements with a Search function

    Started by ChesireCat‎, 10-02-2018 11:20 AM
    • 3
    • 661
    ChesireCat
    10-03-2018, 01:20 PM Go to last post

  29. Part matching

    Started by crl68‎, 10-03-2018 08:25 AM
    2 Attachment(s)
    • 8
    • 349
    Glenn Kennedy
    10-03-2018, 12:19 PM Go to last post

  30. Dynamic formula not allowing sorting

    Started by asitiz‎, 10-02-2018 05:27 AM
    2 Attachment(s)
    • 5
    • 373
    kvsrinivasamurthy
    10-03-2018, 11:45 AM Go to last post

  31. Filling down many rows

    Started by marcfour‎, 10-03-2018 11:08 AM
    • 1
    • 383
    Bernie Deitrick
    10-03-2018, 11:21 AM Go to last post

  32. to find numbers >=3 using formula

    Started by Shalini Upadhyay‎, 10-03-2018 06:45 AM
    6 Attachment(s)
    • 12
    • 364
    samba_ravi
    10-03-2018, 11:14 AM Go to last post

  33. [SOLVED] Return Value Based on Several Criteria in Several Identically Formatted Data Sets

    Started by ndudley26‎, 09-25-2018 02:06 PM
    create a list, formulas, multiple criteria columns, multiple data sets, return all results 4 Attachment(s)
    • 15
    • 826
    ndudley26
    10-03-2018, 11:13 AM Go to last post

  34. [SOLVED] Challenge : Refrencing a name to produce previous and cumulative

    Started by tdugas2‎, 10-03-2018 10:42 AM
    1 Attachment(s)
    • 1
    • 247
    Tsjallie
    10-03-2018, 11:03 AM Go to last post

  35. Increasing speed of match index formula

    Started by Calios‎, 10-03-2018 09:41 AM
    match .index. speed.
    • 3
    • 300
    Calios
    10-03-2018, 10:36 AM Go to last post

  36. find if value exist after certain days

    Started by excel24‎, 10-03-2018 02:06 AM
    1 Attachment(s)
    • 1
    • 225
    pjwhitfield
    10-03-2018, 07:58 AM Go to last post

  37. Finding Max Value with multiple criteria.

    Started by Kunamis7‎, 10-02-2018 05:26 PM
    • 4
    • 404
    63falcondude
    10-03-2018, 07:46 AM Go to last post

  38. Angry A beginners issue: IF or COUNT or what to use?

    Started by stefan00‎, 10-02-2018 11:12 AM
    1 Attachment(s)
    • 14
    • 373
    63falcondude
    10-03-2018, 07:45 AM Go to last post

  39. Question append two lists (columns) no duplicate

    Started by amirflax‎, 09-29-2018 07:16 AM
    • 9
    • 357
    amirflax
    10-03-2018, 07:44 AM Go to last post

  40. Which type of t-test to use?

    Started by berlysia‎, 10-02-2018 10:58 PM
    • 2
    • 240
    berlysia
    10-03-2018, 06:10 AM Go to last post

  41. [SOLVED] Conosolidating multiple identical IDs in one column

    Started by apoje‎, 10-02-2018 04:26 AM
    3 Attachment(s)
    • 4
    • 293
    apoje
    10-03-2018, 05:56 AM Go to last post

  42. Using COUNTIF with multiple criteria

    Started by ejames10‎, 10-02-2018 10:28 AM
    countif, excel
    • 7
    • 590
    ejames10
    10-03-2018, 05:23 AM Go to last post

  43. [SOLVED] Working out a number from a pertage value

    Started by pmw19800‎, 10-03-2018 04:23 AM
    1 Attachment(s)
    • 5
    • 282
    pmw19800
    10-03-2018, 04:55 AM Go to last post

  44. Help with a Sumproduct Formula

    Started by enterdelete123‎, 10-03-2018 02:16 AM
    1 Attachment(s)
    • 8
    • 371
    enterdelete123
    10-03-2018, 04:43 AM Go to last post

  45. Dynamic Named Range added to formulas

    Started by DJG7680‎, 10-03-2018 01:48 AM
    • 1
    • 315
    Glenn Kennedy
    10-03-2018, 03:33 AM Go to last post

  46. [SOLVED] Rank for rows

    Started by Ehab1511‎, 10-01-2018 01:53 PM
    1 Attachment(s)
    • 4
    • 336
    Ehab1511
    10-03-2018, 03:28 AM Go to last post

  47. New: Return multiple results from a unique list

    Started by ifulao‎, 09-16-2018 03:21 AM
    5 Attachment(s)
    • 18
    • 861
    Glenn Kennedy
    10-03-2018, 03:19 AM Go to last post

  48. [SOLVED] Need help with a formula to display two different values from different cells

    Started by Scott0908‎, 10-02-2018 09:26 PM
    1 Attachment(s)
    • 5
    • 305
    FlameRetired
    10-03-2018, 12:32 AM Go to last post

  49. Need formula 2 Column to One Column

    Started by lgchandana‎, 10-02-2018 08:16 PM
    2 Attachment(s)
    • 4
    • 296
    azumi
    10-03-2018, 12:26 AM Go to last post

  50. [SOLVED] Conditional formatting to find and highlight duplicate number

    Started by rizmomin‎, 10-02-2018 09:40 PM
    1 Attachment(s)
    • 2
    • 295
    rizmomin
    10-02-2018, 10:15 PM Go to last post
+ Post New Thread
Page 1105 of 5629 FirstFirst ... 1105 ...

Forum Information and Options

Users Browsing this Forum

There are currently 69 users browsing this forum. (5 members & 64 guests)

  1. dagne81,
  2. Ian McPherson,
  3. pfusella,
  4. Sam Capricci

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