Forum Discussion
Re: Excel formula
Wow, easy as that! But that was just a warm up. So this spreadsheet is results from a survey. To compare different parts....so columns b,c,d,e,f are types of gardens (private, charity etc.), column AE is do they use herbicide (Y or N) How do I work out which how many of each garden type uses herbicide (Y) or doesn’t (N). I guess I just use this formulae then for any other comparisons throughout the sheet to generate graphs? Thanks
5 Replies
Could you attach a small sample workbook without sensitive/proprietary information?
HansVogelaar I’ve sent a basic form of what I’m trying to do, so the type of garden is shown with a 1, herbicide use with a y or n.
See the attached version.
The second sheet has formulas and a chart.
I also added an alternative layout to the first sheet, and a pivot table based on this layout.
