+ Post New Thread
Page 499 of 5614 FirstFirst ... 499 ...
Threads 24901 to 24950 of 280687

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

  1. [SOLVED] #NAME? error with IFS formula

    Started by Jisa‎, 04-21-2017 02:25 PM
    1 Attachment(s)
    • 10
    • 3,401
    TMS
    04-21-2017, 05:31 PM Go to last post

  2. Question Sort Mixed Data With Periods, Letters, Numbers, Backslashes and Hyphens

    Started by officemate‎, 06-16-2015 09:44 AM
    sort
    • 10
    • 3,065
    Pauleyb
    06-16-2015, 01:59 PM Go to last post

  3. [SOLVED] Take an average of various fields

    Started by Robinsky‎, 06-19-2015 03:31 PM
    3 Attachment(s)
    • 10
    • 453
    oeldere
    06-19-2015, 06:56 PM Go to last post

  4. Cool IF based on Array Numbers

    Started by tangomj‎, 06-22-2015 02:40 PM
    3 Attachment(s)
    • 10
    • 425
    DBY
    06-22-2015, 04:10 PM Go to last post

  5. get most frequent number mode.mult give me same number

    Started by tomislav91‎, 04-12-2017 11:50 AM
    1 Attachment(s)
    • 10
    • 583
    XOR LX
    04-13-2017, 03:40 AM Go to last post

  6. Sumifs wild card dealing with blamks

    Started by Sean Thomas‎, 04-14-2017 11:15 AM
    3 Attachment(s)
    • 10
    • 457
    XOR LX
    04-15-2017, 05:59 AM Go to last post

  7. Calculating Difference in Business Days

    Started by bdav1216‎, 04-14-2017 06:42 PM
    4 Attachment(s)
    • 10
    • 948
    Logit
    04-18-2017, 11:17 AM Go to last post

  8. [SOLVED] Vlookup and concatenate results - possible with formulas?

    Started by nautilia‎, 04-17-2017 12:31 PM
    concatenate, formula, mac excel, vlookup 7 Attachment(s)
    • 10
    • 868
    Glenn Kennedy
    04-20-2017, 06:43 AM Go to last post

  9. COUNTIFs: Multiple ranges, single criterion with OR logic

    Started by A.Khan‎, 04-18-2017 07:35 AM
    3 Attachment(s)
    • 10
    • 701
    XOR LX
    04-20-2017, 06:05 AM Go to last post

  10. [SOLVED] % Complete Formula Based On Value Of ANother Cell

    Started by rahul_ferns76‎, 04-18-2017 09:48 AM
    8 Attachment(s)
    • 10
    • 502
    Glenn Kennedy
    04-20-2017, 03:59 AM Go to last post

  11. [SOLVED] sum between blank cells

    Started by coolmob‎, 04-23-2017 11:57 AM
    3 Attachment(s)
    • 10
    • 1,618
    FlameRetired
    04-24-2017, 04:48 PM Go to last post

  12. [SOLVED] Count unique occurances formula

    Started by lreed‎, 04-20-2017 04:48 PM
    count, formula, unique occurance 3 Attachment(s)
    • 10
    • 684
    FlameRetired
    04-21-2017, 07:29 PM Go to last post

  13. Separate first 2 names and last name with suffix

    Started by marj0909‎, 06-22-2015 08:46 PM
    • 10
    • 1,734
    marj0909
    06-22-2015, 11:15 PM Go to last post

  14. [SOLVED] Vlookup for first 5 digits

    Started by Complus865‎, 04-02-2020 12:18 AM
    2 Attachment(s)
    • 10
    • 582
    AliGW
    04-02-2020, 08:58 AM Go to last post

  15. Need formula to locate a value in another worksheet

    Started by felio‎, 04-10-2020 02:58 PM
    5 Attachment(s)
    • 10
    • 367
    XOR LX
    04-12-2020, 07:31 AM Go to last post

  16. Retriving most recent payment

    Started by kashaikh78‎, 04-12-2020 11:23 AM
    4 Attachment(s)
    • 10
    • 432
    Bo_Ry
    04-15-2020, 12:33 AM Go to last post

  17. [SOLVED] COUNTIFS - Count certain cells based on date and symbol

    Started by mempien‎, 04-01-2020 04:06 AM
    1 Attachment(s)
    • 10
    • 372
    Fluff13
    04-01-2020, 11:26 AM Go to last post

  18. [SOLVED] getting multiple IF statements to work with pull down options

    Started by 76_shovel‎, 04-09-2020 08:06 PM
    4 Attachment(s)
    • 10
    • 462
    76_shovel
    04-13-2020, 09:09 AM Go to last post

  19. Question Calculate date, time, last saved by and percentages

    Started by television‎, 04-12-2020 03:20 PM
    2 Attachment(s)
    • 10
    • 381
    AliGW
    04-14-2020, 05:33 PM Go to last post

  20. Sum duration for each day based on text

    Started by twjolson‎, 04-13-2020 03:22 PM
    2 Attachment(s)
    • 10
    • 339
    twjolson
    04-15-2020, 01:35 PM Go to last post

  21. VLookup formula Not Dragging Down

    Started by chisme‎, 04-13-2020 05:54 PM
    formula not working, vlookup 4 Attachment(s)
    • 10
    • 818
    FDibbins
    04-13-2020, 11:47 PM Go to last post

  22. Arrange random number in ascending format

    Started by hkbhansali‎, 04-15-2020 10:14 AM
    1 Attachment(s)
    • 10
    • 253
    MrShorty
    04-16-2020, 02:09 PM Go to last post

  23. [SOLVED] Formula Based on multiple date ranges and results

    Started by SCOMINS‎, 04-18-2020 05:05 AM
    3 Attachment(s)
    • 10
    • 449
    AliGW
    04-19-2020, 02:24 AM Go to last post

  24. [SOLVED] Calculate Mode based on separated cells excluding 0 and text. if two modes return highest

    Started by Boudene‎, 04-23-2020 03:13 AM
    2 Attachment(s)
    • 10
    • 445
    XOR LX
    04-23-2020, 07:39 AM Go to last post

  25. Moved: SUMPRODUCTS Given Certain Criteria

    Started by PaddyP‎, 04-22-2020 02:27 PM
    •  
    •  

  26. Counting two criteria

    Started by dips_007‎, 10-14-2007 02:47 PM
    • 10
    • 759
    VBA Noob
    10-15-2007, 05:56 PM Go to last post

  27. RIGHT & MID & LEFT

    Started by Gary's Student‎, 09-06-2005 01:05 AM
    • 10
    • 496
    Melissa
    09-06-2005, 07:05 AM Go to last post

  28. Help writing a formula

    Started by paul‎, 09-06-2005 01:05 AM
    • 10
    • 631
    Adam
    09-06-2005, 07:05 AM Go to last post

  29. Shortcut keys assigned to macros/functions in excel

    Started by Max‎, 09-06-2005 01:05 AM
    • 10
    • 659
    Aussie CPA
    09-06-2005, 07:05 AM Go to last post

  30. subtracting based on available values

    Started by Max‎, 09-06-2005 01:05 AM
    • 10
    • 622
    Ted Metro
    09-06-2005, 07:05 AM Go to last post

  31. get a count of numbers whose value falls within a given range

    Started by Trevor Shuttleworth‎, 09-06-2005 01:05 AM
    • 10
    • 523
    LyleB_Austin
    09-06-2005, 07:05 AM Go to last post

  32. [SOLVED] help me write function?

    Started by bj‎, 09-06-2005 01:05 AM
    • 10
    • 597
    Zach
    09-06-2005, 07:05 AM Go to last post

  33. [SOLVED] How do I sum cells that have values from a countif formula?

    Started by Trevor Shuttleworth‎, 09-06-2005 01:05 AM
    • 10
    • 669
    Cheri
    09-06-2005, 07:05 AM Go to last post

  34. [SOLVED] cube root

    Started by Lewis Clark‎, 09-06-2005 01:05 AM
    • 10
    • 4,957
    derskell
    09-06-2005, 07:05 AM Go to last post

  35. [SOLVED] sumif criteria reference

    Started by Roger Govier‎, 09-06-2005 01:05 AM
    • 10
    • 476
    TimH
    09-06-2005, 07:05 AM Go to last post

  36. [SOLVED] Need to reference existing functions in a custom function: possibl

    Started by Max‎, 09-06-2005 01:05 AM
    • 10
    • 601
    dofnup
    09-06-2005, 07:05 AM Go to last post

  37. Numeric value problem

    Started by indira‎, 10-11-2007 11:13 AM
    • 10
    • 1,068
    indira
    10-11-2007, 03:41 PM Go to last post

  38. lookup across sheets

    Started by drchris‎, 10-12-2007 05:52 AM
    4 Attachment(s)
    • 10
    • 1,168
    oldchippy
    10-12-2007, 09:39 AM Go to last post

  39. SUMPRODUCT with two arrays and field selection

    Started by k33maja3‎, 06-25-2015 09:57 AM
    2 Attachment(s)
    • 10
    • 907
    zbor
    06-25-2015, 03:31 PM Go to last post

  40. [SOLVED] MATCHING UP OF MULTIPLE SHEETS.....Pls Pls Pls Help.............

    Started by samuella‎, 08-11-2012 06:06 AM
    2 Attachment(s)
    • 10
    • 1,028
    samuella
    08-14-2012, 01:45 AM Go to last post

  41. [SOLVED] Comparing a year value OR a specific word to the current year.

    Started by dtrimble‎, 08-13-2012 11:49 AM
    1 Attachment(s)
    • 10
    • 1,100
    dtrimble
    08-13-2012, 05:57 PM Go to last post

  42. Exclamation [SOLVED] How to pinpoint specific date from limiting ranges

    Started by narbit‎, 08-15-2012 03:45 AM
    dates, events, overlap, ranges, years 5 Attachment(s)
    • 10
    • 1,060
    narbit
    08-16-2012, 04:01 PM Go to last post

  43. [SOLVED] Assigning Numerical Values to Letters and Multiplying Them

    Started by DNAguy‎, 08-16-2012 05:44 PM
    1 Attachment(s)
    • 10
    • 769
    Cutter
    08-16-2012, 09:57 PM Go to last post

  44. Wink Vlookup advanced - might be a different formula needed (Return cell value)

    Started by tdearling‎, 04-12-2013 08:53 AM
    3 Attachment(s)
    • 10
    • 830
    cheal2
    04-12-2013, 01:49 PM Go to last post

  45. [SOLVED] If cell value in one column matches text, fill cell value in different column on same row

    Started by zigojacko‎, 04-16-2013 12:04 PM
    3 Attachment(s)
    • 10
    • 1,460
    Fotis1991
    04-17-2013, 05:21 AM Go to last post

  46. Red face Counting 5 years old below base by their birth date

    Started by vanther‎, 02-27-2014 01:28 AM
    counting 1 Attachment(s)
    • 10
    • 918
    :) Sixthsense :)
    03-14-2014, 02:38 AM Go to last post

  47. Logic check to prevent evaluation of an array formula

    Started by TheRobsterUK‎, 03-12-2014 06:30 AM
    • 10
    • 1,102
    Tony Valko
    03-12-2014, 11:24 AM Go to last post

  48. [SOLVED] If cell contains text display another cell

    Started by The.don‎, 03-12-2014 01:01 AM
    • 10
    • 666
    :) Sixthsense :)
    03-12-2014, 01:33 AM Go to last post

  49. [SOLVED] Nested IF difficulty.

    Started by Drayde‎, 03-13-2014 10:59 AM
    • 10
    • 700
    Kaper
    03-13-2014, 12:10 PM Go to last post

  50. Number of Items open longer than 1 week but less than 2 weeks

    Started by Roger Govier‎, 09-06-2005 01:05 AM
    • 10
    • 581
    Andibevan
    09-06-2005, 07:05 AM Go to last post
+ Post New Thread
Page 499 of 5614 FirstFirst ... 499 ...

Forum Information and Options

Users Browsing this Forum

There are currently 66 users browsing this forum. (1 members & 65 guests)

  1. HansDouwe

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