Case 3b

This part of Case 3 demonstrate the use of another method to split the data into multiple columns. The difference between this method of splitting and the earlier part is in the frequency of use. Text-To-Column is for one time use only whereas using formula, you can keep the data up-to-date just by overwriting the data with a fresh copy. We will also show you how to remove duplicates and use the SUMIF and COUNTIF to prepare a summary table.

3.6 Separate Text in a Cell in 3 Simple Steps

3.7 Combining Data from 2 Worksheets Together

3.8 Remove Duplicates in a List

3.9 Create Totals & Averages For Each Industry Class


Quick Access to the other Hidden Secrets in Data Analysis with Excel cases.

Case 1

Case 2

Case 3a

Case 3b

Case 4

Case 5

Case 6

Case 7