Forum Discussion
kimee
Sep 27, 2022Copper Contributor
2 Sheets needing to compare and extract different data
I have 2 data sheets that have the data with one having more (Online Shop vs Physical Shop Stock) - I want to write a formula that looks at both and using a unique cell value (stock code) that they ...
dscheikey
Sep 27, 2022Bronze Contributor
Hi I have created a sample document for you in which I have solved your requirements with the FILTER() function. Have a look at the document and see if it can solve your problems.