Jul 20 2021 10:29 AM
SORT(UNIQUE(IF((('Pur-Pay Recd Sheet'!$D$5:$D$2100=$I$7)*('Pur-Pay Recd Sheet'!$F$5:$F$2100>=$D$8)*('Pur-Pay Recd Sheet'!$F$5:$F$2100<=$I$8)),CHOOSE({1,2,3,4,5,6,7,8,9},'Pur-Pay Recd Sheet'!$C$5:$C$2100,'Pur-Pay Recd Sheet'!$A$5:$A$2100,'Pur-Pay Recd Sheet'!$F$5:$F$2100,'Pur-Pay Recd Sheet'!$B$5:$B$2100,'Pur-Pay Recd Sheet'!$E$5:$E$2100,'Pur-Pay Recd Sheet'!$G$5:$G$2100,'Pur-Pay Recd Sheet'!$H$5:$H$2100,'Pur-Pay Recd Sheet'!$I$5:$I$2100,'Pur-Pay Recd Sheet'!$J$5:$J$2100)))) in this formula out of 108 cells of 9 columns, in 5 cells in 5th column result is not proper showing error “VALUE!” please help, on remote link system
Why I should remove highlighted words , this is my sheet name
Jul 20 2021 01:52 PM
If you mean formula
=SORT(
UNIQUE(
IF(
('Pur-Pay Recd Sheet'!$D$5:$D$2100=$I$7)*
('Pur-Pay Recd Sheet'!$F$5:$F$2100>=$D$8)*
('Pur-Pay Recd Sheet'!$F$5:$F$2100<=$I$8),
CHOOSE({1,2,3,4,5,6,7,8,9},
'Pur-Pay Recd Sheet'!$C$5:$C$2100,
'Pur-Pay Recd Sheet'!$A$5:$A$2100,
'Pur-Pay Recd Sheet'!$F$5:$F$2100,
'Pur-Pay Recd Sheet'!$B$5:$B$2100,
'Pur-Pay Recd Sheet'!$E$5:$E$2100,
'Pur-Pay Recd Sheet'!$G$5:$G$2100,
'Pur-Pay Recd Sheet'!$H$5:$H$2100,
'Pur-Pay Recd Sheet'!$I$5:$I$2100,
'Pur-Pay Recd Sheet'!$J$5:$J$2100
)
)
)
)
it works correctly. I mean without errors, have no idea about expected results.