I want to set the value of a cell as "Y" if any of the cells in that row is not empty. I am using
in the column A. By using an array formula I want to do this to all the rows in the sheet but it does'nt work simply by making the above as an array formula. How can i make the above an array formula or is there any other way. The array formula should be in A1 cell.