{oapdf_gg}
Office software is closely linked to the PDF,the PDF is also must have to control!      Set home Page  Add to Favorites  
You are here:Home > OA application skills > EXCEL skills
EXCEL skills
Excel function application function to find references detailed tutorial (with examples)
Finishing by: Date:2009-04-11 13:08:30 Popularity: Tags:tutorials

first step, because of the need to transpose to the form of multiple cells, so the formula needs to be an array of ways to enter the formula. Therefore, first of all need to transpose the selected scope. We set up home here after the turn of the ranges stored A9.B14.

The second step, click the toolbar used the "Paste Function" icon, there will be "Paste Function" dialog box, in the "Function Category" box, select "Find and quote function" box select TRANSPOSE, at this point in the dialogue box will appear at the bottom of a brief explanation of the function. Click "OK" will pop-up dialog box TRANSPOSE function parameters.


Figure 9

The third step is to choose the scope of the array that is A2.F3

The fourth step, here is an array formula as a result of input required by the CRTL + SHIFT + ENTER key combination to determine the formula for the array at this time will be displayed in the formula "{}". Turn immediately successful, as shown in Figure 10.


Figure 10

more than we introduced the use of Excel's Find function, the flexible application of such functions to reduce duplication of data entry is most helpful. Here only some examples of forward, I believe we will come up with a more practical use in practical applications.
HomePrevious123456789NextEnd
Previous:Excel function application function logic operations detailed tutorial (with examples)
Next:Excel function of mathematics and the application of trigonometric functions Detailed tutorial (with examples)
there isArticle InformationsComment Information
Category column
Ranking Information
Related Articles
Site Help | Site Map | Feedback |
OAPDF.COM Copyright 2009 V1.1