Countif

MS Excel formula question?

My business is making a spread sheet for our Army Pre-book unit.To account for when people have flushed their renewal/re-certify night out on distinct training I want to spot a system (like a COUNTIF) at the end of the actual column connected with dates.The formula would have to count the …

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 …