EXCEL data statistics
[Users questions | Browse:33 | Favorites]
Users questions: See attached, and if there are doubts, I will only add the instructions as soon as possible, Thank you for your participation. Thank you for the answer first. May have misunderstood. So (1,0) cells appeared attached, can be viewed as a statistical unit, this unit there is attached the greatest number? (Middle does not allow more than one Figures appear)
Experts answer: finally look to understand your intentions, and you use this request function + helper out of ways to solve, but as the condition increases, supporting columns will be used more, increasing complexity, I try was prepared to give you a custom function, press the following methods: 1, "Alt + F11" or "tool **" macro ** "VisualBasic Editor" to open the VBA editing environment 2, insert ** "module, and then double-click the box to the left of engineering resources," Module 1 "in the right code edit box insert the following code: Functionp inlv (rngAreaAsRange, strQueryAsString) DimintDatasAsInteger 'definition of the data the total number of DimstrTempAsString' definition of temporary string pinlv = 0 'Initial Function returns the value of strTemp = "" 'initialize temporary string intDatas = rngArea.EntireRow.Count' access to data the total number of Fori = 1TointDatas' loop to read data, the temporary string strTe mp = strTemp & rngArea.Cells (i, 1) NextDimjAsInteger 'definition of loop counter j = 1' initialize loop counter WithApplication 'worksheet in the VBA call letters in the string handling Number DoWhileNotIsError (. Find (. Rept (strQuery, j), strTemp)) 'loop to check to 1,0 consecutive combination of the highest frequency pinlv = pinlv +1' assigned to the function return value j = j +1' Loop counter LoopEndWithEndFunction3, completed and returned to the worksheet where you want the results as using the ordinary formula Yi Yang : = pinlv (A2: A51, "10") results for the 4 I made comments in the code, should be well understood, if You ask, "1,2,0" combination of the frequency, modify the formula "= pinlv (A2: A51," 120 ")" can be. Note: 1, custom function, the principle of using a string matching the design, if the data in the presence of more than equal to 10 the number of results may be incorrect; 2 Feeling you this Xuyao very unique, and not what they intend to use local, are not there other modifications or simple ways Oh, solutions to those problems is much more important than the method and Shouduan, I personally think so. Good Luck ~ ~
Experts answer: finally look to understand your intentions, and you use this request function + helper out of ways to solve, but as the condition increases, supporting columns will be used more, increasing complexity, I try was prepared to give you a custom function, press the following methods: 1, "Alt + F11" or "tool **" macro ** "VisualBasic Editor" to open the VBA editing environment 2, insert ** "module, and then double-click the box to the left of engineering resources," Module 1 "in the right code edit box insert the following code: Functionp inlv (rngAreaAsRange, strQueryAsString) DimintDatasAsInteger 'definition of the data the total number of DimstrTempAsString' definition of temporary string pinlv = 0 'Initial Function returns the value of strTemp = "" 'initialize temporary string intDatas = rngArea.EntireRow.Count' access to data the total number of Fori = 1TointDatas' loop to read data, the temporary string strTe mp = strTemp & rngArea.Cells (i, 1) NextDimjAsInteger 'definition of loop counter j = 1' initialize loop counter WithApplication 'worksheet in the VBA call letters in the string handling Number DoWhileNotIsError (. Find (. Rept (strQuery, j), strTemp)) 'loop to check to 1,0 consecutive combination of the highest frequency pinlv = pinlv +1' assigned to the function return value j = j +1' Loop counter LoopEndWithEndFunction3, completed and returned to the worksheet where you want the results as using the ordinary formula Yi Yang : = pinlv (A2: A51, "10") results for the 4 I made comments in the code, should be well understood, if You ask, "1,2,0" combination of the frequency, modify the formula "= pinlv (A2: A51," 120 ")" can be. Note: 1, custom function, the principle of using a string matching the design, if the data in the presence of more than equal to 10 the number of results may be incorrect; 2 Feeling you this Xuyao very unique, and not what they intend to use local, are not there other modifications or simple ways Oh, solutions to those problems is much more important than the method and Shouduan, I personally think so. Good Luck ~ ~
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.