+ Post New Thread
Page 1005 of 5614 FirstFirst ... 1005 ...
Threads 50201 to 50250 of 280692

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

  1. [SOLVED] Formula for a Date finder and auto filler

    Started by mutzie‎, 02-15-2019 02:29 AM
    3 Attachment(s)
    • 3
    • 392
    Bo_Ry
    02-15-2019, 03:38 AM Go to last post

  2. [SOLVED] VLOOKUP To Another Workbook #VALUE!

    Started by Livewire089‎, 02-14-2019 08:51 AM
    • 2
    • 313
    FDibbins
    02-15-2019, 02:43 AM Go to last post

  3. [SOLVED] How to count rows based in numerical order based on cell values?

    Started by AccountingJ‎, 02-14-2019 04:13 PM
    3 Attachment(s)
    • 6
    • 327
    FlameRetired
    02-14-2019, 10:54 PM Go to last post

  4. [SOLVED] VLOOKUP assistance

    Started by mc2468‎, 02-13-2019 08:05 PM
    2 Attachment(s)
    • 3
    • 241
    mc2468
    02-14-2019, 09:34 PM Go to last post

  5. [SOLVED] How to restrict entry of a field based on two other cells

    Started by brownbag‎, 02-14-2019 05:48 PM
    2 Attachment(s)
    • 5
    • 302
    TFiske
    02-14-2019, 09:02 PM Go to last post

  6. [SOLVED] ISNUMBER Formula Cleanup

    Started by Wheelie686‎, 02-14-2019 08:17 PM
    • 2
    • 211
    Wheelie686
    02-14-2019, 08:59 PM Go to last post

  7. Post Rounding question

    Started by jmccarl‎, 02-14-2019 08:04 PM
    custom, formula, rounding 1 Attachment(s)
    • 3
    • 421
    shg
    02-14-2019, 08:31 PM Go to last post

  8. [SOLVED] Three Column Comparsion Against Another Three Columns

    Started by Excell1677‎, 02-13-2019 10:17 PM
    column match, match, three columns 1 Attachment(s)
    • 4
    • 335
    Excell1677
    02-14-2019, 07:14 PM Go to last post

  9. [SOLVED] Calculate amount between times and then a grand total

    Started by Beh162‎, 02-12-2019 02:47 PM
    2 Attachment(s)
    • 9
    • 512
    Beh162
    02-14-2019, 07:01 PM Go to last post

  10. Distribute 100% over 20 cells in Bell Curve

    Started by ManishaFin‎, 02-14-2019 05:10 PM
    1 Attachment(s)
    • 2
    • 327
    ManishaFin
    02-14-2019, 05:41 PM Go to last post

  11. Cell format being overwritten

    Started by Stargazer1‎, 02-11-2019 12:39 AM
    1 Attachment(s)
    • 4
    • 689
    Stargazer1
    02-14-2019, 05:17 PM Go to last post

  12. help making data from vlookup hold on one page, add new data vlookup & place in 2nd page

    Started by andy k‎, 02-14-2019 05:02 PM
    • 0
    • 209
    andy k
    02-14-2019, 05:02 PM Go to last post

  13. Search multiple cells for multiple words and receive back....

    Started by Saintom‎, 02-14-2019 04:16 PM
    1 Attachment(s)
    • 3
    • 555
    Saintom
    02-14-2019, 04:41 PM Go to last post

  14. Formula for repeating function on several cells from every nth row

    Started by luke12343‎, 02-14-2019 12:39 AM
    • 2
    • 305
    luke12343
    02-14-2019, 04:21 PM Go to last post

  15. [SOLVED] Inconstant results within 'if' functions

    Started by confused98520‎, 02-13-2019 09:58 PM
    excel, if function, inconsistent, quotation
    • 3
    • 465
    FlameRetired
    02-14-2019, 04:08 PM Go to last post

  16. If cell value in column A matches cell value in column C, sum B

    Started by KeighlR‎, 02-14-2019 03:17 PM
    1 Attachment(s)
    • 1
    • 243
    etaf
    02-14-2019, 04:01 PM Go to last post

  17. [SOLVED] Complex IF/AND/OR/THEN Statement

    Started by madouxan‎, 02-11-2019 04:31 PM
    if and or then 1 Attachment(s)
    • 5
    • 776
    madouxan
    02-14-2019, 03:35 PM Go to last post

  18. Return a value from a column based on the highest number in the adjacent column

    Started by StanLeakup‎, 02-14-2019 03:10 AM
    4 Attachment(s)
    • 5
    • 385
    XLent
    02-14-2019, 02:20 PM Go to last post

  19. Flexible timebooking in list, show doublebooking

    Started by DJskillz‎, 02-14-2019 02:09 PM
    list all between 2 values, time between
    • 0
    • 291
    DJskillz
    02-14-2019, 02:09 PM Go to last post

  20. Question [SOLVED] use formulas or power query to add/duplicate linked rows with data based on column

    Started by loganpmgoa‎, 02-13-2019 03:40 PM
    • 1
    • 552
    loganpmgoa
    02-14-2019, 01:46 PM Go to last post

  21. Formula to replace single spaces only?

    Started by Hozcat‎, 02-14-2019 08:53 AM
    • 2
    • 269
    Hozcat
    02-14-2019, 01:37 PM Go to last post

  22. formulas equating to numbers, then pasted as values, seem not to be quite numbers...

    Started by lotusman‎, 02-10-2019 08:11 AM
    not quite numbers, paste as values, why?
    • 2
    • 326
    lotusman
    02-14-2019, 01:27 PM Go to last post

  23. [SOLVED] Avoiding Circular Reasoning to Add "-" If Answer is $0.00

    Started by Kogen‎, 02-14-2019 12:52 PM
    1 Attachment(s)
    • 5
    • 313
    63falcondude
    02-14-2019, 01:25 PM Go to last post

  24. Include Calculations in excel Form

    Started by Sailing Simon‎, 02-14-2019 01:03 PM
    • 1
    • 205
    Pepe Le Mokko
    02-14-2019, 01:05 PM Go to last post

  25. match the loans based off of the serial number

    Started by kvpoteat‎, 02-14-2019 12:45 PM
    • 1
    • 300
    Pepe Le Mokko
    02-14-2019, 01:00 PM Go to last post

  26. [SOLVED] to find all the positons of character in a text which is unmatched with other text string.

    Started by Vivek2705‎, 02-13-2019 08:48 AM
    1 Attachment(s)
    • 7
    • 368
    FlameRetired
    02-14-2019, 12:38 PM Go to last post

  27. Comapring two sheets together

    Started by Eduards‎, 02-14-2019 11:33 AM
    1 Attachment(s)
    • 1
    • 173
    José Augusto
    02-14-2019, 12:31 PM Go to last post

  28. [SOLVED] Vlookup rendering incorrect information on some inputs

    Started by Kogen‎, 02-12-2019 05:16 PM
    1 Attachment(s)
    • 4
    • 246
    Kogen
    02-14-2019, 12:31 PM Go to last post

  29. Populate Sheet if Cell Referenced Contains Value

    Started by lsmith117‎, 02-14-2019 12:02 PM
    2 Attachment(s)
    • 1
    • 232
    MarvinP
    02-14-2019, 12:12 PM Go to last post

  30. Lightbulb Attendance Tracker Modification

    Started by spyrockz‎, 02-14-2019 11:23 AM
    attendance, tracker 2 Attachment(s)
    • 4
    • 493
    spyrockz
    02-14-2019, 11:59 AM Go to last post

  31. Array formula needed? Not sure how to query a dataset

    Started by willm‎, 02-14-2019 08:30 AM
    5 Attachment(s)
    • 8
    • 268
    willm
    02-14-2019, 11:57 AM Go to last post

  32. Replace/Update olds values with new values

    Started by jackpot21‎, 02-14-2019 11:35 AM
    • 1
    • 210
    KOKOSEK
    02-14-2019, 11:49 AM Go to last post

  33. SUMIF INDEX MATCH formula?

    Started by Sian8897‎, 02-14-2019 10:28 AM
    1 Attachment(s)
    • 2
    • 361
    Sian8897
    02-14-2019, 11:25 AM Go to last post

  34. [SOLVED] Formula to generate unique list in same sequence as original

    Started by kev_‎, 02-14-2019 10:32 AM
    2 Attachment(s)
    • 3
    • 441
    PaulM100
    02-14-2019, 11:24 AM Go to last post

  35. Data Comparison

    Started by RFearnley40‎, 02-13-2019 09:46 AM
    1 Attachment(s)
    • 3
    • 372
    dflak
    02-14-2019, 11:18 AM Go to last post

  36. [SOLVED] Index & Match, Three Criteria Rows & Columns.

    Started by Gazsim‎, 02-13-2019 12:35 PM
    index & match, multiple criteria 1 Attachment(s)
    • 4
    • 840
    63falcondude
    02-14-2019, 10:56 AM Go to last post

  37. [SOLVED] Business Hours between 2 dates/times excluding weekends and holidays

    Started by Skycap‎, 02-13-2019 03:21 PM
    business days, business hours
    • 5
    • 700
    XLent
    02-14-2019, 10:48 AM Go to last post

  38. Sumif help please

    Started by RichardC82‎, 02-14-2019 08:32 AM
    sumif help please
    • 5
    • 222
    RichardC82
    02-14-2019, 10:38 AM Go to last post

  39. Need formula for CARRY FORWARD LEAVES

    Started by kreesh‎, 02-14-2019 10:28 AM
    1 Attachment(s)
    • 0
    • 1,313
    kreesh
    02-14-2019, 10:28 AM Go to last post

  40. Drop down list returns formulas

    Started by AFC12‎, 02-14-2019 08:31 AM
    • 2
    • 260
    AFC12
    02-14-2019, 09:47 AM Go to last post

  41. [SOLVED] how to find missing "false" parts of nested IF formulas

    Started by jrtaylor‎, 02-14-2019 08:45 AM
    2 Attachment(s)
    • 2
    • 237
    kersplash
    02-14-2019, 09:23 AM Go to last post

  42. [SOLVED] inconsistent results with SUMPRODUCT

    Started by moneypennie21‎, 02-14-2019 07:05 AM
    calculation, sumproduct
    • 8
    • 1,050
    moneypennie21
    02-14-2019, 08:39 AM Go to last post

  43. [SOLVED] Offset with Hlookup

    Started by caabdul‎, 02-14-2019 08:07 AM
    • 2
    • 445
    caabdul
    02-14-2019, 08:35 AM Go to last post

  44. Indirect function gives Circular error

    Started by BPraveen‎, 02-08-2019 12:29 AM
    3 Attachment(s)
    • 8
    • 2,328
    BPraveen
    02-14-2019, 08:12 AM Go to last post

  45. [SOLVED] Formula to remove immediate duplicates

    Started by kev_‎, 02-14-2019 04:46 AM
    3 Attachment(s)
    • 4
    • 348
    kev_
    02-14-2019, 07:40 AM Go to last post

  46. Thumbs up Drop down list pulls data from QTR1/QTR2/QTR3/QTR4 from 14 tabs

    Started by mloring1972‎, 02-14-2019 06:20 AM
    1 Attachment(s)
    • 2
    • 883
    Richard Buttrey
    02-14-2019, 06:36 AM Go to last post

  47. IF/INDEX/MATCH?? - for looking up specific cells and quantities

    Started by RickCov‎, 02-14-2019 05:54 AM
    2 Attachment(s)
    • 6
    • 271
    Richard Buttrey
    02-14-2019, 06:31 AM Go to last post

  48. sum based between dates. with out effcting current formula

    Started by pmw19800‎, 02-14-2019 06:18 AM
    1 Attachment(s)
    • 1
    • 264
    PaulM100
    02-14-2019, 06:30 AM Go to last post

  49. Return the top 3 largest amounts in each category based on identifier

    Started by StanLeakup‎, 02-14-2019 03:27 AM
    3 Attachment(s)
    • 2
    • 246
    kvsrinivasamurthy
    02-14-2019, 06:10 AM Go to last post

  50. Cool Excel2010 - Conditional Formatting (Multiple Address List)

    Started by ExcelFan23‎, 02-13-2019 01:01 PM
    2 Attachment(s)
    • 4
    • 316
    ExcelFan23
    02-14-2019, 05:51 AM Go to last post
+ Post New Thread
Page 1005 of 5614 FirstFirst ... 1005 ...

Forum Information and Options

Users Browsing this Forum

There are currently 53 users browsing this forum. (3 members & 50 guests)

  1. Phuocam,
  2. Rick Rothstein

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