How to use Filter and UNIQUE with dynamic name for Certain Column in Whole Table

[LearnMeExcel]

Hi all
i have this Dynamic Name

Invoice_data

=OFFSET(iDB!$A$1,1,0,COUNTA(iDB!$A:$A)-1,6)

and i use this formula to get unique

Not Paid List
CDE	=SORT(UNIQUE(FILTER(C2:C51,F2:F51="Not Paid")))
EFG
MFC
XYZ
ZJC

this is my Data , and my Question
how i can use my Dynamic range in this formula to Select 3rd Column, to get same Result ?
=SORT(UNIQUE(FILTER(Invoice_data(here I want just colum C from Invoice_data ),Invoice_data(here I want just colum F from Invoice_data )="Not Paid")))

Invoice Number	Date	Company Name	Amount	Currency	Status
V - 141	15/01/2021​	XYZ	1153.132​	USD	Not Paid
V - 157	17/01/2021​	FHG	4491.818​	USD	Paid
V - 158	26/01/2021​	ZJC	6076.498​	USD	Paid
V - 167	16/02/2021​	FHG	1105.557​	USD	Paid
V - 173	17/02/2021​	XYZ	7338.599​	USD	Paid
V - 184	21/02/2021​	CDE	2176.351​	USD	Paid
V - 194	06/03/2021​	THC	7663.309​	USD	Paid
V - 204	07/03/2021​	ZJC	2955.909​	USD	Paid
V - 252	23/03/2021​	MFC	4456.528​	USD	Paid
V - 278	28/03/2021​	ABC	3432.406​	USD	Paid
V - 306	28/03/2021​	MFC	3381.936​	USD	Not Paid
V - 325	31/03/2021​	JBR	7563.771​	USD	Paid
V - 326	31/03/2021​	FHG	4094.144​	USD	Paid
V - 327	19/04/2021​	EFG	7828.469​	USD	Paid
V - 330	21/04/2021​	MFC	6602.376​	USD	Not Paid
V - 342	23/04/2021​	XYZ	2979.044​	USD	Paid
V - 374	25/04/2021​	FHG	7932.121​	USD	Paid
V - 387	05/05/2021​	FHG	3621.784​	USD	Paid
V - 397	06/05/2021​	FHG	4714.177​	USD	Paid
V - 415	27/05/2021​	JBR	4942.058​	USD	Paid
V - 433	27/05/2021​	CDE	7999.256​	USD	Paid
V - 434	31/05/2021​	ABC	2743.007​	USD	Paid
V - 478	31/05/2021​	THC	1122.415​	USD	Paid
V - 523	02/06/2021​	EFG	4673.887​	USD	Paid
V - 524	16/06/2021​	JBR	2126.972​	USD	Paid
V - 531	21/06/2021​	XYZ	8576.646​	USD	Not Paid
V - 544	25/06/2021​	MFC	8452.265​	USD	Not Paid
V - 616	27/06/2021​	FHG	6481.728​	USD	Paid
V - 637	07/07/2021​	CDE	4694.205​	USD	Not Paid
V - 671	08/07/2021​	MFC	3248.498​	USD	Not Paid
V - 677	24/07/2021​	ZJC	2986.056​	USD	Paid
V - 703	07/08/2021​	THC	1342.146​	USD	Paid
V - 759	11/09/2021​	JBR	4226.128​	USD	Paid
V - 770	12/09/2021​	ZJC	1949.528​	USD	Paid
V - 815	14/09/2021​	MFC	5725.759​	USD	Not Paid
V - 846	28/09/2021​	FHG	8204.793​	USD	Paid
V - 861	29/09/2021​	MFC	6108.563​	USD	Paid
V - 887	01/10/2021​	FHG	2274.161​	USD	Paid
V - 903	10/10/2021​	ZJC	5287.774​	USD	Paid
V - 910	12/10/2021​	ZJC	7230.193​	USD	Not Paid
V - 913	12/10/2021​	ABC	1109.748​	USD	Paid
V - 926	29/10/2021​	CDE	2849.42​	USD	Paid
V - 929	01/11/2021​	FHG	4117.116​	USD	Paid
V - 934	04/11/2021​	MFC	4752.744​	USD	Paid
V - 937	07/11/2021​	XYZ	4851.978​	USD	Paid
V - 938	14/11/2021​	CDE	7279.049​	USD	Not Paid
V - 965	27/11/2021​	XYZ	2766.666​	USD	Paid
V - 966	28/11/2021​	JBR	4601.909​	USD	Paid
V - 985	06/12/2021​	CDE	1092.158​	USD	Paid
V - 986	15/12/2021​	EFG	1015.34​	USD	Not Paid

 

[Fluff]

Rather than using a dynamic named range, why not convert your data into a table & then you can use

=SORT(UNIQUE(FILTER(Invoice_data[Company Name],Invoice_data[Status]="Not Paid")))

 

[LearnMeExcel]

Hi Fluff
yes i am using table in most of my data, but in this case i want to use only Dynamic Name, is it Possible

 

[Fluff]

Ok, how about

=SORT(UNIQUE(FILTER(INDEX(Invoice_data,,3),INDEX(Invoice_data,,6)="Not Paid")))

 

[LearnMeExcel]

Thank you Fluff
another Magic Formula

 

[Fluff]

You're welcome & thanks for the feedback.