Currently browsing tag

Blank Space

EXCEL column delete duplicate data

For example:A listing 1,3,4,5,7,8,9 B contains 3,4,7,8 desired result is the A column, directly 3,4,7,8 deleted directly 1.5.9.the actual situation, A contains 19,000 rows, B contains 2489 rows.to ask how this should write the formula? Enter the following formula in C1, = if (countif (b:b, a1), “delete” “reservations”) fill down …

Word can not insert a formula

Thesis writing process, the need to insert part of the formula, the formula comes with Word Editor 3.0 you can edit, but edit the formula is complete, click in the blank space next to, in theory there will be edited at the editorial offices of the formula, Word of the …