agnesz
12-17-2009, 01:44 PM
I have a file that I need to clean up based on certain criteria:
1. Delete rows that show any number other than “3” in column U “Region”.
2. Delete rows showing 0 in column “K” TktPrice.
3. Enter a "4" in any row that shows 0.01 in column “k”.
4. Enter a "5" in column V whenever the value in column "u" is not 97.
does this make sense??? I keep doing all these things manually and its driving me bananas. Any help would be much appreciated. I'm attachign the file below. You guys rock!
1. Delete rows that show any number other than “3” in column U “Region”.
2. Delete rows showing 0 in column “K” TktPrice.
3. Enter a "4" in any row that shows 0.01 in column “k”.
4. Enter a "5" in column V whenever the value in column "u" is not 97.
does this make sense??? I keep doing all these things manually and its driving me bananas. Any help would be much appreciated. I'm attachign the file below. You guys rock!