I have the following transpose formula which is an array
Where the cells in Col C:L are blank , then the formula returns #N/APlease Login or Register to view this content.
I have tried using iferror, but get the same result
It would be appreciated if someone could amend my formula so that if any of the cells in the source data are blank, a blank will be returned
I have also posted on
https://www.mrexcel.com/forum/excel-...ata-blank.html
Bookmarks