aqeelnokia99
Board Regular
- Joined
- Dec 23, 2018
- Messages
- 145
- Office Version
- 2013
- Platform
- Windows
Hello i try to find most match row # in a array formula i have 2 sheet with same coloms name like i post down i make a formula like Po sheet 1 = all PO row in sheet 2 and qty sheet 1=all Qty in sheet 2 and its give me true and fales in array so i want to get the row # of whre most true like row 5
<style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #CCC ; } .tableizer-table th { background-color: #104E8B ; color: #FFF ; font-weight: bold; }</style>
<thead>
</thead><tbody>
</tbody>
<style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #CCC ; } .tableizer-table th { background-color: #104E8B ; color: #FFF ; font-weight: bold; }</style>
PO | qty | size | design | color | row |
---|---|---|---|---|---|
TRUE | FALSE | TRUE | FALSE | FALSE | 1 |
FALSE | FALSE | FALSE | FALSE | FALSE | 2 |
FALSE | FALSE | FALSE | FALSE | FALSE | 3 |
TRUE | TRUE | FALSE | TRUE | FALSE | 4 |
TRUE | TRUE | TRUE | TRUE | FALES | 5 |
<thead>
</thead><tbody>
</tbody>