Hello what is the best formula to find missing invoices? someone told me this formula but it doesnt really work?

[kingjet]

Hello so

two sheets with invoices numbers

they are dervied from two different systems and im trying to see which are the missing invoice numbers

both have been saved in a separate sheet

so sheet 1 is from a system elite

it has 12586 invoice numbers with duplicates (but i remove the duplicates)

sheet 2 is from IZA and it has

11115 invoice numbers


someone told me this formula

but it doesnt really show me the missing invoice numbers it shows me all the ones that are in both of the columns in the two different sheets

1=LET(list,VSTACK(P7:P20,Q7:Q20),UNIQUE(FILTER(list,list<>"")))

 

[kingjet]

what i did was

got the invoice data from ELITE

rfemoved duplicated

as there are same invoices (afterwards i did a sumifs on the original data source to get a totla figure based on the invoice number )

did the same for IZA

then got the invocie numbers and joined them together

then removed the duplicates

and did a sumifs

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

someone told me this formula but i am not sure if it even tells me the right thing

Hello so two sheets with invoices numbers they are dervied from two different systems and im trying to see which are the missing invoice numbers both have been saved in a separate sheet so sheet 1 is from a system elite

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[kingjet]

ok i will do

 

[kingjet]

someone told me this formula but i am not sure if it even tells me the right thing

Hello so two sheets with invoices numbers they are dervied from two different systems and im trying to see which are the missing invoice numbers both have been saved in a separate sheet so sheet 1 is from a system elite

www.excelforum.com

 

[RoryA]

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

(more) emphasis added.

 

[kingjet]

please delete this thread