Here is a simple three column dataset showing Item ID, Catalogue Name and Catalogue Year Item ID Catalogue Name Catalogue Year A Spring 2012 A Spring 2016 A Spring 2017 B Fall 2014 B Fall 2014 B Fall 2016 The second and third last rows are clear duplicate rows. The task is to create a […]
Read More →
Imagine a multi column exam invigilation schedule with the following information S. No. Name of staff Designation of staff member Two columns for each day on which there is an exam – one for Morning and another for Afternoon A * under each column if that particular staff member has to be an invigilator during […]
Read More →
Combine unique entries from a range of cells after satisfying a condition
{ 2 Comments }