+ Post New Thread
Page 991 of 5611 FirstFirst ... 991 ...
Threads 49501 to 49550 of 280512

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

  1. Extract month number and year

    Started by Howardc1001‎, 02-28-2019 11:17 AM
    1 Attachment(s)
    • 6
    • 431
    Howardc1001
    02-28-2019, 12:28 PM Go to last post

  2. Display Text With 2 Criterias

    Started by kwalking‎, 02-27-2019 11:28 AM
    1 Attachment(s)
    • 4
    • 225
    kwalking
    02-28-2019, 12:13 PM Go to last post

  3. [SOLVED] Index – Match for Repeated Numbers

    Started by soleimani1967‎, 02-28-2019 11:51 AM
    1 Attachment(s)
    • 2
    • 529
    Pete_UK
    02-28-2019, 12:03 PM Go to last post

  4. match two words between two date range and count

    Started by Cosmin20192019‎, 02-28-2019 09:23 AM
    2 Attachment(s)
    • 3
    • 237
    Cosmin20192019
    02-28-2019, 11:49 AM Go to last post

  5. Multiple Condition VLOOKUP MATCH

    Started by QuiqueHM‎, 02-27-2019 06:55 PM
    3 Attachment(s)
    • 3
    • 280
    KOKOSEK
    02-28-2019, 11:47 AM Go to last post

  6. Help with matching data sets

    Started by stevenb.eidex‎, 02-27-2019 05:29 PM
    2 Attachment(s)
    • 2
    • 279
    stevenb.eidex
    02-28-2019, 11:34 AM Go to last post

  7. [SOLVED] Help retreiveing data from another workbook

    Started by reardley‎, 02-04-2019 11:11 AM
    1 Attachment(s)
    • 5
    • 301
    JeteMc
    02-28-2019, 10:57 AM Go to last post

  8. [SOLVED] A few things related to Column-finding and cellvalues

    Started by Vihral‎, 02-28-2019 09:53 AM
    • 2
    • 189
    Vihral
    02-28-2019, 10:18 AM Go to last post

  9. Chart whitout 0 in range

    Started by vasc‎, 02-28-2019 07:32 AM
    1 Attachment(s)
    • 3
    • 214
    MrShorty
    02-28-2019, 10:04 AM Go to last post

  10. [SOLVED] Look back across columns until data is found

    Started by Waspeze‎, 02-28-2019 06:44 AM
    2 Attachment(s)
    • 4
    • 227
    Waspeze
    02-28-2019, 08:11 AM Go to last post

  11. Matching Value to Maximum Date in a Range

    Started by USAOz‎, 02-27-2019 09:21 PM
    hlookup, index, match, vlookup
    • 4
    • 466
    jason.b75
    02-28-2019, 07:54 AM Go to last post

  12. Conditional Formula help

    Started by m1ke86‎, 02-28-2019 07:29 AM
    1 Attachment(s)
    • 1
    • 226
    etaf
    02-28-2019, 07:54 AM Go to last post

  13. Lookup function problem

    Started by USAOz‎, 02-27-2019 11:36 PM
    hlookup, match & index, vlookup 2 Attachment(s)
    • 2
    • 470
    jason.b75
    02-28-2019, 07:35 AM Go to last post

  14. [SOLVED] Index/Match multiple criteria

    Started by iantix‎, 02-28-2019 06:53 AM
    2 Attachment(s)
    • 7
    • 393
    Pete_UK
    02-28-2019, 07:31 AM Go to last post

  15. Help on cumulative summation with drop off after 36 months

    Started by amanbajaj‎, 02-27-2019 04:00 PM
    conditional, cumulative, lease term, sum 1 Attachment(s)
    • 3
    • 400
    Aardigspook
    02-28-2019, 07:25 AM Go to last post

  16. [SOLVED] Count number of line items, that fulfill 2 criteria

    Started by k1282‎, 02-28-2019 06:24 AM
    1 Attachment(s)
    • 2
    • 319
    Sam Capricci
    02-28-2019, 06:30 AM Go to last post

  17. Variable units and prices to achieve a fixed revenue

    Started by Scooter222‎, 02-28-2019 05:55 AM
    1 Attachment(s)
    • 3
    • 246
    Scooter222
    02-28-2019, 06:27 AM Go to last post

  18. Help on nesting logical function

    Started by jotran5‎, 02-07-2014 11:03 AM
    nested logical function 1 Attachment(s)
    • 16
    • 5,477
    FDibbins
    02-28-2019, 06:22 AM Go to last post

  19. [SOLVED] need formula to find value in one column then count if row values meet criteria

    Started by kevinu‎, 02-26-2019 10:21 PM
    1 Attachment(s)
    • 3
    • 308
    FDibbins
    02-28-2019, 05:32 AM Go to last post

  20. [SOLVED] Always find the latest date in a row

    Started by magic2finger‎, 02-24-2019 12:44 PM
    • 4
    • 278
    etaf
    02-28-2019, 05:23 AM Go to last post

  21. [SOLVED] COUNTIF - 3 Criterian not pulling through the correct result

    Started by caz6661‎, 02-27-2019 11:12 AM
    countifs, formula 1 Attachment(s)
    • 10
    • 379
    AliGW
    02-28-2019, 05:09 AM Go to last post

  22. Count beetwen times

    Started by HereComesTheBoom‎, 02-28-2019 03:34 AM
    1 Attachment(s)
    • 1
    • 193
    davsth
    02-28-2019, 04:08 AM Go to last post

  23. [SOLVED] Date calculations with countif function

    Started by Vivek2705‎, 02-25-2019 08:45 AM
    date calculations 1 Attachment(s)
    • 4
    • 325
    Vivek2705
    02-28-2019, 02:38 AM Go to last post

  24. Speed of excel

    Started by Bandito1‎, 02-24-2019 09:45 AM
    • 5
    • 373
    MarvinP
    02-28-2019, 02:04 AM Go to last post

  25. [SOLVED] Inserting Rows - Help

    Started by sahm2‎, 02-27-2019 06:01 PM
    2 Attachment(s)
    • 2
    • 258
    sahm2
    02-28-2019, 01:47 AM Go to last post

  26. [SOLVED] Require OUTPUT basis 2 figures in INPUT & given Matrix

    Started by RavindraK‎, 02-25-2019 06:33 AM
    2 Attachment(s)
    • 6
    • 370
    JeteMc
    02-28-2019, 12:28 AM Go to last post

  27. Recipe Cost Form with Conversions and Drop Down Menu

    Started by Dracoko4757‎, 02-24-2019 04:40 PM
    5 Attachment(s)
    • 6
    • 2,115
    JeteMc
    02-28-2019, 12:27 AM Go to last post

  28. [SOLVED] Return a list from a table with multiple values per line

    Started by Manwithaplan‎, 02-27-2019 06:46 PM
    aggregate function, create list, small function 2 Attachment(s)
    • 7
    • 703
    Bo_Ry
    02-28-2019, 12:25 AM Go to last post

  29. Combine Multiple Columns Into One Column With No Blank Spaces Or Duplicates

    Started by T86157‎, 02-27-2019 05:20 PM
    2 Attachment(s)
    • 1
    • 530
    Bo_Ry
    02-27-2019, 11:19 PM Go to last post

  30. Google Sheet Importrange - date

    Started by sirdon‎, 02-27-2019 10:51 PM
    • 0
    • 497
    sirdon
    02-27-2019, 10:51 PM Go to last post

  31. Return value from Wsheet 2 table based on concatenated text in Wsheet A

    Started by DarrenGTSCR‎, 02-27-2019 10:19 PM
    2 Attachment(s)
    • 1
    • 242
    Phuocam
    02-27-2019, 10:30 PM Go to last post

  32. Formula to extract text

    Started by AnitaAus1‎, 02-27-2019 08:28 PM
    1 Attachment(s)
    • 3
    • 293
    Pete_UK
    02-27-2019, 08:47 PM Go to last post

  33. DMIN Function

    Started by BLD21‎, 02-22-2019 12:39 PM
    2 Attachment(s)
    • 6
    • 515
    JeteMc
    02-27-2019, 07:55 PM Go to last post

  34. [SOLVED] Auto fill date and day

    Started by v!o‎, 02-27-2019 06:38 PM
    1 Attachment(s)
    • 4
    • 281
    TMS
    02-27-2019, 07:49 PM Go to last post

  35. [SOLVED] Dependant Drop Down List with Matching Values

    Started by nico-741‎, 02-26-2019 09:54 PM
    2 Attachment(s)
    • 2
    • 333
    nico-741
    02-27-2019, 07:22 PM Go to last post

  36. Excel Query - connecting to MySQL + current spreadsheet as parameter

    Started by marcinpec‎, 02-27-2019 06:55 AM
    • 1
    • 407
    dflak
    02-27-2019, 06:08 PM Go to last post

  37. [SOLVED] If This or That Formula

    Started by lgsikaffy‎, 02-26-2019 02:08 PM
    1 Attachment(s)
    • 4
    • 279
    TMS
    02-27-2019, 05:55 PM Go to last post

  38. Pivot Tabel Custom Date Filter "before or equal to: This Date Last Year

    Started by MrMims82‎, 02-27-2019 03:41 PM
    1 Attachment(s)
    • 1
    • 295
    MarvinP
    02-27-2019, 05:22 PM Go to last post

  39. [SOLVED] Different data Fill from upper cell in down

    Started by udprocks‎, 02-27-2019 04:03 PM
    2 Attachment(s)
    • 2
    • 220
    udprocks
    02-27-2019, 05:20 PM Go to last post

  40. Question Formula to pull data from sheet to another sheet

    Started by bjohnson0916‎, 02-27-2019 12:24 PM
    1 Attachment(s)
    • 1
    • 231
    benrhopkins
    02-27-2019, 05:10 PM Go to last post

  41. Summary of total number of hours per date

    Started by Sudha Kallepalli‎, 02-27-2019 10:46 AM
    4 Attachment(s)
    • 4
    • 280
    benrhopkins
    02-27-2019, 04:50 PM Go to last post

  42. variance analysis - formula issue when comparing actual Vs Budget as a %

    Started by RichardC82‎, 02-27-2019 06:41 AM
    1 Attachment(s)
    • 2
    • 373
    MrShorty
    02-27-2019, 04:42 PM Go to last post

  43. Need Help with formula to figure out overtime with conditions

    Started by switzd0d‎, 02-27-2019 04:07 PM
    • 0
    • 229
    switzd0d
    02-27-2019, 04:07 PM Go to last post

  44. Question [SOLVED] Improve Formula to meet Max condition

    Started by jantonio‎, 02-27-2019 12:34 PM
    1 Attachment(s)
    • 5
    • 296
    63falcondude
    02-27-2019, 03:47 PM Go to last post

  45. Total of all cells with specific text criteria

    Started by ddasilva‎, 02-27-2019 01:43 PM
    • 3
    • 226
    Sam Capricci
    02-27-2019, 03:15 PM Go to last post

  46. [SOLVED] Formula for conditional format

    Started by juco‎, 02-27-2019 02:41 PM
    • 4
    • 206
    Fluff13
    02-27-2019, 03:04 PM Go to last post

  47. [SOLVED] Ref. series of columns on another sheet and sum

    Started by dad812‎, 02-26-2019 08:33 PM
    2 Attachment(s)
    • 11
    • 299
    dad812
    02-27-2019, 01:55 PM Go to last post

  48. [SOLVED] Sum/Count between unknown number of Values

    Started by benrhopkins‎, 02-27-2019 01:36 PM
    1 Attachment(s)
    • 2
    • 500
    benrhopkins
    02-27-2019, 01:51 PM Go to last post

  49. Help with populating adjacent cells with list value

    Started by Kbass‎, 02-25-2019 06:26 PM
    3 Attachment(s)
    • 8
    • 489
    wyowhite
    02-27-2019, 01:45 PM Go to last post

  50. [SOLVED] Formula works until I change CountIF to CountIFS

    Started by spenny32‎, 02-27-2019 01:10 PM
    1 Attachment(s)
    • 4
    • 214
    Sam Capricci
    02-27-2019, 01:31 PM Go to last post
+ Post New Thread
Page 991 of 5611 FirstFirst ... 991 ...

Forum Information and Options

Users Browsing this Forum

There are currently 53 users browsing this forum. (2 members & 51 guests)

  1. andresventura,
  2. R0CKY

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