Results 1 to 30 of 30

Request for Excel formula for two conditions (Large to small, then small to large)

Threaded View

nicholascky Request for Excel formula for... 08-13-2016, 03:27 AM
:) Sixthsense :) Re: Request for Excel formula... 08-13-2016, 03:53 AM
jason.b75 Re: Request for Excel formula... 08-13-2016, 03:54 AM
Alf Re: Request for Excel formula... 08-13-2016, 04:05 AM
nicholascky Re: Request for Excel formula... 08-13-2016, 05:28 AM
nicholascky Re: Request for Excel formula... 08-13-2016, 05:29 AM
Alf Re: Request for Excel formula... 08-13-2016, 05:33 AM
nicholascky Re: Request for Excel formula... 08-13-2016, 05:42 AM
jason.b75 Re: Request for Excel formula... 08-13-2016, 07:18 AM
kvsrinivasamurthy Re: Request for Excel formula... 08-13-2016, 06:18 AM
sanram Re: Request for Excel formula... 08-13-2016, 06:39 AM
sanram Re: Request for Excel formula... 08-13-2016, 06:54 AM
kvsrinivasamurthy Re: Request for Excel formula... 08-13-2016, 10:58 AM
nicholascky Re: Request for Excel formula... 08-13-2016, 01:00 PM
nicholascky Re: Request for Excel formula... 08-13-2016, 01:33 PM
nicholascky Re: Request for Excel formula... 08-13-2016, 01:36 PM
jason.b75 Re: Request for Excel formula... 08-13-2016, 03:36 PM
sanram Re: Request for Excel formula... 08-13-2016, 08:25 PM
nicholascky Re: Request for Excel formula... 08-14-2016, 12:35 AM
jason.b75 Re: Request for Excel formula... 08-14-2016, 02:01 AM
kvsrinivasamurthy Re: Request for Excel formula... 08-14-2016, 02:15 AM
nicholascky Re: Request for Excel formula... 08-14-2016, 02:48 AM
nicholascky Re: Request for Excel formula... 08-14-2016, 02:47 AM
kvsrinivasamurthy Re: Request for Excel formula... 08-14-2016, 04:21 AM
nicholascky Re: Request for Excel formula... 08-14-2016, 04:47 AM
jason.b75 Re: Request for Excel formula... 08-14-2016, 05:12 AM
nicholascky Re: Request for Excel formula... 08-14-2016, 05:28 AM
jason.b75 Re: Request for Excel formula... 08-14-2016, 05:41 AM
AliGW Re: Request for Excel formula... 08-14-2016, 05:46 AM
kvsrinivasamurthy Re: Request for Excel formula... 08-14-2016, 01:16 PM
  1. 08-13-2016, 06:18 AM #10
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Request for Excel formula for two conditions (Large to small, then small to large)

    In D2, then drag down.
    =SUMPRODUCT(--(($B$4:$B$8+($C$4:$C$8)*0.00001-ROW($B$4:$B$8)*0.000000001)>B4+C4*0.00001-ROW(B4)*0.000000001))+1
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 08-13-2016 at 06:21 AM.
    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 avoid Zeros in using LARGE AND SMALL formulas like in =LARGE($E$1:$E$10,A1)
    By omega0010 in forum Excel General
    Replies: 5
    Last Post: 07-19-2015, 11:05 AM
  2. [SOLVED] Excel only shows small fraction of rows in large file
    By Devourer in forum Excel General
    Replies: 3
    Last Post: 06-26-2013, 09:40 AM
  3. Formula issue with LARGE and SMALL
    By Pearlyn in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-30-2013, 03:16 AM
  4. Automate keying in a small amount of data from a large csv.file into an excel spreadsheet
    By NoBol in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-27-2012, 10:45 AM
  5. Excel 2007 : EXCEL 2007 creating two .PNG files large one and a small one
    By boss4man in forum Excel General
    Replies: 0
    Last Post: 01-10-2012, 01:15 PM
  6. Large, Small, Index, Match formula combos
    By taudano in forum Excel General
    Replies: 2
    Last Post: 06-30-2011, 01:53 AM
  7. Excel size getiing very large on small change
    By ballack in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2007, 02:38 AM

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