Or, Eliminate Records (rows) based on two fields (cells) in the same record (row) being identical...
I have a large amount of data that i wish to run calculations on a subset.
The subset is comprised of all rows in the table (records) that the value in column 12 <> the value in column 13
I first copied the table to a temporary worksheet, then sorted on column 12 in order to group portions of the data.
I was thinking along the lines of a filter then deleting visible rows, but i am stumped as to what i can possibly, if anything, enter into Criteria1:= below:
Where Criteria1 would be looking at the next cell to the right in column 13 to see if it is equal to 12. Is this possible?
Unfortunately it must be relative for the value can be different depending upon the record, sort of like:
a b c d e f g h i j k duck frog
a b c d e f g h i j k duck fish
a b c d e f g h i j k duck duck
a b c d e f g h i j k duck duck
a b c d e f g h i j k duck duck
a b c d e f g h i j k tree rock
a b c d e f g h i j k tree bird
a b c d e f g h i j k tree slug
a b c d e f g h i j k tree tree
a b c d e f g h i j k tree tree
and after deleting the visible rows that have columns 12 = 13 i would be left with rows 1,2,6,7,8
I know i could loop through them all, but i am trying to do something faster. Even my copy of the table is regrettable as the time it will waste, but i suspect necessary for i need to run a series of calcs on columns a - k...
Thank-you for your genius!
Bookmarks