# SORT(UNIQUE(IF((('Pur-Pay Recd Sheet'!\$D\$5:\$D\$2100=\$I\$7)*('Pur-Pay Recd Sheet'!\$F\$5:\$F\$2100>=\$D\$8)*(

Occasional Visitor

# SORT(UNIQUE(IF((('Pur-Pay Recd Sheet'!\$D\$5:\$D\$2100=\$I\$7)*('Pur-Pay Recd Sheet'!\$F\$5:\$F\$2100>=\$D\$8)*(

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

# Re: SORT(UNIQUE(IF((('Pur-Pay Recd Sheet'!\$D\$5:\$D\$2100=\$I\$7)*('Pur-Pay Recd Sheet'!\$F\$5:\$F\$2100>=

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.