Column Data

Excel: collapse and and the value based of column data?

Concerning about ONE PARTICULAR, 000 rows on this. _ YOUR _ B _C JUST ONE $2 1-2 CA TWO $4 1-2 CB 3 $1 1-2 CA 5 $2 1-3 CA C is a lot like a most important catagory and also B is like a sandwich catagory.in the particular example …

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 …