+ Post New Thread
Page 551 of 5614 FirstFirst ... 551 ...
Threads 27501 to 27550 of 280690

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. [SOLVED] Random number with condition

    Started by Alesha‎, 09-05-2022 04:31 AM
    6 Attachment(s)
    • 10
    • 397
    bsalv
    09-05-2022, 05:11 PM Go to last post

  2. Tracking a chain of invitations

    Started by edman111‎, 05-27-2016 05:19 AM
    5 Attachment(s)
    • 10
    • 553
    amit.wilson
    05-31-2016, 07:01 AM Go to last post

  3. [SOLVED] Formula for if with largest....

    Started by kikola123‎, 11-03-2018 02:11 AM
    2 Attachment(s)
    • 10
    • 388
    AliGW
    11-03-2018, 09:08 AM Go to last post

  4. Get data based on where another datapoint is

    Started by ErikWi‎, 11-08-2018 05:49 AM
    find, gather data, index 2 Attachment(s)
    • 10
    • 3,958
    Pete_UK
    11-12-2018, 04:57 AM Go to last post

  5. [SOLVED] Network Days but conditioned by time

    Started by stuhendry‎, 10-18-2018 07:36 AM
    1 Attachment(s)
    • 10
    • 393
    Bo_Ry
    10-29-2018, 11:11 AM Go to last post

  6. SUMIF Adding up names in a category

    Started by priestyuk‎, 10-20-2018 03:37 PM
    3 Attachment(s)
    • 10
    • 516
    FoxSeaLady
    10-24-2018, 09:31 AM Go to last post

  7. Convert text to parsable content for variable replacement

    Started by gdawirs‎, 10-30-2018 11:48 AM
    3 Attachment(s)
    • 10
    • 584
    gdawirs
    10-31-2018, 07:16 AM Go to last post

  8. Rounding up or down depending on percentage result

    Started by Ginette Lacombe‎, 11-07-2018 12:46 PM
    1 Attachment(s)
    • 10
    • 503
    Glenn Kennedy
    11-07-2018, 03:09 PM Go to last post

  9. [SOLVED] Grade book with varied weightings; letters to numbers to letters

    Started by mcgudo‎, 08-29-2022 07:18 AM
    3 Attachment(s)
    • 10
    • 334
    AliGW
    08-30-2022, 04:07 AM Go to last post

  10. [SOLVED] How to highlight the cells using a formula with conditional formatting or else

    Started by steiny88‎, 08-31-2022 07:22 AM
    conditional formatting, formula, highlight active cell, values and format 6 Attachment(s)
    • 10
    • 522
    JeteMc
    09-06-2022, 08:41 AM Go to last post

  11. Return to specific value skip blank, according to the new increment in specific items

    Started by hiXtori‎, 09-08-2022 04:24 AM
    4 Attachment(s)
    • 10
    • 283
    Glenn Kennedy
    09-10-2022, 12:36 PM Go to last post

  12. Moved: Naming cells using info from multiple nearby cells

    Started by &Roo.public.servant‎, 08-31-2022 09:57 PM
    •  
    •  

  13. Smile Difference in hours between two date/time columns

    Started by lcomeaux‎, 05-25-2016 12:10 PM
    3 Attachment(s)
    • 10
    • 772
    finallycompleted
    05-29-2016, 04:56 PM Go to last post

  14. Subtracting outgoing amounts from multiple cells until exhausted.

    Started by pickle‎, 09-28-2022 06:24 AM
    2 Attachment(s)
    • 10
    • 266
    pickle
    09-30-2022, 06:50 AM Go to last post

  15. Lightbulb [SOLVED] Lookup formula in another sheet and multiple other operations..

    Started by ciccardo‎, 10-05-2022 03:33 PM
    formula, sheets, vlookup 1 Attachment(s)
    • 10
    • 391
    TMS
    10-06-2022, 01:12 PM Go to last post

  16. UPDATE: Create a top 10 list of most commonly used text values

    Started by glennas94‎, 10-02-2022 10:56 PM
    5 Attachment(s)
    • 10
    • 294
    AliGW
    10-03-2022, 02:09 AM Go to last post

  17. Average inventory on hand

    Started by Jadeking‎, 09-19-2022 09:47 AM
    3 Attachment(s)
    • 10
    • 280
    PeteABC123
    09-19-2022, 05:23 PM Go to last post

  18. [SOLVED] Data Manipulation

    Started by CJ_Melbourne1‎, 09-20-2022 12:54 AM
    1 Attachment(s)
    • 10
    • 249
    FDibbins
    09-20-2022, 02:13 AM Go to last post

  19. Formula for replacing text for the cell next to?

    Started by bsacco‎, 10-09-2022 04:45 PM
    • 10
    • 314
    Glenn Kennedy
    10-10-2022, 12:37 PM Go to last post

  20. [SOLVED] Combined cell value

    Started by TirthShah‎, 10-03-2022 09:53 PM
    4 Attachment(s)
    • 10
    • 243
    Glenn Kennedy
    10-04-2022, 03:42 AM Go to last post

  21. [SOLVED] Adjust Formula to count next month date

    Started by benbroadhead0‎, 09-27-2022 09:15 AM
    • 10
    • 216
    Glenn Kennedy
    09-27-2022, 09:43 AM Go to last post

  22. [SOLVED] Colour change in columns depending on dates

    Started by LazySumby‎, 10-12-2022 04:18 AM
    2 Attachment(s)
    • 10
    • 360
    LazySumby
    10-13-2022, 10:50 AM Go to last post

  23. Unhappy if nested formula according to years of service

    Started by schneiderv1‎, 09-28-2022 12:18 PM
    • 10
    • 239
    HansDouwe
    09-28-2022, 04:10 PM Go to last post

  24. [SOLVED] The reason for the unusual increase in the size of the Excel file

    Started by Yaghoub61‎, 10-02-2022 06:34 AM
    3 Attachment(s)
    • 10
    • 364
    Glenn Kennedy
    10-04-2022, 04:28 AM Go to last post

  25. [SOLVED] Prime numbers

    Started by Paulrwoolley‎, 10-18-2022 08:09 AM
    5 Attachment(s)
    • 10
    • 345
    MrShorty
    10-18-2022, 11:20 AM Go to last post

  26. Smile Part of the range formula

    Started by stas_p‎, 08-16-2013 12:39 PM
    • 10
    • 720
    XOR LX
    08-19-2013, 02:44 PM Go to last post

  27. How to countif columns of dates

    Started by mrgillus‎, 08-10-2009 09:48 AM
    4 Attachment(s)
    • 10
    • 1,268
    mrgillus
    08-10-2009, 01:55 PM Go to last post

  28. Ignoring Blank Cells in IF statement

    Started by dbanbury‎, 08-10-2009 06:10 PM
    • 10
    • 9,875
    dbanbury
    08-12-2009, 12:08 PM Go to last post

  29. Dependent Lists With Spaces in the Main List

    Started by joseph_707‎, 08-11-2009 12:17 PM
    2 Attachment(s)
    • 10
    • 8,789
    NBVC
    08-12-2009, 03:31 PM Go to last post

  30. Build list in Dropdown from Data source

    Started by aarbuckle‎, 08-27-2009 05:09 PM
    3 Attachment(s)
    • 10
    • 2,228
    aarbuckle
    08-31-2009, 02:53 PM Go to last post

  31. How to use lookup function with multiple criterias?

    Started by surfol‎, 08-26-2009 08:13 AM
    1 Attachment(s)
    • 10
    • 2,613
    DonkeyOte
    08-27-2009, 03:43 AM Go to last post

  32. Index Match - nested If (less than/greater than statements)

    Started by kelea‎, 08-28-2009 01:32 PM
    1 Attachment(s)
    • 10
    • 9,835
    kelea
    08-28-2009, 04:40 PM Go to last post

  33. COUNTIF function help

    Started by PRodgers‎, 09-02-2009 04:49 AM
    • 10
    • 802
    PRodgers
    09-02-2009, 06:16 AM Go to last post

  34. Excel BLANK cell reference

    Started by RCROOKER‎, 01-20-2013 08:22 AM
    • 10
    • 1,462
    RCROOKER
    01-20-2013, 07:21 PM Go to last post

  35. [SOLVED] Count Cell as 0.5

    Started by DekHog‎, 01-21-2013 08:00 AM
    1 Attachment(s)
    • 10
    • 3,215
    DekHog
    01-21-2013, 12:16 PM Go to last post

  36. [SOLVED] index return multiple values

    Started by antho27‎, 01-18-2013 02:17 PM
    2 Attachment(s)
    • 10
    • 852
    dilipandey
    01-20-2013, 12:52 AM Go to last post

  37. [SOLVED] Reverse personal names from "First Last" to "Last, First" and accommodate middle names

    Started by MrGadget6977‎, 08-17-2013 11:21 AM
    reverse string
    • 10
    • 3,633
    Tony Valko
    08-17-2013, 07:10 PM Go to last post

  38. [SOLVED] If cells in column A are duplicate would like to transpose column b

    Started by schweizer‎, 08-16-2013 04:56 PM
    2 Attachment(s)
    • 10
    • 1,566
    RobertMika
    08-19-2013, 12:00 PM Go to last post

  39. Combining 2 columns if they have the same company

    Started by ldrixole‎, 05-26-2016 11:08 AM
    combine duplicate rows 2 Attachment(s)
    • 10
    • 543
    ldrixole
    05-26-2016, 04:13 PM Go to last post

  40. Excel 2013 Formulas Show Zeros Instead Of Calculating. Works In Excel 2007-2010.

    Started by Onihonker‎, 08-15-2013 04:47 PM
    3 Attachment(s)
    • 10
    • 2,840
    Onihonker
    08-20-2013, 01:02 PM Go to last post

  41. Hight Light the cell when data match

    Started by yukioh‎, 08-22-2013 01:07 AM
    3 Attachment(s)
    • 10
    • 623
    Fotis1991
    08-22-2013, 02:18 AM Go to last post

  42. formula using INDEX/MATCH to retrieve multiple matches returned into one column

    Started by merlyn45‎, 08-09-2013 04:55 PM
    1 Attachment(s)
    • 10
    • 2,062
    merlyn45
    08-19-2013, 11:33 AM Go to last post

  43. Automatic Printing

    Started by huzzug‎, 07-23-2014 08:32 PM
    • 10
    • 768
    huzzug
    11-09-2014, 06:41 AM Go to last post

  44. [SOLVED] Countifs Formula needed to count # of dates in same month that also is in same state.

    Started by Stanimal‎, 11-11-2014 11:33 PM
    countifs 2013, date, month
    • 10
    • 1,044
    Stanimal
    11-12-2014, 02:43 PM Go to last post

  45. [SOLVED] Count cell that meet a criteria and are not blank

    Started by Losguapos1‎, 11-16-2014 11:39 AM
    1 Attachment(s)
    • 10
    • 909
    Ron Coderre
    11-16-2014, 05:56 PM Go to last post

  46. [SOLVED] If find a match then add two diff cells on same row

    Started by butair‎, 11-19-2014 09:20 AM
    1 Attachment(s)
    • 10
    • 565
    FDibbins
    11-19-2014, 10:11 AM Go to last post

  47. [SOLVED] Listing numbers from a column without organizing them

    Started by leprkon‎, 11-21-2014 04:41 AM
    3 Attachment(s)
    • 10
    • 572
    FlameRetired
    11-21-2014, 02:47 PM Go to last post

  48. [SOLVED] How to crop a part of the URL using excel formula

    Started by 99problems‎, 05-28-2016 05:50 PM
    • 10
    • 824
    Tony Valko
    05-28-2016, 06:39 PM Go to last post

  49. [SOLVED] From vertical to horizental issue.

    Started by Challebjoern‎, 06-01-2016 03:07 AM
    4 Attachment(s)
    • 10
    • 688
    shukla.ankur281190
    06-01-2016, 04:19 AM Go to last post

  50. [SOLVED] Trouble with Nested Year(now()) Statement

    Started by wlaster‎, 05-24-2016 04:56 PM
    • 10
    • 528
    Tony Valko
    05-25-2016, 11:21 AM Go to last post
+ Post New Thread
Page 551 of 5614 FirstFirst ... 551 ...

Forum Information and Options

Users Browsing this Forum

There are currently 51 users browsing this forum. (4 members & 47 guests)

  1. boynejs,
  2. HansDouwe,
  3. JN831,
  4. tjensen91

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