+ Post New Thread
Page 1103 of 5615 FirstFirst ... 1103 ...
Threads 55101 to 55150 of 280710

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. Make a dropdown value paste a cell range?

    Started by m_roussakis‎, 09-13-2018 05:03 PM
    • 3
    • 286
    FDibbins
    09-14-2018, 04:14 AM Go to last post

  2. [SOLVED] Show Date Within 3 Week Range For A Team Members First Day Of Holiday

    Started by JohnnySmith13‎, 09-13-2018 07:24 PM
    1 Attachment(s)
    • 3
    • 285
    JohnnySmith13
    09-14-2018, 03:39 AM Go to last post

  3. [SOLVED] vlookup nested formula

    Started by paxonltd‎, 09-14-2018 02:55 AM
    1 Attachment(s)
    • 2
    • 453
    Pepe Le Mokko
    09-14-2018, 03:09 AM Go to last post

  4. PRICE Formula for ACT/365 Convention

    Started by tmakalatia‎, 09-13-2018 05:39 AM
    2 Attachment(s)
    • 2
    • 823
    tmakalatia
    09-14-2018, 02:33 AM Go to last post

  5. Lightbulb Calculation of Manpower cost

    Started by matthew.ng.zh‎, 09-08-2018 03:11 AM
    3 Attachment(s)
    • 3
    • 1,237
    JeteMc
    09-14-2018, 12:06 AM Go to last post

  6. Moving monthly and quarterly totals

    Started by Merckx‎, 09-10-2018 10:24 PM
    1 Attachment(s)
    • 3
    • 1,704
    Merckx
    09-13-2018, 10:30 PM Go to last post

  7. Question Trying to make a "Daily Log Sheet", that calculates number and hours for activity

    Started by DukeDiablo‎, 08-23-2018 05:02 PM
    5 Attachment(s)
    • 6
    • 392
    DukeDiablo
    09-13-2018, 09:55 PM Go to last post

  8. Automatically stop counting date difference in datedif function

    Started by Md Aftab Uzzaman‎, 09-13-2018 11:22 AM
    1 Attachment(s)
    • 2
    • 442
    jason.b75
    09-13-2018, 08:33 PM Go to last post

  9. [SOLVED] Finding highest occurance of text ignoring blank cells

    Started by windme‎, 09-13-2018 06:35 PM
    1 Attachment(s)
    • 2
    • 1,449
    AlKey
    09-13-2018, 07:00 PM Go to last post

  10. [SOLVED] Concatenate Multiple Columns

    Started by fotodude‎, 09-12-2018 08:52 PM
    2 Attachment(s)
    • 5
    • 660
    FlameRetired
    09-13-2018, 06:46 PM Go to last post

  11. Formula for rounding / min where 0 values are present

    Started by beedee123‎, 09-12-2018 09:41 PM
    • 6
    • 356
    FlameRetired
    09-13-2018, 06:43 PM Go to last post

  12. [SOLVED] Offsets linking several sheets

    Started by lesiahawk‎, 09-02-2018 11:05 AM
    7 Attachment(s)
    • 14
    • 564
    JeteMc
    09-13-2018, 05:29 PM Go to last post

  13. Lookup + conditions

    Started by EXCELBENCH‎, 09-13-2018 04:26 PM
    3 Attachment(s)
    • 1
    • 325
    MarvinP
    09-13-2018, 05:25 PM Go to last post

  14. [SOLVED] Look up over 2 tabs

    Started by pmw19800‎, 09-13-2018 03:42 AM
    3 Attachment(s)
    • 5
    • 286
    pmw19800
    09-13-2018, 05:18 PM Go to last post

  15. If Formula for finding duplicates

    Started by Karavalkanov‎, 09-13-2018 11:34 AM
    3 Attachment(s)
    • 3
    • 411
    jtakw
    09-13-2018, 05:07 PM Go to last post

  16. [SOLVED] Need a column reference found as a variable for use in the MATCH function

    Started by Mark Teague‎, 09-12-2018 11:50 PM
    1 Attachment(s)
    • 9
    • 418
    FlameRetired
    09-13-2018, 05:06 PM Go to last post

  17. [SOLVED] Look up + Conditions

    Started by EXCELBENCH‎, 09-12-2018 05:28 PM
    4 Attachment(s)
    • 3
    • 263
    EXCELBENCH
    09-13-2018, 04:04 PM Go to last post

  18. [SOLVED] Using SUMPRODUCT and COUNTIF to check for duplicates appearing 3 or more times

    Started by lmcc007‎, 09-03-2018 03:27 AM
    4 Attachment(s)
    • 28
    • 1,337
    lmcc007
    09-13-2018, 04:00 PM Go to last post

  19. [SOLVED] Randbetween excluding certain letters/numbers

    Started by Wheelie686‎, 09-02-2013 01:54 PM
    2 Attachment(s)
    • 5
    • 7,262
    kirkja
    09-13-2018, 03:58 PM Go to last post

  20. [SOLVED] How to get Worked Hours from Time in and Out

    Started by EXCELBENCH‎, 09-13-2018 01:08 PM
    2 Attachment(s)
    • 5
    • 235
    CK76
    09-13-2018, 03:38 PM Go to last post

  21. Find a date within a column in different positions and copy it to a new column

    Started by traceymot‎, 09-13-2018 07:41 AM
    • 4
    • 299
    jtakw
    09-13-2018, 03:02 PM Go to last post

  22. Check 1 cell for Text and place another cell with $ value

    Started by JLeith‎, 09-12-2018 07:29 PM
    1 Attachment(s)
    • 2
    • 237
    JLeith
    09-13-2018, 01:53 PM Go to last post

  23. [SOLVED] Conditional Formatting Issue

    Started by MattHamby‎, 09-13-2018 11:45 AM
    4 Attachment(s)
    • 2
    • 426
    MattHamby
    09-13-2018, 01:26 PM Go to last post

  24. Macro to transfer information from html to excel

    Started by kapriano‎, 09-09-2018 03:34 PM
    1 Attachment(s)
    • 1
    • 261
    kapriano
    09-13-2018, 12:57 PM Go to last post

  25. Index Match function returns #NA

    Started by limpfisch‎, 09-13-2018 10:22 AM
    1 Attachment(s)
    • 4
    • 1,514
    joeu2004
    09-13-2018, 11:39 AM Go to last post

  26. [SOLVED] lookup and vlookup or index with combined with a nested IF?

    Started by siroco79‎, 09-05-2018 11:49 AM
    vlookup & match, vlookup + index + match 5 Attachment(s)
    • 7
    • 715
    siroco79
    09-13-2018, 11:29 AM Go to last post

  27. Extracting in and out value times to another sheet

    Started by rjcarlantonio‎, 09-12-2018 09:36 AM
    1 Attachment(s)
    • 5
    • 327
    davsth
    09-13-2018, 11:19 AM Go to last post

  28. Can't VLOOKUP data from a query?

    Started by imperialzinc‎, 09-13-2018 10:19 AM
    • 5
    • 703
    PeteABC123
    09-13-2018, 11:11 AM Go to last post

  29. [SOLVED] worksheets not auto updating when i add new data

    Started by chriswrcg‎, 09-13-2018 10:18 AM
    • 1
    • 326
    FerdyHar
    09-13-2018, 10:27 AM Go to last post

  30. [SOLVED] IF, AND, COUNTIF, COUNTIFS Functions Problem - Need Help!

    Started by MattHamby‎, 09-13-2018 09:31 AM
    • 4
    • 530
    FerdyHar
    09-13-2018, 10:06 AM Go to last post

  31. Comparing columns in two different excel sheets and if they match, copy a third column

    Started by RB135‎, 09-12-2018 10:58 AM
    • 3
    • 538
    JLGWhiz
    09-13-2018, 09:34 AM Go to last post

  32. Search for keyword in table and output all matches

    Started by Mccream1‎, 09-12-2018 11:00 AM
    2 Attachment(s)
    • 3
    • 314
    Mccream1
    09-13-2018, 08:48 AM Go to last post

  33. Greater Number being dominant between 2 cells

    Started by CLSSY56‎, 09-13-2018 08:44 AM
    • 1
    • 212
    63falcondude
    09-13-2018, 08:47 AM Go to last post

  34. [SOLVED] Formula to split a list into two new lists based on the service codes

    Started by The_Snook‎, 09-13-2018 06:48 AM
    1 Attachment(s)
    • 3
    • 252
    benishiryo
    09-13-2018, 08:13 AM Go to last post

  35. [SOLVED] Formula to count number of occurrences that meet multiple criteria

    Started by Losguapos1‎, 09-12-2018 11:47 AM
    1 Attachment(s)
    • 8
    • 904
    63falcondude
    09-13-2018, 07:38 AM Go to last post

  36. [SOLVED] Ignore Weekends

    Started by Klea‎, 09-12-2018 12:59 PM
    4 Attachment(s)
    • 7
    • 373
    Klea
    09-13-2018, 06:47 AM Go to last post

  37. Last occurrence after meet multiple criterias

    Started by Dahlia‎, 09-13-2018 04:49 AM
    lookup 2 criteria's
    • 4
    • 337
    jason.b75
    09-13-2018, 06:16 AM Go to last post

  38. [SOLVED] Need help with conditional formatting

    Started by levon68‎, 09-12-2018 12:08 PM
    1 Attachment(s)
    • 5
    • 269
    levon68
    09-13-2018, 05:46 AM Go to last post

  39. [SOLVED] Return pass/fail on array lookup.

    Started by crazymaca69‎, 09-12-2018 06:37 AM
    1 Attachment(s)
    • 3
    • 674
    benishiryo
    09-13-2018, 05:23 AM Go to last post

  40. Exclamation Listing of numbers within different postcode ranges given in one column

    Started by imran999‎, 09-13-2018 02:52 AM
    listing of numbers 1 Attachment(s)
    • 1
    • 380
    Olly
    09-13-2018, 04:43 AM Go to last post

  41. [SOLVED] Formula populating data from multiple sheets to summary sheet

    Started by $mart Group‎, 09-12-2018 11:01 PM
    • 4
    • 575
    kersplash
    09-13-2018, 12:58 AM Go to last post

  42. How to keep titles, sub-titles, and blank space when sorting

    Started by wanttolearnexcel‎, 09-12-2018 11:11 PM
    2 Attachment(s)
    • 2
    • 322
    wanttolearnexcel
    09-13-2018, 12:54 AM Go to last post

  43. If certain words appear in a cell, return the value of another cell

    Started by lizziemac‎, 09-12-2018 06:32 PM
    • 3
    • 275
    jtakw
    09-12-2018, 06:49 PM Go to last post

  44. ROUNDUP not working

    Started by goalieman86‎, 09-12-2018 03:25 PM
    • 4
    • 8,534
    joeu2004
    09-12-2018, 06:46 PM Go to last post

  45. [SOLVED] find last cell with data

    Started by joao56777‎, 08-09-2018 02:22 PM
    7 Attachment(s)
    • 22
    • 1,140
    José Augusto
    09-12-2018, 05:18 PM Go to last post

  46. [SOLVED] Great Than, less than, equal to

    Started by windrain‎, 09-11-2018 06:24 PM
    2 Attachment(s)
    • 4
    • 347
    jtakw
    09-12-2018, 05:13 PM Go to last post

  47. Multiple data entry leading to multiple worksheets....I'm baffled!!

    Started by Victorthesecond‎, 09-10-2018 01:19 PM
    7 Attachment(s)
    • 18
    • 634
    Victorthesecond
    09-12-2018, 04:42 PM Go to last post

  48. Excel COUNTIFS Assistance with Duplicate Values & Multiple Criteria

    Started by boren0023‎, 09-12-2018 11:36 AM
    countifs, duplicate, excel, formula, multiple 1 Attachment(s)
    • 7
    • 900
    boren0023
    09-12-2018, 04:39 PM Go to last post

  49. Question Help with droplist and pickup value from diffreent sheets

    Started by Mickepersson‎, 09-12-2018 05:18 AM
    • 1
    • 482
    dflak
    09-12-2018, 04:38 PM Go to last post

  50. [SOLVED] Filtering by date range that overlaps on a year

    Started by Brennen81‎, 09-12-2018 01:40 PM
    5 Attachment(s)
    • 9
    • 445
    FDibbins
    09-12-2018, 04:09 PM Go to last post
+ Post New Thread
Page 1103 of 5615 FirstFirst ... 1103 ...

Forum Information and Options

Users Browsing this Forum

There are currently 94 users browsing this forum. (6 members & 88 guests)

  1. Fluff13,
  2. Gregb11,
  3. Kaper,
  4. Lafsen,
  5. RogueStab

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