Forum Discussion

Copper Contributor

Feb 25, 2021

Formula finding data in one cell but not another

Hi everyone, I am having difficulty trying something new in my formula. How the spreadsheet works up to the point of this formula : A list of plants is entered into a data tab, there are the...

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Feb 25, 2021

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.

Alessiothegreat
Copper Contributor
Feb 25, 2021
Riny_van_Eekelen
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
- Riny_van_Eekelen
  Platinum Contributor
  Feb 25, 2021
  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.
  - Alessiothegreat
    Copper Contributor
    Feb 25, 2021
    Riny_van_Eekelen
    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.