Hi all,
Rather than starting up a new thread on a similar topic, I thought I could piggyback this one. I (think) I am trying to do what the OP was attempting, but please correct me if I am wrong.
I am hoping to exclude a cell from ranking in the array I have used, supplied from this thread. My parameters for excluding said cells are if the value of another cell is less than a set value. Like so:
<table style="border-collapse: collapse; width: 144pt;" border="0" cellpadding="0" cellspacing="0" width="192"><col style="width: 48pt;" span="3" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" align="right" height="17" width="64">300</td> <td style="width: 48pt;" align="right" width="64">85%</td> <td style="width: 48pt;" align="right" width="64">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">280</td> <td align="right">86%</td> <td align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">300</td> <td align="right">72%</td> <td align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">420</td> <td align="right">79%</td> <td align="right">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">430</td> <td align="right">93%</td> <td align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">40</td> <td align="right">90%</td> <td class="xl65"> -</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">25</td> <td align="right">88%</td> <td class="xl65"> -</td> </tr> </tbody></table>
Column A = if this value is less than 100, it does not get ranked.
Column B = value I am hoping to rank based on the (rankif, sumproduct, if statement best to use)
Column C = target output results (ranking)
Thank you all in advance!