+ Post New Thread
Page 502 of 5614 FirstFirst ... 502 ...
Threads 25051 to 25100 of 280688

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. How do I separate the alpha prefix from a text (abc123 or a1234)?

    Started by kskaug1‎, 06-28-2006 12:00 PM
    • 1
    • 1,513
    CLR
    06-28-2006, 12:25 PM Go to last post

  2. [SOLVED] Formula to "Show me one of each value" from an array (only one condition)

    Started by Muzza68‎, 11-14-2012 11:40 PM
    5 Attachment(s)
    • 18
    • 1,513
    :) Sixthsense :)
    11-21-2012, 12:49 AM Go to last post

  3. Sorting data in a workbook across multple worksheets

    Started by Phil‎, 04-27-2005 06:06 PM
    • 18
    • 1,513
    Phil
    09-06-2005, 12:05 PM Go to last post

  4. Excel Formula to Extract Numbers (atleast the 1st 8 digits) from an Alpha-Numeric String

    Started by Vinod Krishna.C‎, 03-06-2014 12:54 PM
    extract numbers only, formula, vba 1 Attachment(s)
    • 14
    • 1,513
    martindwilson
    03-08-2014, 03:25 PM Go to last post

  5. Forumla for creating yearly event calendar

    Started by Sailing‎, 11-06-2008 09:10 PM
    calendar, dates formula 1 Attachment(s)
    • 0
    • 1,513
    Sailing
    11-06-2008, 09:10 PM Go to last post

  6. Calculating a Moving Average (Problem with blank cells)

    Started by JimmyOS‎, 04-19-2016 05:01 AM
    2 Attachment(s)
    • 6
    • 1,513
    kvsrinivasamurthy
    04-19-2016, 06:19 AM Go to last post

  7. Weighted Scatterplot Formula

    Started by rylock‎, 02-13-2013 03:27 PM
    scatterplot
    • 4
    • 1,512
    rylock
    02-13-2013, 06:01 PM Go to last post

  8. Smile #REF errors when refreshing Team Foundation (pivot-style) table and can't use INDIRECT()

    Started by Maelstrm‎, 01-02-2013 08:01 PM
    excel 2010, indirect(), ref#, team foundation server, tfs 3 Attachment(s)
    • 4
    • 1,512
    Maelstrm
    01-03-2013, 02:36 AM Go to last post

  9. Drop Down Menu list for multiple sheets

    Started by iamreese‎, 03-02-2012 10:27 AM
    • 5
    • 1,512
    NBVC
    03-02-2012, 11:10 AM Go to last post

  10. Exclamation Concatenate multiple cell values based on matching adjacent cells

    Started by mkrzy‎, 04-09-2013 11:38 PM
    2 Attachment(s)
    • 3
    • 1,512
    mkrzy
    04-10-2013, 02:40 AM Go to last post

  11. Index/Lookup formula

    Started by gemcounter‎, 11-13-2008 08:11 AM
    • 4
    • 1,512
    gemcounter
    11-13-2008, 09:50 AM Go to last post

  12. Match text in two different columns and provide corresponding value in third columns

    Started by Bobbie12‎, 04-12-2013 07:16 AM
    1 Attachment(s)
    • 4
    • 1,512
    Fotis1991
    04-12-2013, 09:52 AM Go to last post

  13. [SOLVED] Formula to Calculate Subtotal - Count of #'s Column While Avoiding Duplicates

    Started by swoosh1014‎, 09-26-2014 03:46 PM
    1 Attachment(s)
    • 17
    • 1,512
    Tony Valko
    10-30-2014, 10:09 AM Go to last post

  14. [SOLVED] Comparing 2 Excel spreadsheets to find missing records in one

    Started by calvr1ch‎, 02-06-2014 09:30 AM
    2 Attachment(s)
    • 5
    • 1,512
    alansidman
    02-06-2014, 06:37 PM Go to last post

  15. Formula to replace sumif?

    Started by kylpr‎, 12-12-2016 05:26 PM
    • 1
    • 1,512
    JohnTopley
    12-12-2016, 05:36 PM Go to last post

  16. [SOLVED] use replace to edit a formula with wildcards

    Started by db‎, 09-06-2005 02:05 AM
    • 55
    • 1,512
    koskyil
    09-06-2005, 05:05 PM Go to last post

  17. [SOLVED] Find next non blank cell in list and return value from adjacent column

    Started by kristy.brown‎, 05-17-2014 04:59 PM
    4 Attachment(s)
    • 6
    • 1,512
    oeldere
    05-19-2014, 03:28 PM Go to last post

  18. Formula Help

    Started by Bob Phillips‎, 09-06-2005 01:05 AM
    • 2
    • 1,512
    HeartMan
    09-06-2005, 07:05 AM Go to last post

  19. [SOLVED] Counting Unique text entries in a sheet with a condition

    Started by Bob Phillips‎, 09-06-2005 01:05 AM
    • 17
    • 1,512
    Mike
    10-04-2005, 07:05 AM Go to last post

  20. Range Changes with the Months

    Started by T De Villiers‎, 08-23-2005 09:36 AM
    • 44
    • 1,512
    Ian
    09-06-2005, 09:05 PM Go to last post

  21. [SOLVED] find row header based on table and column headers reverse lookup index & match

    Started by jnsorrera‎, 10-18-2020 01:53 AM
    excel, excel & formula 1 Attachment(s)
    • 3
    • 1,512
    Glenn Kennedy
    10-18-2020, 02:08 AM Go to last post

  22. Vlookup if more item has to be pulled

    Started by Tapyr‎, 11-01-2014 11:31 AM
    7 Attachment(s)
    • 9
    • 1,511
    Tapyr
    11-01-2014, 01:14 PM Go to last post

  23. [SOLVED] Lookup and Match UPC for 2 Different Vendors

    Started by kbmhc‎, 10-24-2019 06:18 PM
    3 Attachment(s)
    • 6
    • 1,511
    AliGW
    10-25-2019, 10:49 AM Go to last post

  24. [SOLVED] List the name of fruit

    Started by mai07‎, 04-04-2014 10:32 PM
    2 Attachment(s)
    • 1
    • 1,511
    azumi
    04-04-2014, 10:56 PM Go to last post

  25. Randomly select cells with text. (That are not Blank)

    Started by Ryder03‎, 05-19-2015 04:47 PM
    blank, ramdom, select, text 1 Attachment(s)
    • 8
    • 1,511
    [email protected]
    05-21-2015, 12:43 AM Go to last post

  26. Exclude cells in SUM if they are hidden?

    Started by horsefish01‎, 06-02-2015 02:26 PM
    1 Attachment(s)
    • 8
    • 1,511
    Tony Valko
    06-02-2015, 07:33 PM Go to last post

  27. [SOLVED] calc value totals of streak

    Started by pietf‎, 01-18-2016 10:38 AM
    3 Attachment(s)
    • 5
    • 1,511
    pietf
    01-20-2016, 03:02 AM Go to last post

  28. Urgent Help Required On : Calculation of net working hours

    Started by Upendra2016‎, 02-04-2016 09:39 AM
    2 Attachment(s)
    • 22
    • 1,511
    JeteMc
    04-22-2016, 10:36 AM Go to last post

  29. Index match with 2 variables

    Started by billyshears‎, 04-06-2016 04:36 PM
    1 Attachment(s)
    • 12
    • 1,511
    loginjmor
    04-06-2016, 06:08 PM Go to last post

  30. [SOLVED] Vlookup for partial text string match

    Started by mridul127‎, 04-26-2016 02:12 AM
    • 5
    • 1,511
    FDibbins
    04-28-2016, 12:49 AM Go to last post

  31. [SOLVED] subtract 3 calendar months from today's date

    Started by iracknback‎, 01-18-2017 03:00 PM
    • 4
    • 1,511
    Tony Valko
    01-18-2017, 04:12 PM Go to last post

  32. [SOLVED] Inability to Divide two sumifs

    Started by Prof Sick‎, 12-20-2017 11:13 AM
    1 Attachment(s)
    • 3
    • 1,511
    Prof Sick
    12-20-2017, 11:31 AM Go to last post

  33. [SOLVED] Extract and copy cell data to another cell if it matches criteria

    Started by volleyballtigger‎, 10-24-2017 10:02 AM
    2 Attachment(s)
    • 17
    • 1,511
    volleyballtigger
    10-24-2017, 12:55 PM Go to last post

  34. Display Title for a Match found in a table

    Started by tsatsos007‎, 11-29-2007 11:06 AM
    6 Attachment(s)
    • 19
    • 1,511
    EdMac
    12-05-2007, 11:22 AM Go to last post

  35. How do I compare two columns contents for differences

    Started by Denny‎, 01-05-2006 07:10 PM
    • 1
    • 1,511
    ScottO
    01-05-2006, 07:50 PM Go to last post

  36. [SOLVED] Standard sumif formula not recognised

    Started by Loan‎, 03-24-2005 01:07 AM
    • 3
    • 1,511
    Biff
    03-24-2005, 02:06 AM Go to last post

  37. Help with IF nesting! (Total of 10 IF's)

    Started by Thomaz‎, 04-03-2005 01:14 PM
    1 Attachment(s)
    • 15
    • 1,511
    Ron Coderre
    04-03-2005, 04:06 PM Go to last post

  38. How can I DISPLAY Filter Criteria

    Started by Debra Dalgleish‎, 09-06-2005 12:05 AM
    • 4
    • 1,511
    Scott Fendrich
    09-06-2005, 06:05 AM Go to last post

  39. Need to be done in 2 hours!!!! VLOOKUP returning #REF for unique I

    Started by Bob Phillips‎, 09-06-2005 02:05 AM
    • 50
    • 1,511
    Kay
    09-06-2005, 05:05 PM Go to last post

  40. [SOLVED] how can I search a field for a particular word

    Started by Biff‎, 09-06-2005 03:05 AM
    • 48
    • 1,511
    brantty
    09-06-2005, 07:05 PM Go to last post

  41. Apply a single formula on multiple cells

    Started by L.Weilong‎, 06-14-2007 02:44 PM
    • 2
    • 1,511
    L.Weilong
    06-14-2007, 10:52 PM Go to last post

  42. Talking Repeat formulas in a range of cells

    Started by Sandraoc1‎, 07-22-2007 05:11 PM
    • 1
    • 1,511
    Dean England
    07-22-2007, 05:18 PM Go to last post

  43. Question Count cells containing unique text in cell A if cell B equals i.e. 1

    Started by killi3000‎, 03-11-2014 06:56 AM
    count, unique entries 4 Attachment(s)
    • 8
    • 1,511
    killi3000
    03-14-2014, 09:32 AM Go to last post

  44. Question Return cell contents on a partial match

    Started by rhani111‎, 01-23-2008 10:26 PM
    2 Attachment(s)
    • 5
    • 1,511
    rhani111
    02-04-2008, 12:13 AM Go to last post

  45. Match/index/iserror

    Started by gmcana‎, 03-14-2008 03:54 AM
    1 Attachment(s)
    • 8
    • 1,511
    arthurbr
    03-14-2008, 08:52 AM Go to last post

  46. convert cell contents to individual cells?

    Started by CATALES29‎, 02-03-2011 05:47 PM
    • 2
    • 1,511
    nimrod
    02-05-2011, 10:18 PM Go to last post

  47. Calculate SLA due date on different items when another factor makes a difference

    Started by snappytim‎, 01-03-2013 05:46 AM
    3 Attachment(s)
    • 7
    • 1,511
    Fotis1991
    01-04-2013, 10:34 AM Go to last post

  48. [SOLVED] IF function that searches one column and lists the results in a paragraph

    Started by utahmoose‎, 10-16-2013 01:45 PM
    • 18
    • 1,511
    Pete_UK
    10-18-2013, 05:29 AM Go to last post

  49. Conditional Formula Requested

    Started by Napalm13‎, 12-27-2013 08:16 AM
    6 Attachment(s)
    • 27
    • 1,511
    rajeshturaha
    12-31-2013, 12:42 AM Go to last post

  50. Remove #N/A if index(match Value

    Started by hkbhansali‎, 03-09-2014 06:35 AM
    • 5
    • 1,511
    Tony Valko
    03-09-2014, 10:31 AM Go to last post
+ Post New Thread
Page 502 of 5614 FirstFirst ... 502 ...

Forum Information and Options

Users Browsing this Forum

There are currently 50 users browsing this forum. (1 members & 49 guests)

  1. JN831

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