Steve Belsch
04-27-2020, 01:22 PM
Hi all,
I have a long nested set of formulas that look into a worksheet data table and return data that matches specific reference points. Once I get that data with the formula below, is there a way to delete that data from the original table using a formula or some other method?
=IF(ROWS($B$3:G43)<=$BY$2,IF(AND($BZ$2=INDEX('Accrual & PO Data'!$J$2:$J$1048576,AGGREGATE(15,3,('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)/('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)*ROW('Accrual & PO Data'!$I:$I),ROWS($B$3:J43))),$BX$2=INDEX('Accrual & PO Data'!$L$2:$L$1048576,AGGREGATE(15,3,('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)/('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)*ROW('Accrual & PO Data'!$I:$I),ROWS($B$3:J43)))),INDEX('Accrual & PO Data'!I$2:I$1048576,AGGREGATE(15,3,('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)/('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)*ROW('Accrual & PO Data'!$I:$I),ROWS($B$3:J43))),""),"")
Thanks for the help!
Steve
I have a long nested set of formulas that look into a worksheet data table and return data that matches specific reference points. Once I get that data with the formula below, is there a way to delete that data from the original table using a formula or some other method?
=IF(ROWS($B$3:G43)<=$BY$2,IF(AND($BZ$2=INDEX('Accrual & PO Data'!$J$2:$J$1048576,AGGREGATE(15,3,('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)/('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)*ROW('Accrual & PO Data'!$I:$I),ROWS($B$3:J43))),$BX$2=INDEX('Accrual & PO Data'!$L$2:$L$1048576,AGGREGATE(15,3,('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)/('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)*ROW('Accrual & PO Data'!$I:$I),ROWS($B$3:J43)))),INDEX('Accrual & PO Data'!I$2:I$1048576,AGGREGATE(15,3,('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)/('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)*ROW('Accrual & PO Data'!$I:$I),ROWS($B$3:J43))),""),"")
Thanks for the help!
Steve