Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting values only once
I have a problem and was wondering if there was a way to solve it that I
havent thought of. I have a column that represents months. It stores then in numeric format, i.e. 1 for January, 2 for February etc€¦ The next column is a reference to a machine, in the format 001/0019 or 005/0041 and so on. Now one machine can come up in the same month more that once. I want a pivot table that shows me the total number of machines in each month, but not count the same machine more that once in any month. I managed this by sorting the two columns first by month then by machine. I then added a third column with the following formula =IF(AND(E2=E3,D2=D3),0,1) so that the month and machine values are compared to the next ones. This works, but the person requesting a solution says he doesnt want the columns sorted. Is there a way to do this without sorting the columns? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting values in one cell based on values in another | Excel Discussion (Misc queries) | |||
counting rows with same values for multiple values | New Users to Excel | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting values between 70 and 140 | Excel Worksheet Functions | |||
Counting Values | Excel Worksheet Functions |