| Back to logs list

45544 2009 年 11 月 13 日 23:18 Reading (loading. ..) Comments (1) Category: Personal Diary
When the dust had memory is opened,burberry handbags, when the memories come to mind scenes.
who will go then who is right regardless of who who do not.
time,handbags online, let us a little bit old, self-willed to be a little bit on forever.
time,burberry bags, so we have a new outlook on life and values. With the re-understanding of life.
when we are sorry to have to miss, we have a new life.
reality,mulberry bag, after all,handbags online cheap, can not escape the conclusion that a silent.
reason for no reason, maybe God, let go, and does not fit all the put down.
memories, those who have lost,paul smith bag, irretrievably, had been into the past.
no one can turn back the time, but memories can become the eternal memory.
an Excuse me, one I want you to be the heart of eternal mark.

- Qzone log


| Back to logs list

45544 2009 年 09 月 01 日 23:36 Reading (loading. ..) Comments (2) Category: Personal Diary
life,handbags online cheap, half color,burberry bags, half gray.

work, half of the pressure,paul smith bag, half of anxiety.

families, half of care, half indifference.

friends, half happy, half of the barrier.

feelings, half blurred, half of regret and.

dream, half good and half away.

reality, half of the cruel, half escape.

half of the other half, a trace of sadness, a trace of frustration.

than youth without any regrets,designer handbags online, but the time like water.

kept in time, unable to retain youth.

Youth say no regrets
can dream of a burning flame, was a little cruel reality indelible.

walked along the road, a little bit of time wasted,paul smith sale, but, how far away from us the dream, the pursuit of how beautiful things in the end.

Unknown ... ... ... ... ... ... ... ... ... ...

breaks to stay, and I feel temporarily stranded.

make me crazy again, so I have no regrets again.

for the wrong,paul smith wallet, and wrong to wait until when the old rocking chair sitting in the setting sun, nothing better to do when conclusion, would not Miya.

,mulberry bag

| Back to logs list

45544 2009 年 07 月 27 日 11:28 Reading (loading. ..) Comments (0) Category: Personal Diary
Who that song is not the red dust of youth,mulberry bags, who says Google is not fashionable and dynamic Red,mulberry handbags!
to listen to a song waking the latest original Red rap and singer with the appropriate voice to perfection,paul smith bag!
clear pronunciation,handbags online, extraordinary rap skills,burberry bags, but also can be the original red song to sing.





dynamic music label China a perfect

published cancel



| Back to logs list

,red wing heritage boot

| Back to logs list

Reprinted from 270728172 at 14:20 on February 5,red wing boot store, 2008 Reading (loading. ..) Comments (3) Category: Resource Sharing








| Back to logs list

| Back to logs list

44831 2010 年 11 月 19 日 04:03 Reading (loading. ..) Comments (4) Category: smile sweet
I get the atmosphere seems to be a little awkward This is not my intention, but I always fool enough to put things up ...

I do not want to hurt any one I love and I would rather hurt their own ..

once said that if that person is worth, I would like to love like never been hurt, but unfortunately things just can not get my way. It does not matter, really does not matter. I think everything will be fine ...

want a person to travel and see the sea,designer handbags, wanton cry, to vent out all the unhappy, the original repressed for a long time to forget how to weep, it is very painful thing.

heart, a moment or a dull pain in the middle of the night last year, today, I thought my life would never be the same, and now to say that he feels ironic, but a year's time, people have changed, and Oh, this is life, you are not experienced, how to grow. thank those who let me grow, who are you taught me to be strong, be a man you taught me how to live,paul smith uk, so no hate, and learned to Thanksgiving.

like that sentence, as long as has been going good, happiness will be close to me. there is so much pain around me, thank you always pet my God, I can no heart happy alive. world is so big, you have been around me to meet.

stop for the Q's signature to express a mood to write what they think are so pale and weak, camouflage is not so easy, obviously still worried about, yet they show have forgotten, and obviously I liked it, but pretended do not matter,alexa mulberry, why people sometimes can be so ########, just to let people see through the thing? I really do not know, maybe a little bit to keep the last pride and stubbornness.

I love you, you love her she loved him he loved her ... This is what I now hear the lyrics,mulberry bag, there are so many life is not perfect, you do not love your love,mulberry bags, your love do not love you, But the day was too ah ...

happen to you if I love you, love me, well, till the end ...





PS: Here in this diary I wrote last year, today is your chance to delete it so that others reproduced in recovering lost memories I put here as a memorial.
reproduced self at 16:34 on October 17, 2009 read (3) Comments (0) Category: smile sweet
; ; ; Past and Present
who is in a shadow, who is in the wheel of life, past life of the dust,burberry bags, present in the wind, soul and spirit of endless grief. I look back to see their own path of growth, one day at a wait and see, I stand by the roadside on his hands in his coat's pocket to see many people from my side walked impassively, occasionally some people to stop and smile for me, Canruo peach. I know these people will eventually stay down into the warmth of my life to see them, I would think stubbornly persists.

you make me feel warm your lonely season in so I'm not alone. are you God when I need help in general appear. is there you have been flickering in my world. the original The best on the side not left.
as they say I will be happy now that you really made me happy
I wish everyone
Chuaizhuo as happy as the flowers, the ...
joy and sorrow does not stop not to ......

PS: If you see the shadow in front, do not be afraid, it is because the sun behind you the road ahead is paved with both thorns holding my hand and walk together ...

| Back to logs list

47021 2010 年 09 月 07 日 23:45 Reading (loading. ..) Comments (0) Category: Personal Diary
1. I came quietly, and quietly go, a wave of daggers, leave no one to live
2. comparative study, the rise of their own look
3. No way out for a hero, rogue does not look at age
4. Way indignant roar, roar End and went on
5. No not to take the air wall, not hanging in the beams can not be
6. Confucius said: do not sleep at noon, afternoon crash! Mencius said: Confucius said, right!
7. hold your hand, the child away! If children go away to shoot dizzy!
8. he big to be bad? Extinction of the dinosaurs is not still!
9. 忽悠 child is, parents education; children 忽悠 parents called cheating; each flicker called generation gap.
10 Do not tell me about feelings, hurt money.
11. Love is devoting himself to the whole body into, and then a hundred thousand turn back to extricate yourself!
12. couple is among the most contradictory place where the future of fantasy with each other, but always thinking about each other's past.
13. have not had time to philandering, to be plucked out.
14. hero becomes a prisoner, I am not a hero, so I had to turn off the beauty.
15. man's brain like a woman's heart, but the eyes like a woman's appearance.
16. women like looks nasty man, not like the long-broken man.
17. re-energized, or salted fish
18 I'm not a prince, why do I always think they met the girl should be the Princess
19. Marriage is to give freedom to wear pieces of cotton, activities inconvenient, but it will be very warm
20. Knowledge is like underwear, invisible but very important.
21. as a typical failure, you were so successful.
22. the boss when you're using your talents, do not you cut the time to become a man!
23. together for a long time will be minutes, hours will be together a long time; drink will be crazy, every wine will drink
24. Do you have any unhappy things? Say it to make us happy
25. in front of the Chinese team, wearing the yellow jersey of Thailand has also been a trance style of Brazil.
26. Women are made of water, mud men, and Lee Jun-ki Li are cement do
27. pub is to find exciting men and women, most of the trained stimulus
28. length of a sample, please do not blame the dog buns to follow
29. When the pants lost the belt, and understand what is called a dependency.
30. smoke do not toe the line, so we
31. When a man meets a woman, since only the Day, not Independence Day.
32. Close your eyes, I see my future ......
33. grievances can be told, it will not be wronged; to take away the love, it is not love.
34. wide sea diving, broken drum fancy hammer.
35. unable to extricate themselves, in addition to love, there are other places in the turnip.
36. A diamond is forever, one to bankruptcy!
37. Where is the fall to where to lie down.
38. explanation is to cover up,burberry handbags, cover up that story!
39. fell, got up and cry.
40. You make me roll, I roll, you let me come back, sorry, I'm far away,handbags online cheap!
41. ugly have to fall in love again, talking about the world is full of love!
42. farmer uncle the corn planted in the ground in the autumn harvest in the spring I put a lot of corn planted in the ground where her husband, now fall to, tut, actually dead!
43. my wife said to see lightning,burberry bags, I took a kitchen knife cut wires! Crazy ~ ~ Journey to the West tells us, the background of the monster will be rescued by the leadership, no background was only a wreck die!
44. I said: have a life outside work! So, my wife told me that you can have. So: I have to work overtime!
45. If a bad mood, go to the supermarket tweak instant noodles!
46. The world is ours, and also the kids, but sooner or later, that bunch of grandchildren!
47. and then others in the world I call your name sent to the stew and let MOPPER Mop, spray you to death
48. Whenever a difficult time I would read Scriptures:
49. good is to feel hungry, I eat meat does not bia ji mouth!
50. no Han Han's life has had the disease ... the son of his daughter would not eat fat food ...
51. someday your name will appear in the account of this on my home!
52. will pay to think about than the pay, well, want to live.
53. lived for twenty years, not for the motherland, do something for the people, each thinking of this, heartbroken.
54. I fight fat, almost no sacrifice
55. Living Well, is born, to live ~ ~
56. ship collision with bridge natural Shen ~ ~
57. When you put on a wedding dress I put on a robe ~ ~
58. I pray with Jesus, practical and stable life, he then said, let's first talk about peace in the world do it ...
59. love me to say it out loud Come on! hate my life keeping everything on it!
60. Taking advantage of the young talented bad thing to have done it, not years.
61. Have you ever said to me, will always love me, love this stuff I see, but always what is?
62. year-old boy is the most feared creatures on the planet, they have a curiosity, mobility, destructive, and
63. were you in its word - and I say pay back the money not pay back the money!
64. summer is not good, even when the poor did not have to drink the northwest wind, fortunately, is now the autumn.
65. Although I believe eachother, but may not believe you ah ~ ~
66. Where I can not let go, It is because I have not a ~ ~
67. special people never say that they in particular, for example, me.
68. I have two things in life just will not 2 1 then it will not
69 .** comfortable, at ease not **~~
70. I know All good things banquet,mulberry bag, but, at least, feast on the cool I want to eat!
71. and people are not polite will be able to get along!
72. I wanted to be a problem teenager, but I do not follow rules to live for so many years.
73. who delayed me for a while, I let him regret it for life.
74. closed a month, do not call me, call me because I would have come out of a ... ...
75. taxi driver, the driver of the fighter, oh yeah!
76. thinking of how far you go away!
77. Zhuge Liang before coming out with a soldier did not, ah, you want me to have work experience Pingsha !!!
78. the work of the highest state is watching other people work, led the wages of others.
79. fat and haggard with ~ ~
80. Yasuo you to quit when ever consider the feelings of 哆 啦 A Dream,handbags online! (Prime Minister of Japan announced his resignation last year, when the writing)
81. my style and bold, well head and at ease, taste excellent but hard-working self-examination, faults, we also hope Haihan!
82. Get out of here, non-stop rolling ... ...
83. a man who must be a bounce.
84. I rushed my cat on you into your dark room.
85. The greatest tragedy is not young, still in acne.
86. Our aim is to: Serve the People!
87. long time no one to leather was blowing so delightful!
88. -------------- simple secret of longevity to keep breathing, do not breathe ~ ~
89. the money you really that important? told more than 3 hours a penny does not drop.
90. killed I do not say that you do not make honey trap!
91. so I have money, I bought a bus, take the special bus lanes, dedicated bus stopped at the station, so someone wants to get on the train,mulberry bags, I say: Sorry, this is the private car ~ ~
92. A: perfect people, how do you say this is Shiquan eight U.S. ~ ~ B: What are the two that I'm missing the United States? A: Internal and External

