+ Post New Thread
Page 1101 of 5613 FirstFirst ... 1101 ...
Threads 55001 to 55050 of 280601

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

  1. [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

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

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

  3. [SOLVED] Offsets linking several sheets

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

  4. 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

  5. [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

  6. 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

  7. [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
    • 416
    FlameRetired
    09-13-2018, 05:06 PM Go to last post

  8. [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

  9. [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,332
    lmcc007
    09-13-2018, 04:00 PM Go to last post

  10. [SOLVED] Randbetween excluding certain letters/numbers

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

  11. [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

  12. 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
    • 298
    jtakw
    09-13-2018, 03:02 PM Go to last post

  13. 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

  14. [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

  15. Macro to transfer information from html to excel

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

  16. Index Match function returns #NA

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

  17. [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
    • 714
    siroco79
    09-13-2018, 11:29 AM Go to last post

  18. Extracting in and out value times to another sheet

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

  19. Can't VLOOKUP data from a query?

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

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

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

  21. [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

  22. 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
    • 535
    JLGWhiz
    09-13-2018, 09:34 AM Go to last post

  23. 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

  24. 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

  25. [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

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

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

  27. [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

  28. Last occurrence after meet multiple criterias

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

  29. [SOLVED] Need help with conditional formatting

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

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

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

  31. 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

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

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

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

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

  34. 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

  35. ROUNDUP not working

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

  36. [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

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

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

  38. 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

  39. 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
    • 898
    boren0023
    09-12-2018, 04:39 PM Go to last post

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

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

  41. [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

  42. [SOLVED] Searching a cell for mutiple words

    Started by Ron Purpura‎, 09-12-2018 02:43 PM
    1 Attachment(s)
    • 6
    • 365
    Sam Capricci
    09-12-2018, 03:47 PM Go to last post

  43. [SOLVED] How to copy a formula without the link

    Started by TPS‎, 09-11-2018 10:25 AM
    • 5
    • 1,135
    FDibbins
    09-12-2018, 03:44 PM Go to last post

  44. Profile and loss calculation?

    Started by QuantEdge‎, 09-11-2018 11:58 AM
    3 Attachment(s)
    • 17
    • 483
    FlameRetired
    09-12-2018, 03:36 PM Go to last post

  45. How to Automatically Sum Totals for Room Bookings based on Price Criteria

    Started by irishshopper‎, 09-09-2018 08:28 AM
    • 4
    • 373
    irishshopper
    09-12-2018, 03:18 PM Go to last post

  46. [SOLVED] Nested "IF" with multiple criteria. Please help!

    Started by Crystal Rose‎, 09-12-2018 01:57 PM
    1 Attachment(s)
    • 10
    • 439
    Sam Capricci
    09-12-2018, 02:55 PM Go to last post

  47. show values by input numbers (seperated by comma)

    Started by fegeez‎, 09-12-2018 08:35 AM
    excel, formule, input, output, values 2 Attachment(s)
    • 2
    • 466
    fegeez
    09-12-2018, 02:34 PM Go to last post

  48. Formula for 60 day count down from specific date

    Started by josem‎, 09-12-2018 01:32 PM
    • 1
    • 306
    mrice
    09-12-2018, 02:26 PM Go to last post

  49. [SOLVED] Date formula comparing TODAY and fixed date to give monthly value

    Started by Grasshopper Green‎, 09-12-2018 01:13 PM
    2 Attachment(s)
    • 3
    • 312
    Glenn Kennedy
    09-12-2018, 02:15 PM Go to last post

  50. [SOLVED] Number of points based on percentage completion

    Started by waimea‎, 09-12-2018 12:46 PM
    • 6
    • 308
    6StringJazzer
    09-12-2018, 02:05 PM Go to last post
+ Post New Thread
Page 1101 of 5613 FirstFirst ... 1101 ...

Forum Information and Options

Users Browsing this Forum

There are currently 75 users browsing this forum. (7 members & 68 guests)

  1. Clear Skies,
  2. dudeinaghillie,
  3. edriks,
  4. evee,
  5. finallymint,
  6. Sultan1994

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