Data Search Function Formula
The following are some common data search function formulas: ** 1. VLOOkUP Function ** 1. ** Function * - Finds the specified value in the first column of a table or array of values, and returns the value in the current column of the table or array. 2. ** grammar structure ** - =VLOOkUP(Search value, data table (search area), column number,(matching condition)) - For example, if the search area is B2:E10, the search name is in cell G3, and the assessment score is in column 2, the formula is =VLOOkUP(G3,B2:E10,2,False). - Note: - It could only be searched from left to right, but not in reverse. - The search value must be in the first column of the data table (search area), otherwise an error will be reported. - Special Usage: - When searching for multiple results, you can use VLOOkUP or array usage multiple times. For example, to find the employee's department, birthplace, and salary data, if the name was in the G2 cell, the search area would be A:E, the department would be in the fourth column, the birthplace would be in the fifth column, and the salary would be in the third column. The formula could be used multiple times: Department: = VLOOkUP (G2,A:E,4,0); birthplace: = VLOOkUP (G2,A:E,5,0); salary: =VLOOkUP(G2,A:E,3,0) Using the array usage formula: =VLOOkUP(G2,A:E,{4,5,3},0)(The new version has the array overflow function to directly obtain the result. Without this function, you need to first select the corresponding cell, press the three keys of the array, and press the command button.) - Search for the last record: When the data is a number, the formula is =VLOOkUP(9^9,A:A,1)(the first argument is 9 to the power of 9, you can also write other numbers larger than the number in column A, the fourth argument default fuzzy search); when the data is text, the formula is =VLOOkUP("seat",A:A,1); when the data is mixed, if the requirement is to return whatever the last data is, you need to use the LOOkUP function. - It is used for sum operations, such as the formula =SUM(VLOOkUP(B11,$A$2:$G$8,{2,3,4,5,6,7},0)). By modifying the third argument, query the column of each month, find the corresponding month data, and then sum. ** 2. LOOK UP Function ** 1. ** grammar ** - = look up (find the value in that column and return the result column). For example, to find the number of bananas, if the search value is in the D2 cell, the search area is A2:A5, and the result is B2:B5, the formula is =LOOkUP(D2,A2:A5,B2:B5). - When the data is mixed and the last data is to be found, the formula is =LOOkUP(1,0/(A:A<>""),A:A). ** 3. SUMIF Function ** 1. ** grammar ** - =sumif(condition column, sum condition, sum column). For example, if you want to ask for the number of oranges, if the condition column is A2:A5, the sum condition is in cell D2, and the sum column is B2:B5, then the formula is =SUMIF(A2:A5,D2,B2:B5). ** 4. DGET Function ** 1. ** grammar ** - =dget(data area, column number of the result to be found, search criteria). Note that when selecting data, you must also select the header. For example, if you want to find the data of lemons, if the data area is A1:B5, the result is in the second column, and the search condition is D1:D2, then the formula is =DGET(A1:B5,2,D1:D2). ** 5. DSUM Function ** 1. ** grammar ** - =dsum(data area, the name of the field that needs to find the result, and the search criteria). This function is a database function. All the data in the parameters need to include the header. For example, if you want to find all the data of apples, if the data range is A1:B5, the field name is in the E1 cell, and the search criteria is D1:D2, the formula is =DSUM(A1:B5,E1,D1:D2). ** 6. Summer Function ** 1. ** grammar ** - = sumproduct(first data area, second data area, third data area) and so on. For example, to find the number of apples, if the data area A2:A5 was judged to be equal to D2 (apple type), then multiplied by B2:B5 and then summed, the formula would be = SUMPRODOCT ((A2:A5 = D2)*B2:B5). ** 7. Index+Match Function Formula Combination ** 1. [Description] - It could be said to be an omnipotent screening and search combination. 2. ** grammar structure ** - =Index(Array result column,Match(search value, search area, 0)). For example, according to the employee's "name" to search for the corresponding "assessment results", if the search area is B2:B10, the search value is in the G3 cell, and the result column is C2:C10, first obtain the row number where the query value is through Match(G3,B2:B10,0), and then use the Index function to find the value of the corresponding row in the result column. The formula is =Index(C2:C10,Match(G3,B2:B10,0)). ** 8. XLOOkUP Function ** 1. ** Function * - Searching for a match in a range or array and returning the corresponding item through a second range or array. By default, an exact match is used. 2. ** grammar structure ** - =XLOOkUP(Find Value, Find Array, Return Array, No Value Found, Match Mode, Search Mode). Generally, you only need to set the first three functions. For example, if you want to check Zhao Fei's basic salary, if the search value is in cell G3, the search area is A2:A8, and the return area is D2:D8, then the formula is =XLOOkUP(G3,A2:A8,D2:D8). ** 9. TOCOL function (used to find data samples)** - When searching for data based on multiple conditions, such as searching for salaries based on departments and names, it could be used to compare multiple columns with the given conditions. If they were equal, the value of the corresponding column would be returned. The second argument could ignore the error value to obtain the correct result. It could also be used to list the list of personnel in each department. "Choose" was equally exciting. Everyone was welcome to read it!
Formula for Calculating Data Volume
The units of data volume were Byte (B), Thousand-Byte, and so on. The conversion formula was as follows: 1KB = 2^10B 1MB = 2^20B 1GB = 2^30B 。 At the same time, 1 Byte = 8 bit (bit, b for short). This was the conversion relationship between the basic unit of data processing and the smallest unit. While waiting for the TV series, he could also read the exciting content related to this site!
The Universal Formula of Triangular Function and Inverse Triangular Function
三角函数的万能公式，可以把所有三角函数都化成只有\(tan(\frac{\alpha}{2})\)的多项式，实现将角统一为\(\frac{\alpha}{2}\)、函数名称统一为\(tan\)等作用，具体公式如下： 1. \(\sin\alpha = \frac{2\tan(\frac{\alpha}{2})}{1 + \tan^{2}(\frac{\alpha}{2})}\) 2. \(\cos\alpha=\frac{1 - \tan^{2}(\frac{\alpha}{2})}{1 + \tan^{2}(\frac{\alpha}{2})}\) 3. \(\tan\alpha=\frac{2\tan(\frac{\alpha}{2})}{1 - \tan^{2}(\frac{\alpha}{2})}\) 反三角函数常见公式如下： **一、反正弦三角函数计算公式** 1. 当\(xy\leq0\)或\(x^{2}+y^{2}\leq1\)时，\(\arcsin x+\arcsin y = \arcsin(x\sqrt{1 - y^{2}}+y\sqrt{1 - x^{2}})\); 2. 当\(x > 0\)且\(y > 0\)且\(x^{2}+y^{2}>1\)时，\(\arcsin x+\arcsin y=\pi - \arcsin(x\sqrt{1 - y^{2}}+y\sqrt{1 - x^{2}})\); 3. 当\(x < 0\)且\(y < 0\)且\(x^{2}+y^{2}>1\)时，\(\arcsin x+\arcsin y = -\pi - \arcsin(x\sqrt{1 - y^{2}}+y\sqrt{1 - x^{2}})\); 4. 当\(xy\leq0\)或\(x^{2}+y^{2}\leq1\)时，\(\arcsin x - \arcsin y=\arcsin(x\sqrt{1 - y^{2}}-y\sqrt{1 - x^{2}})\); 5. 当\(x > 0\)且\(y < 0\)且\(x^{2}+y^{2}>1\)时，\(\arcsin x - \arcsin y=\pi - \arcsin(x\sqrt{1 - y^{2}}-y\sqrt{1 - x^{2}})\); 6. 当\(x < 0\)且\(y > 0\)且\(x^{2}+y^{2}>1\)时，\(\arcsin x - \arcsin y = -\pi - \arcsin(x\sqrt{1 - y^{2}}+y\sqrt{1 - x^{2}})\)。 **二、反余弦三角函数计算公式** 1. 当\(x + y\geq0\)时，\(\arccos x+\arccos y = \arccos(xy - \sqrt{1 - x^{2}}\sqrt{1 - y^{2}})\); 2. 当\(x + y < 0\)时，\(\arccos x+\arccos y = 2\pi - \arccos(xy - \sqrt{1 - x^{2}}\sqrt{1 - y^{2}})\); 3. 当\(x\geq y\)时，\(\arccos x - \arccos y = -\arccos(xy + \sqrt{1 - x^{2}}\sqrt{1 - y^{2}})\); 4. 当\(x < y\)时，\(\arccos x - \arccos y=\arccos(xy + \sqrt{1 - x^{2}}\sqrt{1 - y^{2}})\)。 **三、反正切三角函数计算公式** 1. 当\(xy < 1\)时，\(\arctan x+\arctan y=\arctan\frac{x + y}{1 - xy}\); 2. 当\(x > 0\)，\(xy > 1\)时，\(\arctan x+\arctan y=\pi+\arctan\frac{x + y}{1 - xy}\); 3. 当\(x < 0\)，\(xy > 1\)时，\(\arctan x+\arctan y = -\pi+\arctan\frac{x + y}{1 - xy}\); 4. 当\(xy > - 1\)时，\(\arctan x - \arctan y=\arctan\frac{x - y}{1 - xy}\)。 <a href="/?from=ask_words" style="color:red" target="_blank">点击前往免费阅读更多精彩小说</a>
Sixteen Classic Pithy Formula of Dragon Search
The sixteen classic lines of Xunlong were: Dragon Gate opens, dragon qi rises; Dragon Eye observation, dragon breath blows; Dragon scales flash, dragon claws stomp on the ground; Dragon tail swings, dragon horns soar; Dragon roars shake the sky, dragon dance flies; Dragon shadows flash, dragon teeth bite; Dragon wings spread, dragon claws grab; Dragon scales flash, dragon tail curl; Dragon spits flames, dragon eyes shine; Dragon Soars into the sky, dragon scales flash; Dragon might is awe-inspiring, dragon claws stomp on the ground; Dragon roars, dragon horns soar; Dragon wings flap, dragon tail swings; Dragon scales flash, dragon spits cold air; The dragon danced gracefully, and the dragon shadow flashed. These chants described the various movements and forms of the dragon during the process of searching for the dragon, implying that the dragon seeker needed to have the qualities of observation, perception, courage, and wisdom to find the traces of the dragon and come into contact with it. These chants could also be used as a guide for the dragon searching ritual, helping the dragon seeker enter the state and state of mind of the dragon seeker.
Fuji camera data protection function
The match function matches duplicate data.
You can use the Match function in combination with the IF function to identify the duplicate data. For example, in Excel 2013, if there is data in the table, enter the function =IF(Match(C3,C$3:C$18,0)= Rows (A1),"","Repeat") in the cell, and then fill it down to determine whether the data is repeated. The function's parameters Match(C3,C$3:C$18,0)= Rows (A1) are used to determine whether the data is repeated. You can also use Formula =IF(Match(A3,$A$3:$A$17,0)= Rows ()-2,"","Repeat"), enter the Match function formula in the blank cell to the right of the cell data, select the cell containing the formula, and drag the data down. The cell filled with "Repeat" is the repeated cell. "Choose" was equally exciting. Everyone was welcome to read it!
Love novel search function
Take the search function of this novel lover for example. It's super awesome. It can help me find the novel I want quickly. No matter what genre of novel it was, as long as he entered the relevant keywords, he would immediately be able to produce a lot of related novels. This function was especially convenient. It was like having a caring little assistant by his side who could find novels for him to read at any time. "Dao Monarch Shennong" is equally interesting. Everyone is welcome to click and read it!
Baidu homepage search function
The search function on Baidu's homepage was rich and varied. Its basic functions include web search, image search, video search, news search, and so on. In terms of web search, users could enter keywords in the search box and click "Baidu" to get a list of relevant web pages. The results included the title of the web page, summary, and links for the user to choose to click. Image search allowed users to upload images or enter keywords to find related images, which was useful for finding specific images or visual searches. Video search allowed users to enter keywords to search for various video content, such as movies, TV series, Short videos, and so on. News Search allowed users to enter keywords to obtain the latest news and information, and to understand hot events and social trends. In addition, Baidu also had some advanced search functions. For example, Baidu Academic can be used to find academic papers, journal articles, and conference papers, which are of high value to students and researchers; Baidu Translator can perform multi-language translation, input the text to be translated and select the target language to get the result, which is helpful for foreign language learning and international communication; Baidu Map provides map services, which can search for locations, addresses, or business information, and also has navigation functions; Baidu Tieba was an interest-based community platform where users could create and join various Tieba to interact with each other, while Baidu Cloud provided cloud storage services to facilitate users to store and share files. At the same time, in order to improve the search results, users could use precise keywords, use quote marks to match accurately, and use the search filter to filter by time, region, type, etc. They could also pay attention to Baidu's Q & A platform to obtain answers and suggestions for related questions. While waiting for the anime, you can also click on the link below to read the classic original work of " Full-time Expert "!
How to use the search function
The search function is used to find the starting position of the specified search value in the string. The grammar is Search(find_text, within_text, start_nums), where find_text is the character to be found. Wildcards can be used in find_text, including question marks (?) To find the real question mark or star, you need to type a tilde (~) in front of the character;within_text is the text in which you want to find_text;start_numis the number of the character in within_text to start looking for. For example, in a table, you can use the search function by entering a formula in the cell, such as entering = STAR in cell B1.("Month",A1,1), the number displayed in the result indicates that the position of "Month" is located from the first character of the A1 cell string; enter = STAR (A3,A2) in the B2 cell, the number displayed in the result indicates that the content of the A3 cell is located in the position of the A2 cell content; enter = STAR in the B2 cell ("*",A2,1), because the star "*" can represent any string, it returns 1; in cell B2, enter = STAR ("~*",A2,1), if the argument find_text is a question mark or an star, add the "~" symbol and return the corresponding position. In addition, the search function can also be used for some complex operations, such as finding the position of the second specific character in the string (you need to set the start_nums parameters reasonably), counting the number of strings in a specific format (combined with other functions, such as the Count function), extracting a specific part of the content (combined with other functions, such as the Midb function), and so on. "Choose" was equally exciting. Everyone was welcome to read it!
The composition and function of the formula of Sanqing Shengfang Dewetting
In the formula of Sanqing Shengfang oral liquid, Bai Zhu and Dangshen could strengthen the spleen and replenish qi, and supplement the yang qi of the spleen; Fuling had the effect of promoting water and permeating dampness, which could reduce the discomfort caused by the accumulation of moisture in the spleen and stomach; licorice could alleviate the inflammation of the spleen and stomach and increase the overall taste of the prescription. This prescription was mainly suitable for symptoms such as spleen and stomach weakness, spleen and stomach dampness, indigestion, etc. Common symptoms included loss of appetite, etc.
The function and significance of the Taoist Five Thunder Formula
The main function of the Taoist Five Thunder Formula was to dispel evil and treat diseases. The Little Five Thunder was commonly used in this area. It was simple and effective. Judging from the classification of the Five Thunder and the nature of the Five Thunder Chant, it had a restraining effect on evil creatures. For ordinary evil creatures, the power of the ordinary water thunder attracted by the Five Thunder Chant was enough. When facing extremely powerful evil creatures, when many Taoist priests formed the Ten Thousand Thunder Formation to attract many ordinary water thunder, the occasional golden heavenly thunder was the best for the sinful evil creatures. Its significance may be related to the worship of the Thunder God by the ancient people. It was a part of Taoist culture. The Five Thunder Technique had many names, such as the Five Thunder Dharma, the Five Thunder Heavenly Heart Dharma, the Palm Thunder, the Five Thunder Palm, etc. The Five Thunder Technique was the same as other scriptures (such as the Master's Scripture, the Jade Clear Scripture, etc.). It was either related to the worship of gods or related to sects, reflecting the Taoist belief, the system of spells, and the cultural inheritance. In the glorious days of Daoism, there were many mighty figures who could fully execute the true Five Thunder Formula. It was also a manifestation of the prosperity of Daoism and the orderly inheritance of Daoism.