On the attached worksheet i have data in cols G & P,I wish to insert a formula in col T,so that when col G =1
col T will show the value in col P,if col G does not equal 1,then col T shows blank.The desired results are shown in col T.Many thanks for help given.
Last edited by bigband1; 02-02-2015 at 12:51 PM.
in T2
=IF(G2=1,P2,"")
copy down the column
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks