I have two columns first column is month ranging from 2012-01 to YTD and the second column is values. I believe that adding the correct amounts of notes for June through access is turning up as an error because I have some values in celss for June, thus I want to make every value corresponding to 2012-06 blank. I attached an example so it is easy to see and yes the dates have to be repeated like that because I have names attached to those dates. Thank you for any help in advance!
Doing this will make your YTD values wrong, but anyway:
1) Put this formula in C2, the copy C2 down the whole dataset:
=IF(OR(B2="", A2="2012-06"), "", B2)
2) Now copy the cells C2:C1905
3) Click on B2 and do an Edit > Paste Special > Values
4) Clear column C
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Works great now only thing I wanted to keep the other months blank cells blank but the formula doesnt work that way but I can deal. thank you very much!
Last edited by cajodonn; 07-26-2012 at 10:14 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks