Adding a Row Wise Formula in Filtered Special Visible cells only
Dear Forum,
I need to only put a formula in a specific column range based on the values in the other column..
Now this formula goes like this if there any blanks in the column with the column heading "BWRP Ratio"
then the "BWRP Ratio" column no -2 i.e "BWRP Amt" -- Col BD in my data needs to have this formula..
Now , it cannot be BD2 always as the formula needs to be inserted in only the rows fulfilling the criteria in the "BWRP Ratio" COlumn...
Now in another column, I require just to enter "1" in the column BG in only those row/cells ..
Regards
e4excel
Bookmarks