Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting device
Hello everyone.
Can anyone help me with devise a counting tool that looks through a column on my excel spread sheet and each time the number in the cell is greater than 1, the count increases. Until it reaches the end of the column. The number of rows that will be populated with number will be a variable, and I need the counter to adjust to this. What I mean by this is, that a user will select how many numbers to record in, say, column A. If the user populates 20 rows, then I need my counter to check through each of those 20 cells and tell me how many of these are than 1. If 25 cells are populated then, need it to check through all 25 cells, and so forth. I also need a calculation to be feed out, which tells the user as a percentage how many of cells are greater than 1 in relation to the total number of cells. Any help would be very appreciated. Thank you all in advance. Nazmul Hasan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Device I/O Error | Excel Discussion (Misc queries) | |||
text pc device | Excel Discussion (Misc queries) | |||
Beam a file to a device. | Excel Worksheet Functions | |||
Device I/O Error | Excel Discussion (Misc queries) | |||
Device I/O Error | Excel Programming |