+ Post New Thread
Page 511 of 5614 FirstFirst ... 511 ...
Threads 25501 to 25550 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. convert text YEAR to a date

    Started by araki‎, 10-12-2020 06:32 PM
    date & text formula 1 Attachment(s)
    • 10
    • 580
    alansidman
    10-13-2020, 02:17 PM Go to last post

  2. Lookup function issue

    Started by olliek8‎, 08-16-2015 06:31 PM
    lookup, lookup data, lookup error, lookup function 2 Attachment(s)
    • 10
    • 742
    FlameRetired
    08-18-2015, 10:16 PM Go to last post

  3. Time accrual

    Started by ddemby‎, 08-18-2015 12:38 PM
    3 Attachment(s)
    • 10
    • 514
    ddemby
    08-26-2015, 12:31 PM Go to last post

  4. [SOLVED] Index Matching not working and need to pull data from large database

    Started by aalsaffa‎, 07-18-2017 07:26 AM
    3 Attachment(s)
    • 10
    • 521
    aalsaffa
    07-18-2017, 10:09 AM Go to last post

  5. 1st name and 2nd name mixed up

    Started by Katyusa82‎, 07-27-2017 04:55 AM
    3 Attachment(s)
    • 10
    • 670
    kvsrinivasamurthy
    07-28-2017, 10:51 AM Go to last post

  6. [SOLVED] Select Alphabet from Cell

    Started by shansakhi‎, 11-15-2020 06:03 AM
    1 Attachment(s)
    • 10
    • 689
    shansakhi
    11-19-2020, 04:23 AM Go to last post

  7. [SOLVED] Need help w/return value of duplicate cell

    Started by CrissyCK‎, 07-25-2017 08:06 AM
    duplicate cells, return an array, return cell address, unique cells 1 Attachment(s)
    • 10
    • 794
    CrissyCK
    07-27-2017, 11:52 AM Go to last post

  8. Question [SOLVED] Find and mark not only duplicate dates, but approximate dates as well

    Started by ArtCore‎, 07-21-2017 08:22 AM
    approximate match, date, duplicate, formula 3 Attachment(s)
    • 10
    • 723
    CK76
    07-21-2017, 02:33 PM Go to last post

  9. [SOLVED] Newbie question using COUNTIFS with text and dates

    Started by thingymajig0‎, 07-22-2017 11:08 AM
    3 Attachment(s)
    • 10
    • 593
    thingymajig0
    07-23-2017, 05:23 AM Go to last post

  10. VLOOKUP functions to generate report

    Started by vishiabj‎, 09-19-2019 09:17 AM
    formulas, functions, vlookup 6 Attachment(s)
    • 10
    • 1,033
    Glenn Kennedy
    12-04-2020, 04:47 PM Go to last post

  11. [SOLVED] Estimate Stock at Risk of Expiry

    Started by Aalia‎, 04-04-2020 06:07 AM
    2 Attachment(s)
    • 10
    • 2,178
    ninahong
    11-30-2020, 03:02 AM Go to last post

  12. Dependent lists based on multiple not unique table columns

    Started by jaryszek‎, 07-28-2020 05:14 AM
    7 Attachment(s)
    • 10
    • 590
    jaryszek
    12-18-2020, 09:59 AM Go to last post

  13. [SOLVED] non-negative number formatting

    Started by xam99‎, 11-28-2020 03:44 AM
    5 Attachment(s)
    • 10
    • 655
    xam99
    11-28-2020, 09:41 AM Go to last post

  14. Pivot table issue, I'm not able to capture new data, when table is updated

    Started by johnnyq113‎, 08-13-2015 09:57 PM
    3 Attachment(s)
    • 10
    • 2,157
    johnnyq113
    08-26-2015, 05:01 PM Go to last post

  15. Find & Replace Values

    Started by dandi10‎, 11-14-2020 11:10 AM
    formula 4 Attachment(s)
    • 10
    • 706
    Ochimus
    11-25-2020, 03:39 PM Go to last post

  16. Populate cell if certain word selected from dropdown in range of cells on different sheet

    Started by GREGHAM1982‎, 11-13-2020 09:06 AM
    • 10
    • 358
    maniacb
    11-16-2020, 09:35 AM Go to last post

  17. Sumif or index formula?

    Started by DimitrisPap‎, 11-25-2020 04:21 AM
    2 Attachment(s)
    • 10
    • 299
    bebo021999
    11-25-2020, 09:25 PM Go to last post

  18. Split cell data

    Started by MoeFoxx‎, 11-26-2020 11:47 AM
    2 Attachment(s)
    • 10
    • 415
    Rick Rothstein
    11-27-2020, 01:05 AM Go to last post

  19. Prevent Excel User from Leaving a Cell Blank When Adjacent Cell is Greater Than Zero

    Started by Saabra‎, 11-27-2020 02:09 PM
    3 Attachment(s)
    • 10
    • 558
    Saabra
    11-28-2020, 04:02 PM Go to last post

  20. [SOLVED] Sum with dynamic range

    Started by ATD09‎, 12-03-2020 08:08 AM
    dynamic, sum 5 Attachment(s)
    • 10
    • 675
    ATD09
    12-03-2020, 03:59 PM Go to last post

  21. [SOLVED] Generate random values that are a function of % calculations

    Started by skydivetom‎, 12-04-2020 02:44 PM
    4 Attachment(s)
    • 10
    • 359
    skydivetom
    12-06-2020, 07:09 PM Go to last post

  22. [SOLVED] Why does this formula give me 0?

    Started by Butcher1‎, 12-06-2020 12:11 AM
    2 Attachment(s)
    • 10
    • 389
    Butcher1
    12-06-2020, 08:46 PM Go to last post

  23. [SOLVED] Extracting Cell data if criteria is met?

    Started by Warrior1140‎, 12-08-2020 04:27 PM
    3 Attachment(s)
    • 10
    • 398
    wk9128
    12-10-2020, 04:44 AM Go to last post

  24. [SOLVED] Array formula to combine 2 numbers into a matrix

    Started by bekman‎, 12-13-2020 02:49 PM
    5 Attachment(s)
    • 10
    • 484
    kvsrinivasamurthy
    12-17-2020, 01:50 AM Go to last post

  25. [SOLVED] MINMAX via Offset from last value in column

    Started by analystbank‎, 12-17-2020 05:09 AM
    max, min, offset 4 Attachment(s)
    • 10
    • 880
    analystbank
    12-21-2020, 01:57 AM Go to last post

  26. Calculate Headcount by department, based on Hire date and Termination date

    Started by Cornelia‎, 11-22-2013 11:25 AM
    2 Attachment(s)
    • 10
    • 11,394
    cmetzker
    11-11-2020, 07:42 AM Go to last post

  27. [SOLVED] MODE() is there a way to return bi-modal or multimodal results?

    Started by Jdolsak‎, 01-09-2006 12:15 AM
    • 10
    • 1,589
    Rothman
    03-17-2006, 03:50 PM Go to last post

  28. 1 will be City, 2 will be Roskill and so on please.

    Started by Max‎, 09-06-2005 01:05 AM
    • 10
    • 479
    Steved
    09-06-2005, 09:05 AM Go to last post

  29. SUM cells only below a checked cell

    Started by Rythan‎, 01-19-2008 02:30 PM
    • 10
    • 2,333
    Rythan
    01-31-2008, 08:33 PM Go to last post

  30. Repeating items a specific number of times

    Started by ninja0059‎, 01-22-2008 12:08 PM
    3 Attachment(s)
    • 10
    • 2,670
    ninja0059
    02-11-2008, 01:19 PM Go to last post

  31. Exclamation Long equation, problem w/ VLOOKUP (repeated, one instance gives error..)

    Started by cptwhite‎, 02-11-2008 11:43 AM
    1 Attachment(s)
    • 10
    • 2,335
    NBVC
    02-14-2008, 12:37 PM Go to last post

  32. Conditionally Locking Cells

    Started by beesus311‎, 02-23-2008 08:16 AM
    • 10
    • 1,260
    WinteE
    02-25-2008, 01:28 PM Go to last post

  33. Angry [SOLVED] SUMPRODUCT help

    Started by danmarsh‎, 09-14-2012 10:05 AM
    1 Attachment(s)
    • 10
    • 514
    danmarsh
    09-14-2012, 12:39 PM Go to last post

  34. Eliminating high score in rankings

    Started by Johnmus‎, 09-23-2012 01:16 PM
    1 Attachment(s)
    • 10
    • 818
    Johnmus
    09-23-2012, 08:19 PM Go to last post

  35. IRR help

    Started by Milkman1969‎, 04-25-2013 06:25 PM
    1 Attachment(s)
    • 10
    • 947
    MoneyMaker
    05-07-2013, 03:16 AM Go to last post

  36. [SOLVED] Combing formula IF OR TODAY

    Started by vaibhav2312‎, 05-09-2013 04:01 AM
    • 10
    • 691
    :) Sixthsense :)
    05-09-2013, 06:42 AM Go to last post

  37. [SOLVED] Formula to Sum numbers depending on text in other cells

    Started by ExcelGal‎, 05-11-2013 07:06 AM
    1 Attachment(s)
    • 10
    • 966
    Tony Valko
    05-11-2013, 10:30 AM Go to last post

  38. MinMax formula problem

    Started by bqheng‎, 10-24-2013 08:58 PM
    3 Attachment(s)
    • 10
    • 1,651
    dredwolf
    05-08-2014, 08:14 PM Go to last post

  39. [SOLVED] How to apply conditional formatting across sheets

    Started by James__S‎, 08-15-2015 09:42 PM
    • 10
    • 822
    James__S
    08-23-2015, 08:14 PM Go to last post

  40. [SOLVED] Return the number of days in a month from a data set

    Started by pickslides‎, 05-07-2014 07:16 PM
    4 Attachment(s)
    • 10
    • 953
    AlKey
    05-08-2014, 08:02 AM Go to last post

  41. [SOLVED] Skip zero count next

    Started by jaycee66‎, 04-29-2014 01:05 PM
    1 Attachment(s)
    • 10
    • 493
    sktneer
    04-29-2014, 02:08 PM Go to last post

  42. [SOLVED] Can you embed an IF function within an IF fuction?

    Started by s0o0y‎, 05-02-2014 01:59 PM
    embedded, if formula, if function
    • 10
    • 1,122
    s0o0y
    05-02-2014, 03:00 PM Go to last post

  43. Match Names and divide values across sheets

    Started by antexity‎, 05-07-2014 04:16 PM
    2 Attachment(s)
    • 10
    • 962
    antexity
    05-09-2014, 05:29 PM Go to last post

  44. [SOLVED] MAX A & MAX B Formula

    Started by jenna_max‎, 05-07-2014 08:37 PM
    2 Attachment(s)
    • 10
    • 801
    JBeaucaire
    05-08-2014, 02:46 AM Go to last post

  45. [SOLVED] Text not coming thru from another worksheet

    Started by barbibchn‎, 05-08-2014 12:19 PM
    3 Attachment(s)
    • 10
    • 624
    barbibchn
    05-08-2014, 01:52 PM Go to last post

  46. [SOLVED] recognise words in multiple cells with a unique output

    Started by tlacloche‎, 05-09-2014 09:48 AM
    • 10
    • 819
    ben_hensel
    05-09-2014, 10:50 AM Go to last post

  47. Drop Down

    Started by mellea‎, 08-21-2015 04:50 PM
    4 Attachment(s)
    • 10
    • 689
    Mazzaropi
    08-27-2015, 11:44 AM Go to last post

  48. Indirect search criteria to dynamic list

    Started by T86157‎, 08-22-2015 09:50 PM
    2 Attachment(s)
    • 10
    • 737
    Jacc
    08-23-2015, 12:29 PM Go to last post

  49. [SOLVED] Help with a Formula for Text Field and Two Criterias

    Started by odoualex‎, 08-12-2015 12:42 PM
    6 Attachment(s)
    • 10
    • 667
    odoualex
    08-13-2015, 11:33 AM Go to last post

  50. [SOLVED] Referencing subtotal numbers

    Started by Arun‎, 03-01-2006 03:50 PM
    • 10
    • 743
    Arun
    03-01-2006, 06:15 PM Go to last post
+ Post New Thread
Page 511 of 5614 FirstFirst ... 511 ...

Forum Information and Options

Users Browsing this Forum

There are currently 30 users browsing this forum. (2 members & 28 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