I have data that is displayed in a graph. The data does not have much of a range of values. For example 1, 2, 3 4.
When the chart is displayed the Y axis is 0.5 ,1 ,1.5, 2, 2.5 etc...
How would I change the Y axis to whole numbers eg, 1,2,3 etc,,
A B C D
1 Type Colour Sold On
2 Car Red 01/01/2008
3 Car Red
4 Bus Red 01/01/2008
5 Car Green
6 Bus Green
7 Car Red 10/01/2008
8 09/01/2008
I would like to count all of red cars...
A B
1 car red
2 bus red
3 car green
4 car red
I would like to count the number of red cars in the grid.
Could someone help with a formula? (i have used the above as an example however the really one is likley to have hundreds of rows)
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.