If you’ve ever needed to compare two columns in Excel — such as employee names or IDs — to check which ones appear in both, you’re not alone. This task is incredibly common in HR and admin work, whether you’re cross-checking payroll lists, training attendance, or active vs. terminated employee records. Fortunately, Excel provides a…
Read MoreSplitting a column using Flash Fill in Excel MS Excel has introduced a new feature in 2023 called Flash Fill. It helps in splitting a column using Flash Fill when a pattern is identified. It works similar to Auto Fill but with a slight difference. Advantages of using Flash Fill Flash Fill helps in splitting…
Read More