+ Post New Thread
Page 501 of 5613 FirstFirst ... 501 ...
Threads 25001 to 25050 of 280642

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

  1. Use a formula to find a Number in a table and then obtain its Row name

    Started by Miricleman‎, 05-04-2017 08:32 PM
    2 Attachment(s)
    • 10
    • 492
    JeteMc
    05-10-2017, 02:13 PM Go to last post

  2. [SOLVED] conditional sum across worksheet pages

    Started by philubuster‎, 07-06-2015 12:16 PM
    indirect, sumif and condition, sumproduct, sumproduct across sheets 2 Attachment(s)
    • 10
    • 1,223
    philubuster
    07-06-2015, 04:03 PM Go to last post

  3. [SOLVED] Counting totals between dates and product

    Started by erik_t_viking‎, 04-10-2017 06:47 AM
    2 Attachment(s)
    • 10
    • 418
    JohnTopley
    04-10-2017, 09:03 AM Go to last post

  4. [SOLVED] use a vlookup value in a table

    Started by SageAdvisor‎, 04-08-2017 05:40 AM
    1 Attachment(s)
    • 10
    • 408
    JohnTopley
    04-09-2017, 09:31 AM Go to last post

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

  6. [SOLVED] Search returns column header or error if value not found

    Started by leovfx‎, 04-29-2017 08:31 AM
    1 Attachment(s)
    • 10
    • 715
    leovfx
    04-30-2017, 04:25 PM Go to last post

  7. [SOLVED] Need blank cell to = 0 for AVG function

    Started by thebutlerdidit‎, 04-21-2017 02:21 PM
    • 10
    • 357
    TMS
    04-21-2017, 04:26 PM Go to last post

  8. [SOLVED] Formula to indicate if row in Col B is empty with data in same row Col A

    Started by c.bernardo‎, 04-22-2017 10:24 AM
    array formula, excel, index & match 2 Attachment(s)
    • 10
    • 625
    JohnTopley
    04-22-2017, 02:52 PM Go to last post

  9. Question [SOLVED] Hlookup + Vlookup

    Started by Solvax‎, 04-26-2017 04:52 AM
    4 Attachment(s)
    • 10
    • 458
    Pete_UK
    05-07-2017, 07:26 PM Go to last post

  10. IF statement: 3 options

    Started by dtb419‎, 04-27-2017 10:03 AM
    3 options 1 Attachment(s)
    • 10
    • 1,475
    dtb419
    04-27-2017, 10:53 AM Go to last post

  11. [SOLVED] sum and transfer corrsponding data from sheet to other according to product name

    Started by mazan2010‎, 04-28-2017 05:39 AM
    4 Attachment(s)
    • 10
    • 380
    mazan2010
    04-28-2017, 11:37 AM Go to last post

  12. [SOLVED] Nested If/And Functions

    Started by markhooten‎, 05-01-2017 12:08 PM
    • 10
    • 677
    Raven19528
    05-03-2017, 08:32 PM Go to last post

  13. [SOLVED] Advanced filter not showing unique records.

    Started by bubai‎, 07-05-2015 02:16 AM
    3 Attachment(s)
    • 10
    • 1,230
    FlameRetired
    07-06-2015, 02:34 AM Go to last post

  14. Unhappy Report Cell Formatting and Formula

    Started by PistolPete7‎, 05-06-2017 12:03 AM
    2 Attachment(s)
    • 10
    • 412
    leelnich
    05-06-2017, 03:36 AM Go to last post

  15. Multiplying numbers

    Started by mikkelno‎, 05-10-2017 08:09 AM
    2 Attachment(s)
    • 10
    • 476
    mikkelno
    05-10-2017, 09:43 AM Go to last post

  16. [SOLVED] Show the next 1st/15th of the month with a 2-day gap

    Started by doublebellybuster‎, 05-18-2020 06:36 PM
    • 10
    • 408
    xladept
    05-19-2020, 06:58 PM Go to last post

  17. Auto-Highlight Rows & Columns that Include a Specific Value

    Started by GirvanShirman‎, 05-05-2020 09:21 AM
    7 Attachment(s)
    • 10
    • 834
    JeteMc
    05-28-2020, 04:17 PM Go to last post

  18. Show total spending for current month

    Started by pulkitsh‎, 05-01-2020 01:18 PM
    3 Attachment(s)
    • 10
    • 351
    oeldere
    05-05-2020, 02:17 PM Go to last post

  19. [SOLVED] Count consecutive abbreviations in a column

    Started by Berna11‎, 05-05-2020 03:25 PM
    4 Attachment(s)
    • 10
    • 402
    Limor_OP
    05-06-2020, 05:46 PM Go to last post

  20. Question [SOLVED] Extract IP Address from heavily populated cell

    Started by reem01‎, 05-06-2020 12:01 PM
    1 Attachment(s)
    • 10
    • 540
    Bo_Ry
    05-06-2020, 02:23 PM Go to last post

  21. Highlight cells based on value of 1 other cell

    Started by tomdegezelle‎, 05-08-2020 11:02 PM
    3 Attachment(s)
    • 10
    • 524
    JeteMc
    05-11-2020, 12:33 PM Go to last post

  22. [SOLVED] IF with multiple conditions

    Started by purlo‎, 05-13-2020 07:49 AM
    5 Attachment(s)
    • 10
    • 346
    Czeslaw
    05-14-2020, 01:44 PM Go to last post

  23. Question IF statements...If something is greater than X, less than Y.

    Started by DwyerJames‎, 05-18-2020 12:38 PM
    accounting, ifstatement, ifstatements, tax calculation, tax formula 1 Attachment(s)
    • 10
    • 1,046
    MrShorty
    05-18-2020, 03:50 PM Go to last post

  24. I'm not sure what to call this thread. Search and return data?

    Started by nineonline‎, 05-20-2020 08:57 AM
    2 Attachment(s)
    • 10
    • 352
    nineonline
    05-21-2020, 12:12 PM Go to last post

  25. [SOLVED] How to find subtotals in variable positions.

    Started by j_Southern‎, 05-24-2020 09:40 AM
    2 Attachment(s)
    • 10
    • 284
    oeldere
    05-25-2020, 01:54 AM Go to last post

  26. Excel: Sheet name from tab automically into a cell

    Started by David Billigmeier‎, 09-06-2005 01:05 AM
    • 10
    • 620
    SWalton
    09-06-2005, 07:05 AM Go to last post

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

  28. Shortcut keys assigned to macros/functions in excel

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

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

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

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

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

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

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

  34. Elapsed time in days

    Started by Bernie Deitrick‎, 09-06-2005 01:05 AM
    • 10
    • 502
    Steve M via OfficeKB.com
    09-06-2005, 07:05 AM Go to last post

  35. [SOLVED] sort dates

    Started by Bob Phillips‎, 09-06-2005 01:05 AM
    • 10
    • 653
    Debgala
    09-06-2005, 07:05 AM Go to last post

  36. [SOLVED] Upper case

    Started by Bob Phillips‎, 09-06-2005 01:05 AM
    • 10
    • 547
    Beginner2005
    09-06-2005, 07:05 AM Go to last post

  37. ADDING TIMES

    Started by Bob Phillips‎, 09-06-2005 01:05 AM
    • 10
    • 585
    John C. Harris, MPA
    09-06-2005, 07:05 AM Go to last post

  38. [SOLVED] can a single cell contain multiple numbers?

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

  39. [SOLVED] remove specific character from column

    Started by gondal‎, 07-04-2015 01:31 PM
    1 Attachment(s)
    • 10
    • 791
    gondal
    07-04-2015, 01:55 PM Go to last post

  40. employee retirement plan

    Started by gomumy97‎, 10-27-2007 06:27 PM
    1 Attachment(s)
    • 10
    • 1,318
    gomumy97
    10-28-2007, 05:28 PM Go to last post

  41. Excel 2007 : SUMIF with 2 criteria

    Started by pansovic‎, 08-30-2010 06:58 PM
    2 Attachment(s)
    • 10
    • 31,782
    Nono Lara
    04-21-2013, 05:42 PM Go to last post

  42. [SOLVED] how to learn Array Formulas...

    Started by vishnu01445‎, 08-22-2012 12:36 AM
    • 10
    • 753
    MarvinP
    08-22-2012, 11:11 AM Go to last post

  43. [SOLVED] Looking for more efficient method of dividing actual spends

    Started by anemptyroad‎, 04-15-2013 07:49 PM
    2 Attachment(s)
    • 10
    • 717
    anemptyroad
    04-19-2013, 12:42 PM Go to last post

  44. Formula for Calculating Total Time

    Started by cherilannc‎, 04-18-2013 11:45 AM
    4 Attachment(s)
    • 10
    • 1,668
    cherilannc
    04-22-2013, 10:42 AM Go to last post

  45. [SOLVED] Trying to Use ("") to Result in #VALUE Error Cells turning Blank

    Started by jordan1214‎, 04-23-2013 12:57 AM
    • 10
    • 672
    :) Sixthsense :)
    04-23-2013, 01:39 AM Go to last post

  46. [SOLVED] Index Match with lookup values containing letters, numbers and spaces

    Started by makinwaves‎, 03-18-2014 06:34 PM
    • 10
    • 8,376
    TMS
    03-18-2014, 08:06 PM Go to last post

  47. [SOLVED] Need Some Help Guys..Want to find max value and some values above and below it

    Started by Haidar123‎, 03-21-2014 07:45 AM
    1 Attachment(s)
    • 10
    • 520
    AZ-XL
    03-21-2014, 01:40 PM Go to last post

  48. Need Help with a "Matching" Function

    Started by boogyman00123‎, 03-22-2014 08:26 AM
    1 Attachment(s)
    • 10
    • 594
    Tony Valko
    03-24-2014, 02:34 PM Go to last post

  49. Generate Random Time Series using RANDBETWEEN, but NOT with RANDBETWEEN in Each Cell

    Started by LineOfBestFit‎, 07-02-2015 09:47 AM
    1 Attachment(s)
    • 10
    • 6,257
    shg
    07-03-2015, 04:29 PM Go to last post

  50. vlookup in if

    Started by Alec Green‎, 02-22-2006 03:00 PM
    • 10
    • 492
    Pete_UK
    02-22-2006, 04:40 PM Go to last post
+ Post New Thread
Page 501 of 5613 FirstFirst ... 501 ...

Forum Information and Options

Users Browsing this Forum

There are currently 100 users browsing this forum. (10 members & 90 guests)

  1. 9411john,
  2. AliGW,
  3. Colin Legg,
  4. Danilo Flaiban,
  5. finallymint,
  6. JohnTopley,
  7. krishnapg,
  8. weishida

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