| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
making used values fall from a list
I am using 3 columns of data. The first is my original list. the second contains this =IF(COUNTIF(Bullets!$A$1:$K$310,A1)=1,"",ROW()) the third contains this =IF(ROW(A1:A85)-ROW(A1)+1COUNT(B1:B85),"",INDEX(A:A,SMALL(B1:B85, ROW(INDIRECT("1:"&ROWS(A1:A85)))))) The third column is the list that I use to fill in cells on a sheet called Bullets. www.contextures.com is where the formula came from, and the second formula is inputted as an array. However, when i go to the sheet called Bullets, the items do not come off of the list. What have I done wrong with the code or what am I doing wrong with the validated lists? -- static69 ------------------------------------------------------------------------ static69's Profile: http://www.excelforum.com/member.php...o&userid=11075 View this thread: http://www.excelforum.com/showthread...hreadid=345855 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| making a non-validation list | Excel Worksheet Functions | |||
| Need totals of values that fall within a given year | Excel Worksheet Functions | |||
| Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Threaded Mode
