Solved

Posted on 2016-10-04
28 Views
Hi Experts using excel 2010

I have the following array Formula works fine..

IFERROR(INDEX('Data Entry'!A\$2:A\$6,SMALL(IF('Data Entry'!\$DI\$2:\$DI\$6=1,IF('Data Entry'!\$BF\$2:\$BF\$6>=\$C\$1,IF('Data Entry'!\$BF\$2:\$BF\$6<=\$F\$1,ROW('Data Entry'!\$BF\$2:\$BF\$6)-ROW('Data Entry'!\$BF\$2)+1))),ROWS(A\$3:A3))),"")

Need to add a step so if column AD (same data range) has the text C into above.
0
Question by:route217
1 Comment

LVL 28

Accepted Solution

Subodh Tiwari (Neeraj) earned 500 total points
ID: 41827902
Try this.....

``````=IFERROR(INDEX('Data Entry'!A\$2:A\$6,SMALL(IF('Data Entry'!\$AD\$2:\$AD\$6="C",IF('Data Entry'!\$DI\$2:\$DI\$6=1,IF('Data Entry'!\$BF\$2:\$BF\$6>=\$C\$1,IF('Data Entry'!\$BF\$2:\$BF\$6<=\$F\$1,ROW('Data Entry'!\$BF\$2:\$BF\$6)-ROW('Data Entry'!\$BF\$2)+1)))),ROWS(A\$3:A3))),"")
``````
0

## Featured Post

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…