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

%3CLINGO-SUB%20id%3D%22lingo-sub-2567028%22%20slang%3D%22en-US%22%3ESORT(UNIQUE(IF((('Pur-Pay%20Recd%20Sheet'!%24D%245%3A%24D%242100%3D%24I%247)*('Pur-Pay%20Recd%20Sheet'!%24F%245%3A%24F%242100%26gt%3B%3D%24D%248)*(%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2567028%22%20slang%3D%22en-US%22%3E%3CP%3ESORT(UNIQUE(IF((('Pur-Pay%20Recd%20Sheet'!%24D%245%3A%24D%242100%3D%24I%247)*('Pur-Pay%20Recd%20Sheet'!%24F%245%3A%24F%242100%26gt%3B%3D%24D%248)*('Pur-Pay%20Recd%20Sheet'!%24F%245%3A%24F%242100%26lt%3B%3D%24I%248))%2CCHOOSE(%7B1%2C2%2C3%2C4%2C5%2C6%2C7%2C8%2C9%7D%2C'Pur-Pay%20Recd%20Sheet'!%24C%245%3A%24C%242100%2C'Pur-Pay%20Recd%20Sheet'!%24A%245%3A%24A%242100%2C'Pur-Pay%20Recd%20Sheet'!%24F%245%3A%24F%242100%2C'Pur-Pay%20Recd%20Sheet'!%24B%245%3A%24B%242100%2C'Pur-Pay%20Recd%20Sheet'!%24E%245%3A%24E%242100%2C'Pur-Pay%20Recd%20Sheet'!%24G%245%3A%24G%242100%2C'Pur-Pay%20Recd%20Sheet'!%24H%245%3A%24H%242100%2C'Pur-Pay%20Recd%20Sheet'!%24I%245%3A%24I%242100%2C'Pur-Pay%20Recd%20Sheet'!%24J%245%3A%24J%242100))))%26nbsp%3B%20in%20this%20formula%20out%20of%20108%20cells%20of%209%20columns%2C%20in%205%20cells%20in%205th%26nbsp%3B%20column%20result%20is%20not%20proper%20showing%20error%20%E2%80%9CVALUE!%E2%80%9D%26nbsp%3B%20please%20help%2C%20on%20remote%20link%20system%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20I%20should%20remove%20highlighted%20words%20%2C%20this%20is%20my%20sheet%20name%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2567028%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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)*('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

 

1 Reply

@O_P_Heda 

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.