Forum Discussion
Formula finding data in one cell but not another
Alessiothegreat Before diving into the formula, may I ask why you are creating separate sheet for each category of plant in the first place. You know you can filter the main data table on demand, without having to create separate sheets.
This is to create an availability list of stock we currently have which regularly gets emailed to clients for them to choose what they want and see what we have in stock. It is much easier for these to be categorised into different tabs.
Thanks
Alessiothegreat Why then not just filter and copy paste into a new sheets and then delete the master table befor emailing?
Otherwise, if you are a MS365 subscriber, the FILTER function could do this also.
As i have created this for my boss and he is not very good on computers so have created this spreadsheet so all he has to do is copy and paste. Also it is alot quicker for the formulas to automatically sort all the data exactly how i want it.
Alessiothegreat Okay! Difficult to diagnose a formula that doesn't seem to work without having the file/data to test on.