+ Post New Thread
Page 452 of 5619 FirstFirst ... 452 ...
Threads 22551 to 22600 of 280933

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

  1. Cool [SOLVED] Which function do i have to use for counting only the names in one column ?

    Started by detektiv‎, 06-10-2018 05:14 AM
    function, names 1 Attachment(s)
    • 11
    • 651
    AliGW
    06-10-2018, 08:10 AM Go to last post

  2. [SOLVED] How do I find the number of the list is the addition of an equal number?

    Started by wiliam_s‎, 12-20-2015 10:23 AM
    4 Attachment(s)
    • 11
    • 718
    Richard Buttrey
    12-21-2015, 10:30 AM Go to last post

  3. how to get the specific time group for lookup a cell input?

    Started by tinyau‎, 02-21-2016 10:28 AM
    2 Attachment(s)
    • 11
    • 693
    Tony Valko
    02-24-2016, 06:26 AM Go to last post

  4. [SOLVED] INDEX Array Formula with multiple criteria in multiple columns, is it possible?

    Started by jparve3283‎, 02-01-2016 08:00 PM
    2 Attachment(s)
    • 11
    • 963
    Tony Valko
    02-11-2016, 05:51 PM Go to last post

  5. [SOLVED] Sumif code without size and colour

    Started by makinmomb‎, 03-05-2016 01:47 PM
    1 Attachment(s)
    • 11
    • 705
    Tony Valko
    03-05-2016, 02:44 PM Go to last post

  6. [SOLVED] Need help with INDEX/MATCH formula

    Started by csepesy‎, 02-08-2016 12:50 PM
    8 Attachment(s)
    • 11
    • 838
    JeteMc
    02-09-2016, 12:44 PM Go to last post

  7. Finding 2 cells >0

    Started by basset87‎, 02-12-2016 11:26 PM
    • 11
    • 763
    basset87
    02-14-2016, 09:03 AM Go to last post

  8. [SOLVED] Rank and Nested IF Formula - Help Please!

    Started by hokkaido19‎, 02-18-2016 10:18 PM
    2 Attachment(s)
    • 11
    • 1,298
    JeteMc
    02-26-2016, 11:17 AM Go to last post

  9. [SOLVED] Help with Index function to find range of cells

    Started by Bretyuin‎, 02-24-2016 04:36 AM
    index 1 Attachment(s)
    • 11
    • 898
    Bretyuin
    02-24-2016, 05:58 AM Go to last post

  10. [SOLVED] Using a oggle button criteria within a countifs function

    Started by Slurry Pumper‎, 05-31-2018 11:33 AM
    2 Attachment(s)
    • 11
    • 907
    Slurry Pumper
    05-31-2018, 03:46 PM Go to last post

  11. Post Rotating List

    Started by zombiehairdu‎, 12-18-2017 03:15 AM
    3 Attachment(s)
    • 11
    • 1,244
    zombiehairdu
    12-18-2017, 12:42 PM Go to last post

  12. How to sort the data into a new table

    Started by hh2017‎, 06-18-2018 09:33 PM
    sort 2 Attachment(s)
    • 11
    • 1,030
    hh2017
    06-21-2018, 07:47 AM Go to last post

  13. [SOLVED] Finding the first, then second, then third selection

    Started by JimDandy‎, 06-11-2018 12:15 PM
    4 Attachment(s)
    • 11
    • 501
    FDibbins
    06-11-2018, 11:24 PM Go to last post

  14. ARRAY FORMULA With IF, AND/OR Functions

    Started by almugs‎, 03-04-2016 05:23 AM
    arrays, if function, multiple criteria 1 Attachment(s)
    • 11
    • 2,141
    JohnTopley
    03-04-2016, 12:17 PM Go to last post

  15. [SOLVED] Index/Match all associations formula help

    Started by lilsnoop‎, 11-21-2021 11:58 AM
    3 Attachment(s)
    • 11
    • 335
    lilsnoop
    11-21-2021, 04:58 PM Go to last post

  16. [SOLVED] Turn a COUNT formula into a Spilled Array formula

    Started by sire152003‎, 11-18-2021 07:13 PM
    array, spill, spilled range 3 Attachment(s)
    • 11
    • 591
    sire152003
    11-19-2021, 06:38 AM Go to last post

  17. [SOLVED] Return multiple rows based on multiple critera

    Started by meesha123‎, 10-27-2021 02:11 PM
    3 Attachment(s)
    • 11
    • 452
    meesha123
    11-16-2021, 07:17 AM Go to last post

  18. [SOLVED] IF with dates and conditions

    Started by Nours‎, 12-12-2021 03:49 AM
    2 Attachment(s)
    • 11
    • 250
    Nours
    12-12-2021, 08:53 AM Go to last post

  19. [SOLVED] Formula to allocate no. of days to months given start & end dates

    Started by paulma1960‎, 11-11-2021 09:27 AM
    5 Attachment(s)
    • 11
    • 370
    paulma1960
    11-17-2021, 07:13 AM Go to last post

  20. [SOLVED] formula help, to calculate the days onsite in a movement planner

    Started by Stephen Reeves‎, 11-03-2021 08:17 AM
    calulated fields, date count, date planner, formating 2 Attachment(s)
    • 11
    • 457
    Keebellah
    11-24-2021, 12:45 PM Go to last post

  21. [SOLVED] List top 5 items from a table

    Started by chaliseyp‎, 11-22-2021 01:26 AM
    4 Attachment(s)
    • 11
    • 324
    DJunqueira
    11-23-2021, 04:43 AM Go to last post

  22. Question Index Match with multiple criteria to match on VL table.

    Started by HenryF234‎, 11-24-2021 06:46 PM
    vl index match if 1 Attachment(s)
    • 11
    • 473
    GeoffW283
    12-08-2021, 02:23 AM Go to last post

  23. Question [SOLVED] Format is too long

    Started by GMVSHORT‎, 12-01-2021 10:40 AM
    long forumla, replace 1 Attachment(s)
    • 11
    • 521
    GMVSHORT
    12-17-2021, 12:24 PM Go to last post

  24. [SOLVED] Counting unique values in range, ignoring blank and "#N/A" values

    Started by Pr0‎, 11-30-2021 04:54 PM
    4 Attachment(s)
    • 11
    • 380
    Pr0
    12-01-2021, 09:39 AM Go to last post

  25. Sumif: Get value from different row

    Started by Guillaume023‎, 12-08-2021 12:13 PM
    3 Attachment(s)
    • 11
    • 367
    TMS
    12-09-2021, 09:30 AM Go to last post

  26. Question about counting cell thats have two different text in two different columns

    Started by rgrocks‎, 09-19-2013 07:44 PM
    1 Attachment(s)
    • 11
    • 787
    Tony Valko
    09-20-2013, 10:13 AM Go to last post

  27. [SOLVED] average numbers in sequence

    Started by bill gras‎, 10-21-2005 03:05 AM
    • 11
    • 1,055
    Stefi
    10-26-2005, 04:05 AM Go to last post

  28. Restricted value sequences in rows

    Started by yukon_phil‎, 07-18-2006 11:20 AM
    • 11
    • 945
    vezerid
    07-18-2006, 05:05 PM Go to last post

  29. Nested IFs and VLOOKUPs

    Started by Johny1‎, 02-06-2009 07:06 PM
    5 Attachment(s)
    • 11
    • 2,051
    Johny1
    09-26-2009, 07:11 AM Go to last post

  30. Sorting rows on whether they contain a specific string

    Started by greek‎, 09-07-2009 05:50 PM
    • 11
    • 1,507
    NBVC
    09-08-2009, 02:04 PM Go to last post

  31. how to look for spaces?

    Started by verhaba‎, 09-17-2009 02:44 PM
    1 Attachment(s)
    • 11
    • 1,083
    martindwilson
    09-20-2009, 05:47 PM Go to last post

  32. How do i use the formula while taking a margin of items

    Started by Alagarsamy‎, 11-20-2012 04:57 AM
    • 11
    • 746
    Fotis1991
    11-29-2012, 04:41 AM Go to last post

  33. [SOLVED] Working out a grade average using a lookup table

    Started by kitkatkin‎, 11-29-2012 05:59 PM
    1 Attachment(s)
    • 11
    • 1,176
    kitkatkin
    11-29-2012, 07:48 PM Go to last post

  34. Exclamation [SOLVED] Calculate/sum multiple values in each cell in a range then replace with the total of every

    Started by CharlieAziz‎, 12-01-2012 12:16 AM
    calculate, mulitple values, replace, return calculation, single cell 5 Attachment(s)
    • 11
    • 1,160
    CharlieAziz
    12-03-2012, 11:08 PM Go to last post

  35. Help creating math formula for sales analysis?

    Started by STrumbore‎, 12-03-2012 02:31 PM
    5 Attachment(s)
    • 11
    • 1,616
    STrumbore
    12-03-2012, 05:36 PM Go to last post

  36. Count whole numbers

    Started by ianhal82‎, 09-19-2013 09:13 AM
    3 Attachment(s)
    • 11
    • 1,720
    ianhal82
    09-20-2013, 06:12 AM Go to last post

  37. [SOLVED] SumIf not working here..

    Started by mhoot20‎, 09-25-2013 07:59 PM
    3 Attachment(s)
    • 11
    • 1,195
    kvsrinivasamurthy
    09-28-2013, 12:31 AM Go to last post

  38. [SOLVED] Formula to subtract duration from fixed time

    Started by TopDog0310‎, 09-19-2013 06:30 PM
    6 Attachment(s)
    • 11
    • 1,904
    Greg M
    09-22-2013, 04:19 PM Go to last post

  39. [SOLVED] Find next available smallest number in a range

    Started by Peter.M‎, 02-12-2016 06:25 AM
    • 11
    • 2,366
    Tony Valko
    02-16-2016, 06:09 AM Go to last post

  40. Unhappy Excel directory formula question?

    Started by schill2‎, 09-22-2013 10:11 AM
    directories, directory formula
    • 11
    • 1,095
    Tony Valko
    09-22-2013, 01:33 PM Go to last post

  41. [SOLVED] Returning matching keywords

    Started by sathishkm‎, 09-24-2013 02:43 PM
    5 Attachment(s)
    • 11
    • 635
    hemesh
    09-24-2013, 04:51 PM Go to last post

  42. Unique Values by month in date range

    Started by kerrynyc‎, 09-25-2013 10:47 AM
    3 Attachment(s)
    • 11
    • 1,129
    daffodil11
    09-25-2013, 04:53 PM Go to last post

  43. [SOLVED] SUMPRODUCT Based on two tables

    Started by NapB9‎, 09-25-2013 11:53 AM
    2 Attachment(s)
    • 11
    • 4,353
    AlKey
    09-25-2013, 04:06 PM Go to last post

  44. [SOLVED] Index/Match Error

    Started by pauldaddyadams‎, 09-27-2013 11:23 AM
    4 Attachment(s)
    • 11
    • 1,210
    pauldaddyadams
    09-28-2013, 07:41 AM Go to last post

  45. [SOLVED] how to link worksheet1 column to a dynamic named range list in a table in worksheet2

    Started by rny1ef‎, 08-18-2014 01:01 PM
    6 Attachment(s)
    • 11
    • 826
    rny1ef
    09-05-2014, 08:09 AM Go to last post

  46. [SOLVED] Getting data from multiple worksheets to a master sheet

    Started by SmoothRider‎, 08-25-2014 08:13 AM
    excel, master sheet, muliple tab. master, pull data automatically 2 Attachment(s)
    • 11
    • 888
    SmoothRider
    09-09-2014, 10:05 AM Go to last post

  47. Formula to calculate # of hours based on date range and employee ID code

    Started by r0man3‎, 09-02-2014 11:57 AM
    1 Attachment(s)
    • 11
    • 1,082
    Tony Valko
    09-02-2014, 08:04 PM Go to last post

  48. Extracting text from a string (Advance challenge)

    Started by Kayees‎, 09-05-2014 09:48 AM
    find, string
    • 11
    • 738
    AlKey
    09-05-2014, 11:16 AM Go to last post

  49. [SOLVED] Sum formula (Long)

    Started by concepo‎, 02-21-2016 08:04 AM
    2 Attachment(s)
    • 11
    • 902
    Tony Valko
    02-21-2016, 02:59 PM Go to last post

  50. Calculating dates

    Started by Toby0320‎, 07-06-2006 02:00 PM
    • 11
    • 773
    SteveG
    07-18-2006, 11:52 AM Go to last post
+ Post New Thread
Page 452 of 5619 FirstFirst ... 452 ...

Forum Information and Options

Users Browsing this Forum

There are currently 41 users browsing this forum. (0 members & 41 guests)

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