Hi,
Need your help on the following:
I have a set of data on sites operating with different volts. volts are between 24 & 48.
I have to perform set of criteria's calculation to understand the data more deeply. I have attached a sample set of data but in reality I have around 10000 rows of same.
Criteria's I want to build are:
Sites Count With > 1 24V
Sites Count With > 2 24V
Sites Count With > 3 24V
Sites Count With > 4 24V
Sites Count With > 1 48V
Sites Count With > 2 48V
Sites Count With > 3 48V
Sites Count With > 4 48V
and some other more...I have given the desired output view also.. I need to have same output through some excel formulea. Right now, I have calculated this manually.
Thanks a lot in advance.
Bookmarks