Results 1 to 6 of 6

Count_Question

Threaded View

excelhelp18 Count_Question 02-10-2010, 04:26 AM
Simon Lloyd Re: Count_Question 02-10-2010, 04:30 AM
excelhelp18 Re: Count_Question 02-10-2010, 04:39 AM
DonkeyOte Re: Count_Question 02-10-2010, 05:10 AM
excelhelp18 Re: Count_Question 02-10-2010, 05:41 AM
DonkeyOte Re: Count_Question 02-10-2010, 05:59 AM
  1. 02-10-2010, 04:26 AM #1
    excelhelp18 is offline
    Forum Contributor
    Join Date
    03-18-2008
    Posts
    123

    Red face Count_Question

    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.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1