Excel Forum

Excel Magic Trick 605: IF Function to Fill In Column With Missing Values Paste Special Values

See how to use the IF function to fill in column with missing values then use Paste Special Values to create the final column with correct values. See three methods for Paste Special Values. Right Click Drag Paste Special Values.

Got a Question? Ask it Here in the Forum.