EXCEL FORMULA FORMULA 1, FIND DUPLICATE CONTENT FORMULA: = IF (COUNTIF (AA, A2) '1

0 k thích
đã hỏi ngày 14 tháng 12 năm 2017 bởi CleoDenny534 (180 điểm)
(1, 2, 3, 4, 5), then the result of this function returns the number of boys in the group; this is an array function, press Ctrl + Shift + Enter key combination (generate '...') The '' Can not be entered manually, only use the key combination.

article compare14, according to the date of birth automatically calculate the age: = TRUNC ((DAYS360 (D3, NOW ())) / 360,0)

- Assume that the D column holds the student's birth date, and the column E inputs the function to produce the student's age.

15, in the Word three tips:

① continuous input of three '~' can be a wave line.

② continuous input three '-' can get a straight line.

Enter three consecutive '=' to get a double line.

One, excel when a cell to meet specific conditions, how to display a specific color in another cell such as:

A1> 1, C1 shows red

0 \u0026 lt; A1 \u0026 lt; 1, C1 shows green

A1 \u0026 lt; 0, C1 shows yellow

Methods as below:

1, the unit hit the C1 cell, point 'format' \u0026 gt; 'conditional format', condition 1 is set to:

Formula = A1 = 1

2, click 'format' -> 'font' -> 'color', click on the red point 'OK'.

Condition 2 is set to:

Formula = AND (A1 \u0026 gt; 0, A1 \u0026 lt; 1)

3, click 'format' -> 'font' -> 'color', click on the green after the 'OK'.

Condition 3 is set to:

Formula = A1 \u0026 lt; 0

Point 'format' -> 'font' -> 'color', click on the yellow and click 'OK'.

4, three conditions set, the point 'OK' that is out.

Second, EXCEL how to control the length of each column of data and to avoid duplication of entry

1, with data validity to define the data length.

Use the mouse to select the range of data you want to enter, point \u0026 quot; data \u0026 quot; - \u0026 gt; \u0026 quot; validity \u0026 quot; - \u0026 gt; \u0026 quot; set \u0026 quot;, \u0026 quot; validity conditions \u0026 quot; set to \u0026 quot; allow \u0026 quot; ; Text length \u0026 quot; \u0026 quot; equal to \u0026 quot; \u0026 quot; 5 \u0026 quot; (specific conditions can be changed according to your needs).

You can also define some prompts, error warning messages and whether to open the Chinese input method, etc., after the definition of 'OK'.

2, with the conditional format to avoid duplication.

Select the condition, set the condition to 'FORM = COUNTIF ($ A: $ A, $ A1) \u0026 gt; 1', point \u0026 quot; format \u0026 quot; - \u0026 gt; \u0026 quot; font \u0026 quot; - \u0026 gt; \u0026 quot; color \u0026 quot; selected red after two \u0026 quot; ok \u0026 quot;

This is set after you enter the data if the length is not there will be prompted if the data repeat font will turn red.

Third, in EXCEL how to B column and A column of the difference between the identified?

(A), if it is required A, B two columns of the same line of data compared:

Assuming the first behavior of the header, click the A2 cell, click 'Format' -> 'Conditional Formatting' and set the condition to:

'Cell value' 'not equal' = B2

Point 'format' -> 'font' -> 'color', select the red, click twice 'OK'.

Use the format brush to copy the condition format of the A2 cell down.

Column B can be set with this method.

(B), if the A column and B column as a whole (that is, the same data is not the same line):

Assuming the first behavior of the header, click the A2 cell, click 'Format' - \u0026 g

t; 'conditional format', set the condition to:

duplicated content checker 'Formula' = COUNTIF ($ B: $ B, $ A2) = 0

Point 'format' -> 'font' -> 'color', select the red, click twice 'OK'.

Use the format brush to copy the condition format of the A2 cell down.

Column B can be set with this method.

According to the above method set, AB column data are not colored, A column has B column

(Download 1-3 pages of 3 pages)

Câu trả lời của bạn

Tên hiển thị của bạn (tùy chọn):
Bảo mật: Địa chỉ email của bạn chỉ được dùng để gửi thông báo.
  1. BlancaMancus

    13780 points

  2. TristanBusch

    13020 points

  3. Kelvin582250

    11000 points

  4. BrianneAinsw

    10440 points

Monthly rewards
1. Place: USD 20
2. Place: USD 10
3. Place: USD 5

901,350 câu hỏi

168,571 trả lời

1,653 bình luận

869,504 thành viên

Những câu hỏi liên quan

0 k thích
0 trả lời
0 k thích
0 trả lời
0 k thích
0 trả lời
0 k thích
0 trả lời
0 k thích
0 trả lời
...