Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi experts
I need to look down column Q, R, S and T and find duplicate values for the same month and in a new cell just put a number of times they are duplicated on the same row ill explain, i.e. Q R S T Part 1 Part 2 Part3 Part 4 30.00 30.00 0.00 0.00 So in rows Q - T 30.00 appers twice, so id like cell U e.g. to report the number 2 I hope that makes sense Thanks Derek |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Warning while entering duplicate values in a cell | Excel Discussion (Misc queries) | |||
Why do my cell values/words duplicate themselves over and over? | Excel Discussion (Misc queries) | |||
Preventing user entering duplicate values in a cell range | Excel Worksheet Functions | |||
Count on multiple values with duplicate rows | Excel Worksheet Functions | |||
How do I do count calculations ignoring duplicate values | Excel Discussion (Misc queries) |