Clerk Finance can be used. - Qzone log


| Back to logs list

Reprinted from 819898 at 5:10 p.m. on August 10, 2010 Read (loading. ..) Comments (0) Category: Personal Diary
Word trick:
one, enter the three \Third, enter the three \CHOOSE (WEEKDAY (I3, 2), \; show of the week
Excel common functions Daquan

1, ABS function
function name: ABS
main functions: the absolute value of the corresponding figures obtained.
using the format: ABS (number)
Parameter Description: number to be requested on behalf of the absolute value or reference cell.
Example: If cell B2 enter the formula: = ABS (A2), in both cell A2 enter a positive number (eg 100) or negative (eg -100), B2 in both show positive (eg 100).
to remind: If the number parameter is not numeric, but some characters (such as A, etc.), then the error value is returned B2 \
2, AND function
function name: AND
main functions: to return the logical value: if all parameters are the logical \logical \
using the format: AND (logical1, logical2, ...)
Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Example: enter the formula in cell C5: = AND (A5> = 60, B5> = 60), confirmed. If the C5 return TRUE, shows the value in A5 and B5 were greater than or equal to 60, if return FALSE, that the values in the A5 and B5 at least one of less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value \
3, AVERAGE function
function name: AVERAGE
main functions: Find the arithmetic mean of all parameters.
using the format: AVERAGE (number1, number2, ... ...)
Parameter Description: number1, number2, ... ...: to request the reference value or the average cell (area), the parameter does not exceed 30.
Application examples: in B8 cells enter the formula: = AVERAGE (B7: D7, F7: H7, 7,8), is confirmed,red wing shoes outlet, you can find the area B7 to D7, F7 to H7 area values and average of 7,8.
to remind: If the reference area contains \
4, COLUMN function
function name: COLUMN
main functions: display the column label reference value of the cell.
using the format: COLUMN (reference)
Parameter Description: reference to reference cell.
Application examples: In the cell C11 enter the formula: = COLUMN (B11), confirmation is displayed as 2 (the B column).
to remind: If cell B11 enter the formula: = COLUMN (), also shows that 2; with the corresponding label value and a return line of the function - ROW (reference).
5, CONCATENATE function
function name: CONCATENATE
main functions: the number of characters in text or data in a cell together, displayed in a cell.
using the format: CONCATENATE (Text1, Text ... ...)
Parameter Description: Text1, Text2 ... ... the need to connect the characters of text or reference cell.
Application examples: In the cell C14 enter the formula: = CONCATENATE (A14 ,\characters and. com connection as a whole, appears in cell C14.
to remind: If the argument is not a reference cell, and the text format, please give the English state parameters with double quotes, if you change the formula: = A14 &\. com \
6, COUNTIF function
function name: COUNTIF
main features: a range of cells that meet specified statistical criteria the number of cells.
using the format: COUNTIF (Range, Criteria)
Parameter Description: Range on behalf of a range of cells to statistics; Criteria that specify the conditional expression.
Application examples: In the cell C17 enter the formula: = COUNTIF (B1: B13, \the number of cells.
remind: to allow a range of cells referenced in the blank cells appear.
7, DATE function
function name: DATE
main functions: the values given in the specified date.
using the format: DATE (year, month, day)
Parameter Description: year value for the specified year (less than 9999); month for a specified number of months (can be greater than 12); day for a specified number of days .
Application examples: In the cell C20 enter the formula: = DATE (2003,13,35), confirmation, show 2004-2-4.
reminded: As the above formula, the month is 13, more than a month, postponed to January 2004; 35 days, compared with January 2004 the actual number of days the addition of 4 days, it is also extended to 2004 on February 4.
8, the function name: DATEDIF
main functions: calculate the difference between returns two date parameters.
using the format: = DATEDIF (date1, date2, \a date, date2 on behalf of a date later; y (m, d) asked to return to the annual difference between the two dates (month, day) number.
Application examples: In the cell C23 enter the formula: = DATEDIF (A23, TODAY (), \, and returns the number of years difference.
reminded: This is a hidden function in Excel, is found in the Function Wizard, you can use direct input for the calculation of age, length of service and so very effective.
9, DAY function
function name: DAY
main functions: Find the reference to a specified date or the date the cell number of days.
using the format: DAY (serial_number)
Parameter Description: serial_number on behalf of the specified date or reference cell.
Example: enter the formula: = DAY (\
to remind: If the given date, include double quotation marks in English.
10, DCOUNT function
function name: DCOUNT
main functions: to return a database or list of columns to meet the specified conditions and the number of cells that contain numbers.
using the format: DCOUNT (database, field, criteria)
Parameter Description: Database statistics said the need for a range of cells; Field said that the data used in the function list (must be marks on the first line item); Criteria include Conditions range of cells.
Application examples: Figure 1 shows, in cell F4, enter the formula: = DCOUNT (A1: D11, \or equal to 70, while the value is less than 80 the number of cells (equivalent to the number of fractional section).

to remind: If you modify the above formula: = DCOUNT (A1: D11,, F1: G2), can also achieve the same purpose.
11, FREQUENCY function
function name: FREQUENCY
main functions: to return to a vertical array of data in an area frequency distribution.
using the format: FREQUENCY (data_array, bins_array)
Parameter Description: Data_array that used to calculate the frequency of a set of data or range of cells; Bins_array that separated the front of an array of values.
Application examples: as shown in Figure 2, while selected range of cells B32 to B36, enter the formula: = FREQUENCY (B2: B31, D2: D36), enter the complete press \key to confirm, you can find the B2 to the B31 area, according to D2 to D36 region separated values of the frequency of the number of segments (equivalent to the number of statistical segments of the score).

reminded: The input is an array formula, you're finished, you need to by pressing \({}), the braces can not be directly input.
12, IF function
function name: IF
main functions: According to the logic of the conditions specified in the true and false results, return the corresponding content.
using the format: = IF (Logical, Value_if_true, Value_if_false)
Parameter Description: Logical representative of logic expressions; Value_if_true that determine the conditions when the logical \TRUE \
Application examples: In the cell C29 enter the formula: = IF (C26> = 18, \the C29 cell displays \
remind: this article, similar to the \the corresponding cell,red wing sale, please refer to the specific instance of the file attached.
13, INDEX function
function name: INDEX
main functions: to return a list or array element value, this element by the row number and column number of the index values determined.
using the format: INDEX (array, row_num, column_num)
Parameter Description: Array on behalf of a range of cells or an array constant; Row_num that the specified line number (if omitted row_num, there must be column_num); Column_num that the specified column number (if omitted column_num, you must have row_num).
Application Example: Figure 3 shows, the F8 cell enter the formula: = INDEX (A1: D11, 4,3), confirmed the show range of cells A1 to D11, the first 4 rows and the intersection of three cells (ie, C4) in the content.

remind: line number argument here (row_num) and column number parameter (column_num) is relative to the terms of reference of the range of cells, not Excel worksheet rows or columns in the sequence number.
14, INT function
function name: INT
main functions: the value rounded down to the nearest integer.
using the format: INT (number)
Parameter Description: number expressed the need for rounding numeric values or include a reference cell.
Example: enter the formula: = INT (18.89), confirmation shows 18.
remind: when in the rounded, without rounding; If you enter the formula = INT (-18.89), the result is returned to -19.

15, ISERROR function
function name: ISERROR
main functions: to test the functional return value for errors. If wrong, the function returns TRUE, otherwise returns FALSE.
using the format: ISERROR (value)
Parameter Description: Value that need to test the value or expression.
Example: enter the formula: = ISERROR (A35/B35), confirmation, if the B35 cell is empty or \
reminded: This function is usually associated with supporting the use of IF functions, if you modify the formula: = IF (ISERROR (A35/B35 ),\the cell appears empty, otherwise display A35/B35
results.
16, LEFT function
function name: LEFT
main functions: a text string from the first character, the interception of a specified number of characters.
using the format: LEFT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A38 \characters.
reminded: This function name in English means \
17, LEN function
function name: LEN
main functions: the number of characters in text string Statistics.
using the format: LEN (text)
Parameter Description: text, said text string to statistics.
Application example: assume that the cell holds the A41 \
reminded: LEN to statistics, whether in full-width characters, or half-width characters, each character are counted as \\
18, MATCH function
function name: MATCH
main functions: to return in the specified manner that matches the specified value of the corresponding elements in the array position.
using the format: MATCH (lookup_value, lookup_array, match_type)
Parameter Description: Lookup_value representatives need to look at the data sheet value;
Lookup_array that may contain the values you want to find a continuous range of cells;
Match_type find the way that the value of (-1,0 or 1).
match_type to -1 if, find the smallest greater than or equal to lookup_value value, Lookup_array must be in descending order;
If match_type to 1, less than or equal to lookup_value find the maximum value, Lookup_array must be sorted in ascending order ;
If match_type 0, find the first value is equal to lookup_value, Lookup_array can be arranged in any order; If omitted match_type, the default is 1.
Application examples: Figure 4 shows, in cell F2 enter the formula: = MATCH (E2, B1: B11, 0), confirmed the results returned to find \

reminded: Lookup_array can only be one column or row.
19, MAX function
function name: MAX
main functions: Find the maximum value in a set of numbers.
using the format: MAX (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the maximum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MAX (E44: J44, 7,8,9,10), confirmed to display the E44 to the J44 cells and in the region and the maximum value 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
20, MID function
function name: MID
main functions: a text string from the specified position, and the interception of a specified number of characters.
using the format: MID (text, start_num, num_chars)
Parameter Description: text represents a text string; start_num that specifies the starting position; num_chars that number to be intercepted.
Application example: assume that the cell holds the A47 \\
remind: the formula of the parameters, use the English state of the comma \
21, MIN function
function name: MIN
main functions: Find the minimum value in a set of numbers.
using the format: MIN (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the minimum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MIN (E44: J44, 7,8,9,10), confirmed to display the E44 to the J44 cells and in the region and the minimum values 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
22, MOD function
function name: MOD
main functions: Find the remainder of dividing two numbers.
using the format: MOD (number, divisor)
Parameter Description: number representative of the dividend; divisor on behalf of the divisor.
Example: enter the formula: = MOD (13,4), confirmed the results show that \
to remind: If the divisor parameter is zero, then the error value \.
23, MONTH function
function name: MONTH
main functions: Find the reference to a specified date or the date cell of the month.
using the format: MONTH (serial_number)
Parameter Description: serial_number on behalf of the specified date, or reference cell.
Example: enter the formula: = MONTH (\
to remind: If the given date, include double quotation marks in English; if you modify the formula: = YEAR (\
24, NOW function
function name: NOW
main functions: given the current system date and time.
using the format: NOW ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = NOW (), immediately after confirmation showing the current system date and time. If the system date and time changed, just click the F9 function key, you can let it change.
reminded: display the date and time format, you can re-set the cell formatting.
25, OR function
function name: OR
main functions: to return a logical value, only if all parameter values are logical \Otherwise, return a logical \
using the format: OR (logical1, logical2, ...)
Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Application examples: In the cell C62 enter the formula: = OR (A62> = 60, B62> = 60), confirmed. If C62 is returned TRUE, A62 and B62 in that at least one value greater than or equal to 60, if the return FALSE, that the values in A62 and B62 are less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value \
26, RANK function
function name: RANK
main functions: to return a numeric value in a column in the ranking relative to other values.
using the format: RANK (Number, ref, order)
Parameter Description: Number values to sort the representative; ref numerical order in which the representatives of a range of cells; order on behalf of sort parameters (if it is \ignored, according ranked in descending order, the larger the number, the smaller the value of ranking results; if non-\
Example: If cell C2 enter the formula: = RANK (B2, $ B $ 2: $ B $ 31,0), D 1 can be derived after confirmation of language students in his class ranking in the results results.
remind: In the above formula, we let the Number parameter to a relative reference to the form, and let the ref parameter to the absolute reference in the form (adding a \mouse over the lower right corner of the cell, into thin cross-linear (usually called the \complete ranking scores of other students language statistics.
27, RIGHT function
function name: RIGHT
main functions: a text string from the last character in the beginning, the interception of a specified number of characters.
using the format: RIGHT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A65 \characters.
reminded: Num_chars parameter must be greater than or equal to 0, if omitted, the default it is 1; num_chars parameter is greater than if the length of the text, the function returns the entire text.
28, SUBTOTAL function
function name: SUBTOTAL
main functions: to return a list or database subtotals.
using the format: SUBTOTAL (function_num, ref1, ref2, ...)
Parameter Description: Function_num 1 to 11 (includes hidden values) or 101-111 (ignores hidden values) between the figures for What is the function specified in the list with subtotals calculated (Figure 6); ref1, ref2, ... ... on behalf of regional or subtotals to be a reference to not more than 29.
Application examples: as shown in Figure 7, the cells in the B64 and C64, respectively, enter the formula: = SUBTOTAL (3,red wing store, C2: C63) and = SUBTOTAL103, C2: C63), and will hide the line 61, after confirmation The former appear as 62 (including the hidden rows), which appears as 61, not including the hidden rows.


to remind: If you take automated screening, no matter what type function_num parameters are chosen, SUBTOTAL function ignores any screening results are not included in the line; SUBTOTAL function is applied to the data columns or vertical area, does not apply to row or level area.
29,red wing work boots, the function name: SUM
main functions: the calculation of all parameters and values.
using the format: SUM (Number1, Number2 ... ...)
Parameter Description: Number1, Number2 ... ... need to calculate the representative value may be a specific value, a reference cell (area), logical values and so on.
Application examples: as shown in Figure 7, in the cell D64 enter the formula: = SUM (D2: D63), confirmed the language of the score can be calculated.
to remind: If the argument is an array or reference, only one of the numbers will be calculated. Blank the array or reference cells, logical values, text or error values are ignored; if you modify the formula: = SUM (LARGE (D2: D63, {1,2,3,4,5})), you can find the top 5 results and.
30, SUMIF function
function name: SUMIF
main functions: to meet specified conditions for calculating the value and the range of cells.
using the format: SUMIF (Range, Criteria, Sum_Range)
Parameter Description: Range to determine the range of cells representative of conditions; Criteria for the specified conditional expression; Sum_Range need to calculate the value representative of where the range of cells.
Application examples: as shown in Figure 7, in the cell D64 enter the formula: = SUMIF (C2: C63, \.
to remind: If you modify the above formula: = SUMIF (C2: C63, \Because it is text-based, needs to be placed under the English double quotes (\
31, TEXT function
function name: TEXT
main functions: the value specified format according to the corresponding number into text form.
using the format: TEXT (value, format_text)
Parameter Description: value to convert the value on behalf of or reference to the cell; format_text for the specified text in the form of digital format.
Example: If the B68 cell preservation values 1280.45, we enter the formula in cells C68: = TEXT (B68, \
reminded: format_text parameters under the \
32, TODAY function
function name: TODAY
main functions: given the system date.
using the format: TODAY ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = TODAY (), confirm that immediately after the system date and time display. If the system date and time changed, just click the F9 function key, you can let it change.
remind: the date format displayed, you can re-set the cell format (see annex).
33, VALUE function
function name: VALUE
main functions: the value of a text on behalf of the string is converted to numeric type.
using the format: VALUE (text)
Parameter Description: text-based representatives need to convert the text string value.
Example: If the B74 cell function is the interception by LEFT and other text-based strings, we enter the formula in cells C74: = VALUE (B74), confirmed, can be converted to numeric.
to remind: If the text type value is not a result of these conversions, the use of the function to deal with these values, often returns error.
34, VLOOKUP function
function name: VLOOKUP
main functions: the first column in the data table to find the specified value, and thus returns the current row in the table at the specified column value.
using the format: VLOOKUP (lookup_value, table_array, col_index_num,red wing mens boots, range_lookup)
Parameter Description: Lookup_value representatives need to find value; Table_array representatives need to find data in which the range of cells; Col_index_num in the region to be returned table_array match the value of the column number (when Col_index_num is 2, the return table_array values in column 2, 3, the return value of column 3 ... ...); Range_lookup is a logical value, if it is TRUE or omitted, the return approximate match, that is, if can not find an exact match, it returns the maximum value of less than lookup_value; If FALSE,red wing motorcycle boot, it returns an exact match, if not, it returns the error value # N / A.
Application example: see Figure 7, we enter the formula in cell D65: = VLOOKUP (B65, B2: D63, 3, FALSE), confirmed, as long as the cell B65, enter a student's name (such as D 48), D65 cells showed immediate results of the student's language.
reminded: Lookup_value must Table_array see the first column of the region; if ignored Range_lookup parameters, Table_array the first column must be sorted; the Wizard in this function, the Range_lookup parameter usage is wrong.
35, WEEKDAY function
function name: WEEKDAY
main functions: the date given corresponds to the specified number of weeks.
using the format: WEEKDAY (serial_number, return_type)
Parameter Description: serial_number on behalf of the specified date or dates of that contains the cell references; return_type representation on behalf of weeks [when the Sunday (Sunday) to 1, Saturday (Saturday ) is 7, this parameter is 1; when Monday (Monday) 1, Sunday (Sunday) to 7, this parameter is 2 (this is in line with the Chinese habit of); when Monday (Monday) to 0 , Sunday (Sunday) to 6, this parameter is 3].
Example: enter the formula: = WEEKDAY (TODAY (), 2), confirm the system date is given after the number of weeks.
to remind: If the specified date, please put the English under the double quotes, such as = WEEKDAY (\
one. Select a color effect to the cell form, format - conditional formatting, conditions, select the \


1. interlacing color effect (odd row colors):
= MOD (ROW (), 2) = 1
2. interlaced color effect (even row colors):
= MOD (ROW (), 2) = 0
3. If you want to set the format for each application of a shading line 3, you can use the formula:
= MOD (ROW (), 3) = 1
4. If you want to set different odd and even column shading, as long as the formula of the ROW () to COLUMN () can, such as:
= MOD (COLUMN (), 2)
5. If you want to set chess checkerboard shading (white + custom color):
= MOD (ROW () + COLUMN (), 2)
Description: The conditional formatting formula used to determine the line number and column number and the remainder is divided by 2 to 0. If 0, indicating the number of rows and columns of the same parity, then fill the cell to the specified color, or not filled. In the conditional formatting, the formula results to return a number, non-0 numbers is the TRUE, 0, and the error value is FALSE. Therefore, the above formula can be written as:
= MOD (ROW () + COLUMN (), 2) 0
6. If you want to set the chess checkerboard shading (custom colors + custom color):
add style 2:
= MOD (ROW () + COLUMN (), 2) = 0
II. Color filter can
excel2007 cell color, font color or icon to be sorted.
If excel2003, need to add auxiliary column, the name of the method defined by the color of the corresponding number, then the secondary sort column:
color cell in column A, select B1, Insert -> Name - > definition, input a, input the following formula = get.cell (24, $ a1),
this method get the serial number of the font color. B1 enter = a copy the formula down to the appropriate line.
the full table can be sorted by column B. If want to get the background color of the serial number will be changed to 63 to 24.
== \into the name to use
2.Get.Cell (Num, Cell) is the function of the form, Get.Cell can get a cell in a variety of information, such as frame format, etc., Num is specified to obtain the kind of information, 24 out this function is to let the color information unit, taken out after a 1-56 number to represent color number
3. B1 column if you enter your name and fill out the definition, then A1 B1 in the figure is the color code, B2 is A2 in the figure will be the color code, and so
4. Now you press the B column sort, in fact, according to color sort column A the.
attached Get.Cell the meaning of each parameter:
1 refer to the absolute address cell reference cells
2 No.
3 column reference column number cell similar
4 TYPE function
5 with reference to the text contents of the address
6 shows the light formula
7 with reference to the address format of the address, text display text display
8 format
9 with reference to the address to return extra storage box left style, figures show
10 extra storage box on the right to return the style, the figures show
11 store extra return on the style side box, digital display
12 frame side return the extra storage under the style, number of Show
13 returns the internal drawings, figures show
14 locked if the cell is set to return True
15 is hidden if the formula returns True
16
returns the width of the cell 17 points as the unit returned to the cell height
18 point font name
19 to return the font size for the unit cell all
20 or if a character is bold return True
21 If all or a cell in italics the first character returns True
22 If all or a cell first character is a single bottom line returns True
23 if the cell or the first characters of all the middle of a horizontal line font Returns True
24 returns the first character color cell number, 1 to 56. If set to automatic, returns 0
25 MS Excel does not support the outline format
26 MS Excel format does not support the shadow figures
27 insert page breaks manually set the outline of the column
28 Outline of the field-level
29
30 if the level of the outline summary of the range compared to True
31 if the range is the outline of the summary column was True
32 shows the workbook and worksheet name of the
33 If the cell formatting for multiple lines of text compared to True
34 extra storage box on the left to return the color, figures show. If set to automatic, returns 0
35 extra storage box on the right to return the color, figures show. If set to automatic, returns 0
36 extra storage box at the top to return color, figures show. If set to automatic, returns 0
37 return save extra box below the color, figures show. If set to automatic, returns 0
38 cells future returns shadow colors, figures show. If set to automatic, returns 0
39 returns the cell back shadow color, figures show. If set to automatic, returns 0
40 text display cell style
41 returns the address of the original equation reference
42 points as the unit returned to the use of the left window on the left to the level of cell Distance
43 in points in the top of the window to return to using the cell above the vertical distance
44 in points in the window on the left to return to the use of a cell to the right of the horizontal distance
45 points unit returns to the top of the window used in the cell below the vertical distance
46 are inserted comments if the cell returns True
47 if the cell has to insert a sound prompt return True
48 are inserted into the formula if cell Returns True
49 if the cell is an array formula returns the range of returns True
50 cell vertical alignment, the figures show
51 perpendicular to the direction of the cell returned, figures show
52 pass back to the cell prefix character
53 text display shows the contents of the cell returned
54 returns the name of the PivotTable cell
55 returns the cell in the PivotTable pivot position
56
57 If all or a cell first character is superscript text return True
58 shows return of all or a cell font style
59 characters return the cell bottom line style, the figures show
60 If all or a cell for the first character subscript returns True
61 pivot
62 shows the workbook and worksheet name
63 returns the fill color of a cell mass
64 Back to the drawing foreground color
65 pivot
66 shows the workbook name

,red wing heritage boot

| Back to logs list

342124 2008 年 01 月 15 日 14:13 Reading (loading. ..) Comments (7) Category: my logos
published cancel



| Back to logs list

| Back to logs list

Reprinted from alumni of the user at 20:01 on September 18, 2010 Reading (loading. ..) Comments (0) Category: Personal Diary

【waiting for my kid, sister must be present in your home account, when your wife to do what you can not stepmother. 】
【too late to marry me okay, I'll be your daughter, anyway, do you die a ghost house. 】 【
Not know you live, I will feel at ease. 】 【
This guy, you like my next boyfriend】 【
aunt Hi,mulberry handbags, I'm your son's boyfriend】 【
women do not call me home, please call me Madame Curie】
【envy you know me so young. 】 【
Recently and insomnia, 16 hours to wake up again. 】 【
Uncle, help me to sign a name in the spouse field chant?】 【
Everyone says I am ugly, I am actually nothing is obvious. 】 【
What unhappy things? Say to make us happy. 】 【Was spread
you an oil, to say to you: Do not worry, there are subtle automatic, you are supposed to? - Hit his impotence, and said, , no sugar. br> 【you in the end like I do, I change not into it?】 【
I like the penetration of low-key I like to slowly little by little, I like to conquer the instigation step by step day by day, I want you to remember my name and I is his sugar-coated bullets】 【
death, I remember. He was born, my heart to Huangran.
】 【If I were King, you will say that the post】 【
Health of the window dressing that you know, I did it grow and you see, you can never be busy again discrete, I will do this life and you see, you say Lengnuanzizhi, I made this winter to spend XIA Xue and you can see, the good old days Loving you, I will do this gilt embroidered phoenix Ukiyo-e and you. You should worry too high and cold, I will hand over the rivers and mountains, make you feel joy.
】 【If I were really good, why do not you. 】 【
A careless I want to grow old with you to
】 【I've loved the boy with the world's most handsome in profile. 】 【
Others do not easily say love, do not be stubborn door open to others, but also fun to leave. 】 【
Any future life, please do not
soul to deep】 【Love is holding a glass of wine I was careful to give a loved one that he did not accidentally touch so I sprinkled on the water against the】 【was to
You request something, smile and: what you want to use, and for me?】 【life is not
Lin, will not be sad and customs million. 【New】
women: last got hall, got under the kitchen, write the code, check drawn exception, not killing the Trojans,burberry bags, had turned the wall, opened afford a good car, affordable houses, Doude Guo mistress , overshoot the rogue ...】 【
already are used to review the youth throughout the City, but also the whole life to suspect that life?】 【
If rose is very fragrant, I would like roses. It really is very fragrant roses, well, I like the rose bouquet, but your dirty hands off the top. 】 【Please tell the prince
, his aging mother is still blazing the way, there is no turning mountains, rivers have not been, not to kill the dragon, bubble guy is not dead ... ... tell him to continue to sleep!】 【Had amazing
, completely, appear only been around less.
】 【Smile at you, something purely courtesy】 【
to me, nothing good to me】 【
is the difference between human and pig: Pig has been a pig, but sometimes is not the man】
【I love you, you are what you say. I do not love you,handbags online cheap, you say you are. 】 【
Day your name will appear in my account of this show on the】
Ming easy to hide, dark base difficult to prevent. 】 【I can finally smile
memories you】 【
Do you like my thing, I allowed. 】 【
Join the party? Sister I do not care!】
Crash tireless】 【【
... you like me you say? In fact ... I started ... in fact I .. . Well, now you say it, in fact I quite like my own.】 【whether
how anxious I was confused at this time, finally, I have to live the life you want. 】 【
Either beat you, I told you fell out. 】 【
Life so long, and so are you in the afterlife What kind of remember the early】 【
to marry me.
【】 sensible monarch to meet you 。】 【
I'm here, you will not have no home】 【
this life, you do not come, I do not your old】 【
shore the shore, my bank is the sea?】
【You said you may later get married and do not like, okay, I am willing to do that you do not like. 】 【
I cry, I will make you bleed. 】
1. Ah ~ okay, that is, when the Ching Ming Shangfen suddenly think of you, why do so many people die, you do not die?
2. play with feelings? I'll make you cry very rhythmic ...
3. like when you say you are what you do not like you, what you say you are?
4. and human exposure to the longer, the more I like dogs, dogs are always dogs, sometimes not the people!
5. slut slut always, even if the economic crisis, and you can not you!
6. Do not you live with me the wonderful equipment too happy, do not wish me happiness, you have that qualify?
7. Do not break up and I said:
8. saliva is used to Shuchao Piao, not in terms of reason with
9. should not look to see, not to say do not say, should not listen do not listen, should not think do not want, do what to do to
10. less drag in front of me like a follow-abusing, gracefully in the loading force POSE!

11. I am waiting for your care, such as closing the heart ...
12. We only have one Earth, so you have to love the earth; the earth is only one me, so you have to love me !
13. happy to laugh, not happy to smile back later! Happy to music, hard music to upset!
14. This fight did nothing apart from a few days. A variety of noisy aircraft. I did not know or are you when people read?
15. the only way you can occupy a man remember is: to live better!
16. those names, some I forgot, some I will always remember . Just as, some people have is no, then do not say, only to have nothing to say ...

17. Life is: born, live ~
18. If you feel that they are cattle B, you must be stupid B.
19. I am the heart is small, but not in, I was good-natured, but it did!
20. the time unconsciously, we are slow in responding ...
21. my people never hold a grudge, grudges against the spot I usually overstated.
22. Do not cry at my grave. Reincarnation of my way dirty.
23. has been used to review the entire youth are youth, but also the whole life to suspect that students
life.
24. If you flowers, after the cattle dung are afraid to pull it!
25. I thought you were number 1 and 3,paul smith wallet, the middle, did not think the two of you are still the number 1 and 3 combined.
26. 45 ° looking up to others of their choice, to 135 ° looking down Xiuguai others see you.

27.Ralph W. Sockman said: When we were small, you can test their courage; when we are the majority, you can test your tolerance.
28. in the workplace should be like Conan did, there is a death where I go where and let someone else roll the dice.
29. Book Review said: What is superfluous? Summer jacket, winter palm-leaf fan, there are so cold I have heart for your gracious post.
30. forever young, forever Zhuangnen, never know what's good, always tears.
31. Many times you just love the object of an individual practice rather than love object.
32. you save enough for four five,designer handbags cheap, I can save enough for four five, we can go to Bureau of Civil Affairs married.
33. personal feeling, on the network to shift to tears are not too necessary.

34 I face my father expressed his views regarding fat: no Han's life, have a Han's disease.
35. you come to my letter you will not go, you leave me when you've never been. - We do that to fate and love.
36. Do you think people cow B, he may not think you cow B, but you have to feel that others SB, in his eyes you are a SB, so I think, like unrequited love cow B, SB is is ######ual gratification.
37. Whether beautiful or not beautiful woman will be fooled. Different is that lucky woman found a big liar, lied to her life. Unfortunately, the woman found a little liar, lied to her for a while.
39. people most vulnerable place, is reluctant. No longer bear a wonderful feeling, could not bear a vanity, reluctant applause. We always thought the best days will be very, very long, and do not leave so quickly. Relented and in our lack of courage, the best passing day of the relentlessly.
40. I thought that I was the cliff of a flower, then I, but a sea of a slag.
41. Now you call me, because you do not know me, so after you know me, you will beat me.
42. day without reading, no one could see; one week to study, started to be Detroit Metal City; January, not reading, IQ loss to pigs.

43. Some people smart like the weather, changeable; some people stupid like weather forecasts, weather changes it can not be seen.
44 non-stop missed, easy to live up to, unknowingly stranger.
45. Stones tells us: those who truly love the last all gone, all the final mix are reunited.
46. If you do not often encounter setbacks, it shows you do not very innovative - Woody. Allen
47. two people together, more not to change more than the other, but accepted, so that it inclusive, if the light thinking about change, it is not life, that is war.
48 all problems are ultimately a matter of time, all the troubles are actually asking for trouble.
49. people will always do not know who told you what time inadvertently said goodbye never really gone after.
50. a lot of things between the
51. the road to success is always in construction.
52. 【Do you like my angel's face, or the devil's body? 】 【I like your sense of humor. 】
53. Got off tour guide, said:
54. I do not go to hell, who is under the love of who
55. I've not much you can not. I'm not wrong you do not. What a misunderstanding.
56. like your looks, think fuzzy. - I suddenly felt, missing most of this, more light
57. In the years after the sigh, that two teenagers: a stunning of the time, a gentle years.
58. You can never understand, in order for their interest in life, we put a little effort.

59. Confucius said, do not sleep at noon, afternoon crash; Mencius, Confucius said, oranges for
60.9 points to 13 children,burberry handbags, how to divide it fair? - Killing four children.
61. If she (he) said to you: / p>

,red wing shoe store

| Back to logs list

342124 2008 年 01 月 15 日 14:13 Reading (loading. ..) Comments (7) Category: my logos
published cancel



| Back to logs list