Solid_Gabriel
New Member
- Joined
- Mar 27, 2011
- Messages
- 8
Ok, here's the thing: I have this worksheet, filled with informations about hundreds of equipments, where each one of then occupies a single row. Each row has several informations in some columns, and one of those informations is an alphanumeric code, for example XYZ1A. There are 4 codes like that in total, and I need to count how many devices of each one I have.
I was filtering the worksheet by selecting only the specific code I wanted on the respective column, and trying to use one of the default functions to count the number of cells on that column that had that exact code. But It wasn't working, because it was counting the total number of rows, and not just that specific number of rows I selected.
I mean, there's like a total of 400 rows, begining at row 3 and going up untill 403, for example. When I filtered the list, only some of the rows would appear (let's say, 200 in total) and then I would select all the values that appeared on the column "I", where I was writing the code, and use the function to count how many cells I had selected. But what I got as the result was 400 cells, instead of just the 200 that had the code. So I would like to know what I'm doing wrong.
I was using the 2007 version, but also want it to work on 2003, if possible.
I was filtering the worksheet by selecting only the specific code I wanted on the respective column, and trying to use one of the default functions to count the number of cells on that column that had that exact code. But It wasn't working, because it was counting the total number of rows, and not just that specific number of rows I selected.
I mean, there's like a total of 400 rows, begining at row 3 and going up untill 403, for example. When I filtered the list, only some of the rows would appear (let's say, 200 in total) and then I would select all the values that appeared on the column "I", where I was writing the code, and use the function to count how many cells I had selected. But what I got as the result was 400 cells, instead of just the 200 that had the code. So I would like to know what I'm doing wrong.
I was using the 2007 version, but also want it to work on 2003, if possible.
