Juriemagic
10-30-2015, 05:50 AM
hi good people,
Would someone please be so kind to modify this formula for me so that it would be dynamic?. The formula is:
=INDEX($C$5:$C$1000,MATCH(0,COUNTIF($C$5:$C$1000,"<"&$C$5:$C$1000)-SUM(COUNTIF($C$5:$C$1000,"="&AW$14:AW14)),0))
The problem is that the range is not always up to 1000. All and any help will be greatly appreciated!..thank you guys..
Would someone please be so kind to modify this formula for me so that it would be dynamic?. The formula is:
=INDEX($C$5:$C$1000,MATCH(0,COUNTIF($C$5:$C$1000,"<"&$C$5:$C$1000)-SUM(COUNTIF($C$5:$C$1000,"="&AW$14:AW14)),0))
The problem is that the range is not always up to 1000. All and any help will be greatly appreciated!..thank you guys..