I have attached the file here for reference.
If for a particular year of data (in this case, FY 2012), I have two columns - one's "original", and one's "restated", how do I write up a code such that the system would pick up "restated", and delete "original"? But for the other years that ONLY have "original" date, I want to keep those columns.
Could you advise on this multiple criteria?
Why not just delete column D?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Oh.. Erm, because the columns you see are actually a snapshot of a bigger excel sheet, which has many many columns stretching to historic data. Therefore, I am trying to find a shorter way to do things, hopefully to automate it actually. (:
So if there is a number in restated you want excel to delete the value in original?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks