Transpose formula returning #N/A in certain cells where values in source data is blank

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,534
I have the following transpose formula which is an array

Code:
 =-TRANSPOSE('C:\downloads\[BR1.xlsm]Summary'!$C$3:$L$3)
Where the cells on sheet "summary" C:L are blank , then the formula returns #N/A


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
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,534
Problem resolved. I did not select entire source range in my formula
 

Watch MrExcel Video

Forum statistics

Threads
1,099,364
Messages
5,468,189
Members
406,570
Latest member
Ktvu2006

This Week's Hot Topics

Top