+ Post New Thread
Page 101 of 5614 FirstFirst ... 101 ...
Threads 5001 to 5050 of 280679

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

  1. Split text into columns - formula only, no vba or excel Text to Columns

    Started by CRJ42‎, 02-15-2022 06:22 PM
    1 Attachment(s)
    • 19
    • 646
    CRJ42
    02-17-2022, 04:51 PM Go to last post

  2. Using a named range in Sumproduct

    Started by ddrace‎, 12-29-2016 04:20 PM
    1 Attachment(s)
    • 19
    • 6,798
    Tony Valko
    12-30-2016, 01:24 PM Go to last post

  3. [SOLVED] Help with Conditional Formatting and Formula to put info on another page

    Started by Lowen‎, 07-13-2015 05:35 PM
    17 Attachment(s)
    • 19
    • 1,335
    JeteMc
    07-17-2015, 10:15 AM Go to last post

  4. Need help with an IF Average formula

    Started by kwoltman‎, 07-20-2015 03:54 PM
    1 Attachment(s)
    • 19
    • 1,090
    bhenlee
    07-20-2015, 05:52 PM Go to last post

  5. [SOLVED] Letter Pull

    Started by makinmomb‎, 11-18-2016 06:36 AM
    2 Attachment(s)
    • 19
    • 1,113
    Glenn Kennedy
    11-18-2016, 12:12 PM Go to last post

  6. Question [SOLVED] Help With A Formula To Calculate Only Filtered Data?

    Started by artiststevens‎, 12-26-2016 03:24 AM
    8 Attachment(s)
    • 19
    • 3,987
    JohnTopley
    01-20-2017, 09:10 AM Go to last post

  7. [SOLVED] Help with multiple COUNIFS & SUMIFS

    Started by scott79‎, 11-24-2016 11:41 AM
    4 Attachment(s)
    • 19
    • 966
    José Augusto
    11-29-2016, 04:23 PM Go to last post

  8. [SOLVED] Combine AND & OR formulae

    Started by Supersadie‎, 05-01-2018 06:24 AM
    3 Attachment(s)
    • 19
    • 684
    FDibbins
    05-06-2018, 04:41 PM Go to last post

  9. [SOLVED] How to count *backwards* the number of blank cells until a number reached

    Started by lamlam28‎, 05-04-2018 04:40 AM
    3 Attachment(s)
    • 19
    • 7,827
    lamlam28
    05-06-2018, 11:34 PM Go to last post

  10. [SOLVED] Color Coded Countdown Dynamic Due Dates

    Started by onmytenthlife‎, 05-11-2018 11:16 PM
    color code, color coded, due date, due date alert 2 Attachment(s)
    • 19
    • 2,203
    JohnTopley
    05-13-2018, 10:09 AM Go to last post

  11. Look up that pulls all requested data, not just one cell.

    Started by ZEROCOOL UK‎, 05-16-2018 10:59 AM
    5 Attachment(s)
    • 19
    • 562
    Sam Capricci
    05-17-2018, 11:45 AM Go to last post

  12. Post Total absences per day

    Started by onelifestyle‎, 06-04-2018 10:16 AM
    5 Attachment(s)
    • 19
    • 651
    FDibbins
    06-04-2018, 06:19 PM Go to last post

  13. Shift Pattern Dropdown List and auto populate calendar

    Started by missja‎, 04-15-2022 05:15 AM
    autopopulate, dropdownlist, shiftpattern 10 Attachment(s)
    • 19
    • 954
    missja
    05-09-2022, 01:42 AM Go to last post

  14. How to return unique values using COUNTIFS ?

    Started by ccarmichael‎, 05-20-2015 01:53 PM
    1 Attachment(s)
    • 19
    • 1,470
    jhren
    06-04-2015, 03:36 PM Go to last post

  15. [SOLVED] Xlookup when both the lookup value and lookup array are separated by commas

    Started by Eades1412‎, 02-07-2022 03:05 AM
    4 Attachment(s)
    • 19
    • 501
    AliGW
    02-08-2022, 04:49 AM Go to last post

  16. Transposing Complex Data into Usable Format

    Started by craigc0187‎, 03-20-2022 03:42 PM
    formula, transpose array, transpose row to column 7 Attachment(s)
    • 19
    • 611
    craigc0187
    03-21-2022, 07:15 AM Go to last post

  17. [SOLVED] Calendar to display work days off for holidays that actually fall onto weekends

    Started by chrisneu‎, 12-15-2021 07:25 PM
    7 Attachment(s)
    • 19
    • 560
    6StringJazzer
    12-18-2021, 09:03 PM Go to last post

  18. [SOLVED] Extracting text from a string

    Started by H1ghway‎, 01-21-2022 09:53 AM
    left, right trim, string 1 Attachment(s)
    • 19
    • 422
    TMS
    01-21-2022, 12:10 PM Go to last post

  19. [SOLVED] Date Range, Return Text, Formula VLookup #Spill! Error

    Started by CHillFL‎, 01-27-2022 11:40 AM
    1 Attachment(s)
    • 19
    • 329
    Fluff13
    01-27-2022, 05:05 PM Go to last post

  20. [SOLVED] Trying to look up and filter data

    Started by kingr13‎, 02-14-2022 12:34 PM
    9 Attachment(s)
    • 19
    • 449
    JeteMc
    02-17-2022, 03:08 PM Go to last post

  21. [SOLVED] Get the final date free after blockout

    Started by alferd324‎, 03-24-2022 05:16 AM
    4 Attachment(s)
    • 19
    • 318
    alferd324
    03-24-2022, 10:38 PM Go to last post

  22. complex formula to filter data from one particular column

    Started by minszki‎, 03-16-2022 09:02 AM
    5 Attachment(s)
    • 19
    • 338
    Gregb11
    03-17-2022, 06:57 AM Go to last post

  23. Perform Double IF , if True plug Y

    Started by makinmomb‎, 03-22-2022 04:53 AM
    7 Attachment(s)
    • 19
    • 510
    makinmomb
    03-27-2022, 01:36 AM Go to last post

  24. How to count empty cells?

    Started by Delta_Fox‎, 05-13-2022 11:24 AM
    1 Attachment(s)
    • 19
    • 380
    Delta_Fox
    05-13-2022, 04:25 PM Go to last post

  25. Talking [SOLVED] Table that reports the percentage of Y or blanks in a column

    Started by AdamisStuck‎, 06-20-2022 04:40 AM
    2 Attachment(s)
    • 19
    • 244
    oeldere
    06-20-2022, 09:25 AM Go to last post

  26. concatenate

    Started by shyam sundar‎, 01-25-2013 05:10 AM
    • 19
    • 1,158
    Andrew-R
    01-25-2013, 07:10 AM Go to last post

  27. Averaging noncontiguous numbers ignoring zeros?

    Started by Mike‎, 03-03-2005 07:06 PM
    • 19
    • 4,080
    Myrna Larson
    03-03-2005, 11:06 PM Go to last post

  28. [SOLVED] Dates

    Started by Mangesh Yadav‎, 09-06-2005 01:05 AM
    • 19
    • 1,025
    Natalie
    09-06-2005, 11:05 AM Go to last post

  29. Ability for Excel to find and replace graphic objects (like Word)

    Started by Anne Troy‎, 09-06-2005 02:05 AM
    • 19
    • 857
    Marjan S
    09-06-2005, 05:05 PM Go to last post

  30. [SOLVED] If statements with validation lists

    Started by Bernie Deitrick‎, 09-06-2005 12:05 PM
    • 19
    • 737
    Tony Houston
    09-07-2005, 12:05 AM Go to last post

  31. [SOLVED] Cell Separation

    Started by CLR‎, 09-06-2005 12:05 PM
    • 19
    • 828
    Freshman
    09-06-2005, 11:05 PM Go to last post

  32. [SOLVED] WHAT IF/IF Statement, multiply by &

    Started by Ianseconds‎, 12-11-2012 03:48 PM
    3 Attachment(s)
    • 19
    • 1,024
    JieJenn
    12-11-2012, 06:29 PM Go to last post

  33. [SOLVED] Deducting Lunch from Timecard

    Started by TankGirlCCSU‎, 12-15-2012 05:24 PM
    4 Attachment(s)
    • 19
    • 1,458
    Grimace
    01-07-2013, 07:45 PM Go to last post

  34. [SOLVED] String search always returns False value in results

    Started by coachd‎, 12-24-2012 03:54 PM
    1 Attachment(s)
    • 19
    • 1,172
    coachd
    12-24-2012, 05:03 PM Go to last post

  35. #VALUE! appears everytime I try to use a formula on an excel file copied from the internet

    Started by rgrstvr‎, 01-02-2013 10:11 PM
    4 Attachment(s)
    • 19
    • 1,578
    oeldere
    01-05-2013, 06:14 AM Go to last post

  36. Criteria based count values - Formual Modification!

    Started by [email protected]‎, 01-11-2013 10:36 AM
    6 Attachment(s)
    • 19
    • 1,033
    [email protected]
    01-19-2013, 04:27 AM Go to last post

  37. Angry [SOLVED] Enter a value to change other cell values to match that throughout multiple worksheets

    Started by swiftworks‎, 01-14-2013 03:07 PM
    changing multiple values, conditional formatting, search 7 Attachment(s)
    • 19
    • 1,445
    dredwolf
    01-14-2013, 05:30 PM Go to last post

  38. Conditional Formula with Text

    Started by pebkac‎, 01-17-2013 10:48 AM
    1 Attachment(s)
    • 19
    • 1,128
    pebkac
    01-17-2013, 02:38 PM Go to last post

  39. Min of two sums if greater than one cell - help please

    Started by griffithsmaria‎, 05-22-2015 02:38 PM
    3 Attachment(s)
    • 19
    • 970
    griffithsmaria
    05-26-2015, 08:03 AM Go to last post

  40. [SOLVED] running total problem

    Started by loopiloo‎, 06-08-2013 11:19 AM
    7 Attachment(s)
    • 19
    • 1,386
    loopiloo
    06-10-2013, 12:01 PM Go to last post

  41. Too many nest ifs

    Started by s4shibly‎, 06-17-2013 08:53 AM
    3 Attachment(s)
    • 19
    • 1,428
    s4shibly
    06-23-2013, 01:12 AM Go to last post

  42. [SOLVED] Formula needed to extract numbers from alpha numerical entry please

    Started by Twaddy006‎, 01-08-2014 04:36 PM
    1 Attachment(s)
    • 19
    • 1,439
    Twaddy006
    01-14-2014, 05:26 PM Go to last post

  43. Excel average help

    Started by cap_investing‎, 01-13-2014 12:26 PM
    4 Attachment(s)
    • 19
    • 1,261
    bebo021999
    01-13-2014, 08:35 PM Go to last post

  44. Exclamation [SOLVED] Formula Regarding 3 Functions - Need Help!

    Started by HMMzz‎, 12-15-2013 03:52 PM
    • 19
    • 1,340
    6StringJazzer
    01-04-2014, 09:06 PM Go to last post

  45. IF statement

    Started by Sureshji‎, 12-17-2013 06:06 PM
    3 Attachment(s)
    • 19
    • 1,598
    Sureshji
    12-21-2013, 08:27 PM Go to last post

  46. VLOOKUP to find multiple occurences

    Started by valhallaone‎, 12-18-2013 08:51 PM
    6 Attachment(s)
    • 19
    • 1,936
    Trimdaddy
    12-20-2013, 02:55 PM Go to last post

  47. Question Guest Stay Dates Calculator

    Started by cdeguzman‎, 01-15-2014 04:49 PM
    guest, hotel, monthly, nights, stay 6 Attachment(s)
    • 19
    • 1,739
    p24leclerc
    01-24-2014, 12:46 PM Go to last post

  48. Question [SOLVED] CountBlank for "Adaptive" Range

    Started by DavidMichaelangelo‎, 01-20-2014 12:13 PM
    adaptive range, changing range, countblank, ignore cells 1 Attachment(s)
    • 19
    • 1,434
    Tony Valko
    01-23-2014, 10:35 AM Go to last post

  49. counting unique values with multiple criteria

    Started by freil‎, 11-30-2016 10:10 AM
    11 Attachment(s)
    • 19
    • 1,127
    freil
    12-12-2016, 06:19 PM Go to last post

  50. Angry Formula is driving me crazy?????

    Started by Chris Watson‎, 02-11-2006 07:51 AM
    • 19
    • 1,716
    Sandy Mann
    02-13-2006, 03:20 PM Go to last post
+ Post New Thread
Page 101 of 5614 FirstFirst ... 101 ...

Forum Information and Options

Users Browsing this Forum

There are currently 85 users browsing this forum. (3 members & 82 guests)

  1. cwwazy,
  2. Ravana

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