asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,286
- Office Version
- 2013
- Platform
- Windows
Hello,
Is it possible to add into below formula that if there is no value on the cell V3 the formula will not show any result.The cell will kepp blank unless there is no data on the cell V3
Many Thanks
Is it possible to add into below formula that if there is no value on the cell V3 the formula will not show any result.The cell will kepp blank unless there is no data on the cell V3
Many Thanks
Code:
=IFERROR(INDEX($U$3:$U$9,SMALL(IF($V$3:$V$9=$Y3,IF($U$3:$U$9<>"",ROW($U$3:$U$9)-ROW($Y$3)+1)),COUNTIF($Y$3:Y3,Y3))),"")