+ Post New Thread
Page 950 of 5615 FirstFirst ... 950 ...
Threads 47451 to 47500 of 280702

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

  1. Automatically populate forward planner based on interval

    Started by mobileangusAIM‎, 05-09-2019 07:38 AM
    • 1
    • 221
    Pete_UK
    05-09-2019, 07:43 AM Go to last post

  2. IF Function with Lookup from Right to Left

    Started by adityatibrewala‎, 05-09-2019 03:14 AM
    if functions
    • 8
    • 347
    AliGW
    05-09-2019, 07:22 AM Go to last post

  3. Red face [SOLVED] Multiple if/ if error formula with V lookup

    Started by mightybracket123‎, 05-09-2019 06:38 AM
    formula
    • 3
    • 284
    KOKOSEK
    05-09-2019, 07:07 AM Go to last post

  4. [SOLVED] Vlookup from Drop Down Selection

    Started by farhadj‎, 05-09-2019 06:48 AM
    2 Attachment(s)
    • 3
    • 251
    KOKOSEK
    05-09-2019, 07:05 AM Go to last post

  5. VLOOKUP #N/A Error for unknown reasons

    Started by Anuru‎, 05-09-2019 01:46 AM
    • 4
    • 267
    joeu2004
    05-09-2019, 06:58 AM Go to last post

  6. Need support in Billing Invoice (Take data from other excel files

    Started by shanis‎, 03-23-2019 04:40 AM
    8 Attachment(s)
    • 7
    • 349
    José Augusto
    05-09-2019, 06:35 AM Go to last post

  7. [SOLVED] Excel Counta (Count from last blank cell)

    Started by smithers0787‎, 05-08-2019 04:30 PM
    1 Attachment(s)
    • 1
    • 268
    Kaper
    05-09-2019, 05:42 AM Go to last post

  8. COUNTIFS to include Cells that include a particular month

    Started by Ollie Frith‎, 05-08-2019 07:08 AM
    • 4
    • 327
    Ollie Frith
    05-09-2019, 04:26 AM Go to last post

  9. Return data in one cell based on what another cell contains

    Started by bushfirey‎, 05-09-2019 02:35 AM
    1 Attachment(s)
    • 4
    • 370
    bushfirey
    05-09-2019, 03:03 AM Go to last post

  10. Rolling Average with Blanks

    Started by jblack6572‎, 05-08-2019 04:24 PM
    1 Attachment(s)
    • 3
    • 347
    XOR LX
    05-09-2019, 01:47 AM Go to last post

  11. Unhappy Summarizing information SUF IF and VLOOKUP

    Started by Anuru‎, 03-28-2019 03:05 AM
    8 Attachment(s)
    • 20
    • 894
    Anuru
    05-09-2019, 01:37 AM Go to last post

  12. [SOLVED] INDEX and MATCH Formulae for Safety KPIs

    Started by VisionSmart‎, 05-01-2019 03:16 AM
    6 Attachment(s)
    • 21
    • 773
    VisionSmart
    05-09-2019, 01:23 AM Go to last post

  13. Help! I need to create a training matrix

    Started by michharr‎, 05-08-2019 08:56 PM
    4 Attachment(s)
    • 3
    • 459
    azumi
    05-09-2019, 01:17 AM Go to last post

  14. [SOLVED] Generating a Random Number that follows the Bessely Distribution

    Started by ancog‎, 05-07-2019 01:40 AM
    • 3
    • 318
    ancog
    05-08-2019, 06:45 PM Go to last post

  15. Question [SOLVED] Count of Distinct function/ Formula based on multiple criteria

    Started by naveeddil‎, 05-08-2019 05:39 AM
    2 Attachment(s)
    • 4
    • 353
    José Augusto
    05-08-2019, 06:34 PM Go to last post

  16. Double click to source data not working with vlookup formula

    Started by MAX258‎, 05-08-2019 01:35 PM
    1 Attachment(s)
    • 8
    • 1,252
    MAX258
    05-08-2019, 03:44 PM Go to last post

  17. IF Statement With OR and AND...

    Started by Ourkid123uk‎, 05-08-2019 02:33 PM
    • 8
    • 223
    Sam Capricci
    05-08-2019, 03:25 PM Go to last post

  18. Count cell pairs meeting multiple conditions

    Started by andyrwise‎, 05-08-2019 02:50 PM
    count, matrix operations 1 Attachment(s)
    • 2
    • 410
    CARACALLA
    05-08-2019, 03:18 PM Go to last post

  19. Returning Matrix Indices from value

    Started by Maicoooooo‎, 04-21-2019 07:52 AM
    address, index, match, vba, vehicle routing problem 3 Attachment(s)
    • 7
    • 838
    Maicoooooo
    05-08-2019, 03:06 PM Go to last post

  20. Need help with a sign-up form.

    Started by Madeleine Morris‎, 05-08-2019 12:57 PM
    • 2
    • 326
    Melvosh
    05-08-2019, 02:49 PM Go to last post

  21. [SOLVED] Calculating Operational Downtime

    Started by mononine‎, 05-06-2019 04:28 PM
    2 Attachment(s)
    • 37
    • 2,406
    Richard Buttrey
    05-08-2019, 02:32 PM Go to last post

  22. Complicated Index/match formula

    Started by spqr85‎, 05-08-2019 01:15 PM
    • 3
    • 347
    Fluff13
    05-08-2019, 02:18 PM Go to last post

  23. [SOLVED] Calculate number of days between a customer visits

    Started by littledragon37‎, 05-07-2019 11:53 PM
    1 Attachment(s)
    • 4
    • 416
    AliGW
    05-08-2019, 01:57 PM Go to last post

  24. [SOLVED] How to match up two columns based on the first few characters

    Started by dicedpineapples‎, 05-08-2019 01:42 PM
    1 Attachment(s)
    • 5
    • 240
    dicedpineapples
    05-08-2019, 01:52 PM Go to last post

  25. [SOLVED] Sort dates and hours chronological

    Started by Flavius24‎, 05-07-2019 06:01 PM
    1 Attachment(s)
    • 9
    • 372
    Flavius24
    05-08-2019, 01:47 PM Go to last post

  26. Conditional Average over multiple sheets

    Started by excelatnothing‎, 05-08-2019 10:31 AM
    1 Attachment(s)
    • 3
    • 1,273
    excelatnothing
    05-08-2019, 01:43 PM Go to last post

  27. vlookup results show a different line

    Started by Unclebenny‎, 05-08-2019 12:55 PM
    1 Attachment(s)
    • 1
    • 196
    AliGW
    05-08-2019, 12:58 PM Go to last post

  28. [SOLVED] OFFSET formula difficulties

    Started by GABY1234‎, 05-08-2019 10:13 AM
    2 Attachment(s)
    • 3
    • 212
    Glenn Kennedy
    05-08-2019, 11:28 AM Go to last post

  29. [SOLVED] Vlookup Multiple Worksheets - Populate multiple columns at same time

    Started by seanodo‎, 05-08-2019 10:50 AM
    1 Attachment(s)
    • 5
    • 368
    Pete_UK
    05-08-2019, 11:18 AM Go to last post

  30. Conditional formatting with boarders and Code not working when sheet is protected

    Started by nsmjc‎, 05-08-2019 10:48 AM
    1 Attachment(s)
    • 1
    • 415
    KOKOSEK
    05-08-2019, 10:55 AM Go to last post

  31. Need formula that counts data based on a date range please

    Started by kimmers76‎, 05-08-2019 10:20 AM
    • 2
    • 222
    canapone
    05-08-2019, 10:41 AM Go to last post

  32. [SOLVED] Multiple COUNTIF and SUMIF criteria

    Started by Deaco‎, 05-08-2019 09:36 AM
    complex, countif, formula, sumif 2 Attachment(s)
    • 5
    • 540
    Glenn Kennedy
    05-08-2019, 10:09 AM Go to last post

  33. [SOLVED] Time Stamp Log

    Started by nsmjc‎, 05-07-2019 05:57 PM
    1 Attachment(s)
    • 5
    • 321
    Glenn Kennedy
    05-08-2019, 09:21 AM Go to last post

  34. Look up the last date in a row excluding zero

    Started by Coopereto‎, 05-08-2019 06:04 AM
    1 Attachment(s)
    • 3
    • 332
    Coopereto
    05-08-2019, 06:51 AM Go to last post

  35. How to assign a numerical value to a letter

    Started by dksern‎, 05-06-2019 08:29 PM
    5 Attachment(s)
    • 7
    • 1,984
    6StringJazzer
    05-08-2019, 06:33 AM Go to last post

  36. [SOLVED] Vlookup to pull FROM a merged cell

    Started by BolognaMan‎, 05-07-2019 02:14 PM
    merged cells, vlookup 2 Attachment(s)
    • 8
    • 3,638
    José Augusto
    05-08-2019, 05:44 AM Go to last post

  37. Complex countifs

    Started by pickslides‎, 05-07-2019 07:01 PM
    1 Attachment(s)
    • 5
    • 304
    Pete_UK
    05-08-2019, 05:14 AM Go to last post

  38. [SOLVED] Calculate avg & median hours in a date series based on values in separate column

    Started by TPower1‎, 04-29-2019 10:24 PM
    date, flow duration, stream flow data, time series analysis 3 Attachment(s)
    • 5
    • 516
    TPower1
    05-08-2019, 01:53 AM Go to last post

  39. [SOLVED] Drop down option automatically choose based on answer

    Started by haziqten‎, 05-06-2019 08:12 PM
    4 Attachment(s)
    • 11
    • 447
    kvsrinivasamurthy
    05-07-2019, 11:42 PM Go to last post

  40. Use drop-down value as function value

    Started by skydivetom‎, 05-07-2019 01:45 PM
    1 Attachment(s)
    • 6
    • 261
    GeoffW283
    05-07-2019, 11:01 PM Go to last post

  41. Autofill Dates with Row Deletion

    Started by dpston‎, 05-06-2019 08:31 PM
    1 Attachment(s)
    • 6
    • 418
    FDibbins
    05-07-2019, 10:52 PM Go to last post

  42. [SOLVED] Dynamic array of an index match function

    Started by timmtamm‎, 05-07-2019 02:14 PM
    2 Attachment(s)
    • 11
    • 1,649
    Pete_UK
    05-07-2019, 06:59 PM Go to last post

  43. [SOLVED] Advanced Formula for Look Up based on Multiple Criteria

    Started by Hopethehip‎, 04-26-2019 02:14 PM
    3 Attachment(s)
    • 5
    • 399
    FlameRetired
    05-07-2019, 06:47 PM Go to last post

  44. [SOLVED] Help to bring Claim#s from a cells with miscellaneous comments

    Started by marcella needs help‎, 05-07-2019 04:25 PM
    find 1 Attachment(s)
    • 3
    • 378
    marcella needs help
    05-07-2019, 05:31 PM Go to last post

  45. Return value if match between cell and column

    Started by Ashleytaylor1702‎, 05-07-2019 04:24 PM
    1 Attachment(s)
    • 1
    • 218
    Sam Capricci
    05-07-2019, 04:35 PM Go to last post

  46. [SOLVED] Help adding an 'OR' to a VLOOKUP

    Started by TomP1988‎, 05-07-2019 03:53 PM
    • 4
    • 231
    Sam Capricci
    05-07-2019, 04:23 PM Go to last post

  47. Make new dynamic table with specific columns from previous one

    Started by rodmorais‎, 05-05-2019 04:03 PM
    • 1
    • 261
    dflak
    05-07-2019, 04:11 PM Go to last post

  48. [SOLVED] Value between two dates

    Started by jharvey87‎, 05-07-2019 02:20 PM
    • 2
    • 272
    fredfarmer
    05-07-2019, 02:49 PM Go to last post

  49. Combining numerical values from B2, C2 and D2 into E2 in ascending order.

    Started by Occam‎, 04-30-2019 12:21 AM
    • 4
    • 1,137
    Occam
    05-07-2019, 01:58 PM Go to last post

  50. [SOLVED] Formula to translate from year to eomonth

    Started by Keibri‎, 05-07-2019 12:26 PM
    1 Attachment(s)
    • 5
    • 314
    shg
    05-07-2019, 01:45 PM Go to last post
+ Post New Thread
Page 950 of 5615 FirstFirst ... 950 ...

Forum Information and Options

Users Browsing this Forum

There are currently 63 users browsing this forum. (5 members & 58 guests)

  1. Extrudius,
  2. RaulSerg,
  3. windknife

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