Hi,
I saw a video showing how to do data validation with an if statement in an old excel. I wish to do this now for Excel 2010.
I also need an IF statement for 3 three headings 'A' 'B' 'C' that will throw out duplicate records. e.g. From the example below chair would be thrown out as it has the same year and number for the record. Same for Wardrobe.
A B C
YEAR LIST OF ITEMS NUMBER
2007 CHAIR 1
2007 CHAIR 1
2008 TABLE 1
2009 WARDROBE 2
2009 KETTLE 2
2009 FISHTANK 2
2009 WARDROBE 2
Bookmarks