+ Post New Thread
Page 100 of 5614 FirstFirst ... 100 ...
Threads 4951 to 5000 of 280683

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. get earliest Date-time and Latest Date-time based on 2 criterias (first & last name)

    Started by ag273n‎, 08-31-2014 02:31 AM
    4 Attachment(s)
    • 3
    • 1,345
    Vikas_Gautam
    08-31-2014, 06:39 AM Go to last post

  2. get data from web

    Started by ag273n‎, 12-29-2013 04:46 PM
    • 0
    • 424
    ag273n
    12-29-2013, 04:46 PM Go to last post

  3. [SOLVED] Incorrect returns from If statement (Identifying Gaps in Time)

    Started by ag4431‎, 07-27-2017 11:38 AM
    2 Attachment(s)
    • 9
    • 542
    AliGW
    07-27-2017, 12:51 PM Go to last post

  4. Count if date is more than 30 days ago and cell matches criteria

    Started by AG52014‎, 02-02-2016 05:23 PM
    • 2
    • 1,022
    JeteMc
    02-04-2016, 10:37 AM Go to last post

  5. Highlight first white column in row if another cell is within so many days

    Started by AG52014‎, 01-29-2020 04:42 AM
    1 Attachment(s)
    • 4
    • 231
    Pepe Le Mokko
    01-30-2020, 03:45 AM Go to last post

  6. [SOLVED] Select the last word from the cell

    Started by AGA‎, 04-25-2017 10:21 AM
    1 Attachment(s)
    • 4
    • 613
    alansidman
    04-25-2017, 10:51 AM Go to last post

  7. [SOLVED] Calculate number of times a birthday falls between start and end date

    Started by AGA2020‎, 01-06-2020 09:41 PM
    • 6
    • 309
    AGA2020
    01-06-2020, 10:52 PM Go to last post

  8. Summing Groups of Information

    Started by agababian‎, 08-02-2013 02:02 PM
    • 1
    • 458
    Craig K.
    08-02-2013, 02:27 PM Go to last post

  9. [SOLVED] Looking for a function that do a sum look up across multiple sheets

    Started by agabah93‎, 11-20-2022 03:46 PM
    3 Attachment(s)
    • 4
    • 317
    agabah93
    11-20-2022, 07:37 PM Go to last post

  10. Average of numbers, not including 0, and only for the last 12 if there are more than 12...

    Started by AGACHEJM‎, 07-02-2013 09:23 AM
    average forumula, excel
    • 2
    • 714
    AndyLitch
    07-02-2013, 10:02 AM Go to last post

  11. Finding a specific value based on vertical & horizontal criterias

    Started by agadge123‎, 04-08-2016 11:56 AM
    1 Attachment(s)
    • 7
    • 715
    Hercules1946
    04-08-2016, 03:40 PM Go to last post

  12. Macro security issue - unable to save as macro enabled sheet

    Started by agadge123‎, 05-31-2016 10:42 AM
    3 Attachment(s)
    • 8
    • 807
    shg
    05-31-2016, 12:36 PM Go to last post

  13. extract only cells with data from a specific row in a 2D range and return it as an array

    Started by agadir‎, 12-01-2021 02:37 PM
    arrays containing text, index & match, subset of data 1 Attachment(s)
    • 1
    • 258
    6StringJazzer
    12-01-2021, 04:04 PM Go to last post

  14. VLOOKUP OR PROCV - problem

    Started by agafur‎, 02-19-2020 08:58 AM
    1 Attachment(s)
    • 2
    • 261
    AliGW
    02-19-2020, 09:02 AM Go to last post

  15. [SOLVED] offset a vlookup

    Started by agalinauskas‎, 07-23-2012 03:07 PM
    4 Attachment(s)
    • 19
    • 1,148
    Cutter
    07-24-2012, 06:38 PM Go to last post

  16. sum if conditions in two columns are met?

    Started by Agallagher‎, 04-03-2006 08:10 PM
    • 4
    • 1,300
    Biff
    04-04-2006, 02:20 PM Go to last post

  17. Filter one column with contains filter using a column from a different sheet

    Started by agalloch‎, 06-26-2013 05:35 PM
    • 1
    • 416
    agalloch
    06-27-2013, 01:53 PM Go to last post

  18. [SOLVED] Sum Across Multiple Rows on Multiple Criteria

    Started by agalvan‎, 05-18-2016 10:33 AM
    • 3
    • 567
    Tony Valko
    05-18-2016, 11:02 AM Go to last post

  19. Question Count and sums over specific time

    Started by Agame‎, 04-03-2018 10:09 AM
    occurence, sum and if's, total 3 Attachment(s)
    • 3
    • 490
    tim201110
    04-03-2018, 11:56 AM Go to last post

  20. Exclamation Help IF AND Conditional Statement

    Started by agamino‎, 08-13-2013 01:46 PM
    1 Attachment(s)
    • 22
    • 2,049
    DasGypsy
    08-13-2013, 06:50 PM Go to last post

  21. Exclamation [SOLVED] Transpose- Rows to column

    Started by aganesan99‎, 02-02-2015 09:14 AM
    transpose, transpose row to column 1 Attachment(s)
    • 4
    • 637
    Jonmo1
    02-02-2015, 10:15 AM Go to last post

  22. Exclamation [SOLVED] Serial Numbers for different categories

    Started by aganesan99‎, 01-19-2015 03:23 AM
    serial number 1 Attachment(s)
    • 3
    • 671
    aganesan99
    01-19-2015, 04:47 AM Go to last post

  23. Exclamation [SOLVED] Minimum value in all items

    Started by aganesan99‎, 01-27-2015 09:04 AM
    min value, min with criteria 1 Attachment(s)
    • 4
    • 430
    aganesan99
    01-27-2015, 10:05 AM Go to last post

  24. Serial numbers

    Started by aganesan99‎, 02-04-2015 09:50 AM
    2 Attachment(s)
    • 2
    • 461
    aganesan99
    02-04-2015, 10:29 AM Go to last post

  25. Exclamation [SOLVED] To check whether the hours is greater than 24 hours or not

    Started by aganesan99‎, 12-22-2014 08:59 AM
    date and time, hours and minutes
    • 3
    • 698
    Jonmo1
    12-22-2014, 09:37 AM Go to last post

  26. [SOLVED] Add hour to star date&time

    Started by aganesan99‎, 11-27-2014 07:49 AM
    date & time calculation, formula and functions 1 Attachment(s)
    • 5
    • 650
    aganesan99
    12-04-2014, 03:39 AM Go to last post

  27. [SOLVED] Date format using formula

    Started by aganesan99‎, 11-13-2014 09:38 AM
    date format
    • 6
    • 570
    aganesan99
    11-13-2014, 10:17 AM Go to last post

  28. Date and time excluding sat & sun

    Started by aganesan99‎, 12-15-2014 12:01 AM
    2 Attachment(s)
    • 2
    • 435
    aganesan99
    12-15-2014, 10:35 AM Go to last post

  29. Exclamation [SOLVED] Find & Replace using formula

    Started by aganesan99‎, 11-11-2014 03:18 AM
    find & replace
    • 6
    • 575
    kvsrinivasamurthy
    11-11-2014, 05:48 AM Go to last post

  30. [SOLVED] MATCH formula

    Started by aganesan99‎, 11-25-2013 11:02 AM
    2 Attachment(s)
    • 8
    • 582
    arlu1201
    11-25-2013, 01:48 PM Go to last post

  31. Exclamation separating text and numbers in cells in the same order

    Started by aganesan99‎, 09-09-2015 08:18 AM
    2 Attachment(s)
    • 2
    • 328
    aganesan99
    09-09-2015, 08:38 AM Go to last post

  32. Out of Stock Date

    Started by agapitor1975‎, 08-14-2020 02:19 PM
    2 Attachment(s)
    • 3
    • 225
    etaf
    08-14-2020, 02:35 PM Go to last post

  33. Formula that inputs specific text in a cell, based on what number is in the adjacent cell

    Started by agarford‎, 11-17-2018 12:57 PM
    • 5
    • 769
    AliGW
    11-19-2018, 01:52 AM Go to last post

  34. VLOOKUP / PIVOT Tables

    Started by agarford‎, 04-04-2013 03:42 PM
    1 Attachment(s)
    • 1
    • 416
    popipipo
    04-04-2013, 03:53 PM Go to last post

  35. VLOOKUP / IF formula - HELP!

    Started by agarford‎, 03-18-2013 06:17 PM
    15 Attachment(s)
    • 21
    • 2,059
    Fett2oo5
    04-29-2013, 12:57 PM Go to last post

  36. Finding the date on the 'nth' Monday in this Month in this Year

    Started by agarwaldvk‎, 04-17-2006 05:30 PM
    • 1
    • 1,771
    Peo Sjoblom
    04-17-2006, 05:55 PM Go to last post

  37. Count of pairs of cells with diffenent corresponding values in 2 datasets

    Started by agarwaldvk‎, 01-17-2008 12:12 AM
    • 2
    • 695
    agarwaldvk
    01-20-2008, 11:15 PM Go to last post

  38. Conditional sum for multiple criteria!

    Started by agarwaldvk‎, 04-30-2007 05:28 PM
    • 1
    • 654
    redstang423
    05-01-2007, 12:40 AM Go to last post

  39. Something similar to sum() but ignoring error value arguments!

    Started by agarwaldvk‎, 07-04-2005 09:32 PM
    • 55
    • 3,265
    Aladin Akyurek
    09-06-2005, 03:05 PM Go to last post

  40. Free GMail Invites!

    Started by agarwaldvk‎, 02-22-2005 11:57 PM
    • 0
    • 685
    agarwaldvk
    02-22-2005, 11:57 PM Go to last post

  41. How to return multiple column array without using Offset function?

    Started by agarwaldvk‎, 05-26-2008 07:19 PM
    • 7
    • 6,298
    agarwaldvk
    05-27-2008, 04:20 AM Go to last post

  42. Can this be done using Sumproduct?

    Started by agarwaldvk‎, 04-30-2006 05:55 PM
    • 1
    • 633
    daddylonglegs
    04-30-2006, 07:20 PM Go to last post

  43. excel tiered pricing and cumulative summary

    Started by agasio‎, 11-12-2017 12:02 PM
    • 2
    • 769
    agasio
    11-13-2017, 04:39 AM Go to last post

  44. [SOLVED] A sum product with multiple criteria / Urgent problem

    Started by Agata1111‎, 02-22-2023 07:58 AM
    3 Attachment(s)
    • 7
    • 239
    popipipo
    02-22-2023, 09:58 AM Go to last post

  45. How to use complex no. functions that have cell references?

    Started by agathon‎, 09-06-2005 03:05 AM
    • 0
    • 370
    agathon
    09-06-2005, 03:05 AM Go to last post

  46. [SOLVED] How to use complex no. functions that have cell references?

    Started by agathon‎, 09-06-2005 02:05 AM
    • 0
    • 392
    agathon
    09-06-2005, 02:05 AM Go to last post

  47. [SOLVED] How to use complex no. functions that have cell references?

    Started by agathon‎, 09-06-2005 01:05 AM
    • 0
    • 436
    agathon
    09-06-2005, 01:05 AM Go to last post

  48. How to use complex no. functions that have cell references?

    Started by agathon‎, 09-06-2005 12:05 AM
    • 0
    • 443
    agathon
    09-06-2005, 12:05 AM Go to last post

  49. [SOLVED] How to use complex no. functions that have cell references?

    Started by agathon‎, 09-05-2005 11:05 PM
    • 0
    • 374
    agathon
    09-05-2005, 11:05 PM Go to last post

  50. How to use complex no. functions that have cell references?

    Started by agathon‎, 06-16-2005 08:05 PM
    • 2
    • 434
    JE McGimpsey
    06-16-2005, 09:05 PM Go to last post
+ Post New Thread
Page 100 of 5614 FirstFirst ... 100 ...

Forum Information and Options

Users Browsing this Forum

There are currently 42 users browsing this forum. (3 members & 39 guests)

  1. HansDouwe,
  2. shukla.ankur281190,
  3. Unni97

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