| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to count maximum number of lines repeated for a site
Site# Serial# No. of times repeated
205 12345 4 205 5678 5 205 54785 7 310 65432 4 310 47859 6 Could you suggest with any formula to count maximum number of times a serial number has repeated. For Eg: Site # Serial# 205 54785 310 47859 In the above case, for site# 205 the maximum repeated serial# is 54785 and for site# 310 the maximum repeated serial# 47859. Suggest me with any formula to perform this work. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| maximum repeated value | Excel Worksheet Functions | |||
| Count the number of Lines in a "wrap text"-cell | Excel Discussion (Misc queries) | |||
| Does the Wrap function in excel allow a maximum number of lines? | Excel Discussion (Misc queries) | |||
| Count No. of times Dates are repeated | Excel Discussion (Misc queries) | |||
| how do I count the number of times a word is repeated in a range? | Excel Discussion (Misc queries) | |||
![Igneshwara reddy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
