Excel form adds the methodological measure of serial number

  • 时间:
  • 浏览:9
  • 来源:FROMJPG pdf to word

  ExcelOften need to use the function that adds serial number in, is serial number specific how should be added? Mix below small invent the method that studies Excel form to add serial number together, the hope is helpful to you!

Excel form adds the method of serial number

Add serial number measure 1: WillMousePut in unit case right next horn. Circle is in the position, when occurrence “ when 10 “ word, the mouse is drawn below can

Add serial number measure 2: Pure number public errand is 1 increase by degrees, operation and measure one identical. Exclusive distinction is to become when cursor turns “ into 10 ” word, press Ctrl key first, fall next draw a mouse

Add serial number measure 3: Pure number public errand is 1 increase by degrees. For instance, want to fall pull 1, 4, 7, 10……… is shown like plan institute, preexistence the first ordinal input 1, 4. Next two unit case of pitch on graphic representation, what put the mouse in division of pitch on unit is right next horn, the mouse is drawn below can

Add serial number measure 4: If think next pulling to duplicate 1, on 4 foundations in on one pace, be in when cursor of division of pitch on unit right 10 “ of horny occurrence ” when the word, press Ctrl key to fall again first pull, if pursue,be shown as a result.

Add serial number measure 5: Chinese character, the number mixes next pulling the case is pressed below circumstance and simple Chinese character contrary. For example, if want to pull a “ piece 1” , “ piece 2” , “ piece 3” , be in division of unit of cursor pitch on, 10 “ of occurrence ” word, when beginning next pulling, cannot bolt with pressing Ctrl ability goes. If the result pursues

Add serial number measure 6: If think next pulling go out only a series of ” piece 1” comes out, ctrl should be pressed to bolt when beginning next pulling, the result is shown like plan institute

Use opportunely in EXCELFunctionCombination has the computation statistic of much condition

Exemple: The first behavior expresses a head, a row is ” of “ full name, b row is “ class ” , c row is “ChineseAchievement ” , d row is “ admits result ” , want ” of statistical “ class to be “ now 2 ” , ” of “ Chinese achievement is more than be equal to 104, “ admits result ” to weigh the number of this ” for “ . Statistical result deposits the other kind that expresses in this job.

Formula is as follows:

=SUM(IF((B2:B2 " )*(C2:C of 9999= "9999>=104)*(D2:D9999= " weighs this " ) , 1, 0) )

Ctrl+Shift+Enter key is pressed after inputting formula, make it automatic add "{}" of array formula symbol.

How is unit judged in EXCEL whether to include in case appoint text

Assume unit to A1 case undertakes " appoints text " judging having notting have, the following either is formulary all but:

=IF(COUNTIF(A1, "* "&"Appoint text "&"*" )=1, "Have " , "Without " )

=IF(ISERROR(FIND(" appoints text " , a1, 1)) , "Without " , "Have " )

Some area is begged in EXCEL inside not reduplicative data several

Beg A1:A for exampleA number of data does not repeat inside 100 limits, a certain number repeats for many times appear to calculate only. Have method of two kinds of calculation:

It is to use array formula:

=SUM(1/COUNTIF(A1:A100, a1:A100) )

Ctrl+Shift+Enter key is pressed after inputting formula, make it automatic add "{}" of array formula symbol.

2 it is to use function of product sue for peace:

=SUMPRODUCT(1/COUNTIF(A1:A100, a1:A100) )