views:

23

answers:

1

Is it possible to find percentile of a) a column called "Country" with text based column values

b) a column called "Salary" with column values either of the following - <=50K, >50K

A: 

Would something along the lines of the below work?

=Countif(A1:A999,<=50000)/count(A1:A999)
Kevin Ross
Use COUNTIFS for the country based text column the same way as above.
ktharsis