![]() The test will now, of course, fail as it relies on the numbers being in order.Ĭheck the first and last numbers manually - it is easier than writing specific code for them. Note that the 3 shows that 2012213913 was the 3rd line in column 1 of your figures.Ĥ If required, put the numbers back into their columns and sort back into order. So, for example, B11 is checked by =IF(B11B10)AND(B11B12) where means NOT EQUAL. If a number is different from the number above and different from the number below, it is unique. I numbered the numbers 1, 2, 3, 4, 5, 6 and 101, 102, 103, 104, 105, 106 before sorting so I could later separate the numbers back into their two columns and put them back into order.ģ Now compare each number with the number above and below it.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |