Results 1 to 11 of 11

Range of formula changes according to a condition

Threaded View

  1. 11-30-2017, 11:36 AM #4
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Range of formula changes according to a condition

    Hi all- Perhaps this ARRAY FORMULA in G2: 
    =STDEV.P(IF(($E$1:$E$999=$E2)+(ROW()=ROW($E$2)),$B$2:$B$1000))
    Last edited by leelnich; 11-30-2017 at 12:10 PM.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
    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. If a condition is met convert range to value from formula
    By Mothergreen in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-13-2016, 11:49 AM
  2. Need formula using 'If' condition & inserting a specific range.
    By andyzz in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-26-2014, 02:58 AM
  3. [SOLVED] Looping through a range and inserting a formula where condition met
    By strud in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-06-2014, 06:24 AM
  4. Index Formula - adding a range condition
    By Henry c in forum Excel General
    Replies: 2
    Last Post: 04-29-2010, 10:19 AM
  5. [SOLVED] formula to calculate the average of a range basing on condition
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 10:05 AM
  6. [SOLVED] formula to calculate the average of a range basing on condition
    By Krishna Mohan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. formula to calculate the average of a range basing on condition
    By Krishna Mohan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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