Results 1 to 6 of 6

How to avoid Zeros in using LARGE AND SMALL formulas like in =LARGE($E$1:$E$10,A1)

Threaded View

omega0010 How to avoid Zeros in using... 07-19-2015, 08:19 AM
Jacc Re: How to avoid Zeros in... 07-19-2015, 08:22 AM
omega0010 Re: How to avoid Zeros in... 07-19-2015, 08:30 AM
Jacc Re: How to avoid Zeros in... 07-19-2015, 08:24 AM
Jacc Re: How to avoid Zeros in... 07-19-2015, 08:33 AM
Czeslaw Re: How to avoid Zeros in... 07-19-2015, 11:05 AM
  1. 07-19-2015, 08:19 AM #1
    omega0010 is offline
    Forum Contributor
    Join Date
    12-11-2012
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    321

    How to avoid Zeros in using LARGE AND SMALL formulas like in =LARGE($E$1:$E$10,A1)

    please see the file if necessary
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to break ties when using Large, Small formulas
    By iowagrad2003 in forum Excel General
    Replies: 7
    Last Post: 07-01-2015, 07:57 AM
  2. [SOLVED] How can I avoid showing a large percentage value?
    By mcmuney in forum Excel General
    Replies: 2
    Last Post: 05-15-2015, 01:53 PM
  3. [SOLVED] AVERAGEIFS, LARGE, and SMALL
    By opsanalysis07 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-20-2014, 04:14 PM
  4. [SOLVED] Excel 2007 : Pick next large/small value
    By vonborge in forum Excel General
    Replies: 6
    Last Post: 05-15-2011, 10:08 AM
  5. How can I avoid large, nested IF AND OR queries
    By sherlock99 in forum Excel General
    Replies: 3
    Last Post: 01-19-2011, 07:50 AM
  6. SMALL and LARGE
    By Tonto in forum Excel General
    Replies: 6
    Last Post: 10-27-2005, 02:05 AM
  7. SMALL/LARGE function
    By Barry Taylor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2005, 03:47 PM

Bookmarks

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