It is an excel with formulas. Not as DT
You mean you want to do with Excel Formula ?
Are you looking for a solution to fill the data in the value column if the value in the column is null? Is that the requirement without using the for loop?
Also what’s the value that you need to fill?
Yes I need to fill data in value column as CLOSED if it is empty.
The actual excel file contains about 30k line items, some columns are formula driven.