hi,
i hav a sheet, in which i hav table containing readings of meters. in the
table there several columns like wise serial no., Property ,type, ratings,
accuracy, config. and many more. in config there are two categories. in
rating there are 5-6 categories and in accuracy there are 5-6 categories.
my problem is that i have to find out that in config(any one category), at a
particular Rating (any one category) , in a particular accuracy (it's also
any one category) how many number of consumers.
eg: in a single phase , at a rating of 10-60A, there are how many consumers
having the accuracy between 0to 1%. in this way i have to find out the number
of consumers in every phase at every particular rating, in every particular
accuracy.
i hav tried it formulaes but couldn't make it.
Pls help.