Rubber Beaked Woodpecker
Board Regular
- Joined
- Aug 30, 2015
- Messages
- 203
- Office Version
- 2021
On certain cells the following formula returns a #NUM! error.
=INDEX(12:12,AGGREGATE(14,6,COLUMN(12:12)/(12:12<>0),($C$10)-COLUMNS($H13:H13)))
I was hoping that this error could be removed by using IFERROR but with no joy.
Any advice please?
=INDEX(12:12,AGGREGATE(14,6,COLUMN(12:12)/(12:12<>0),($C$10)-COLUMNS($H13:H13)))
I was hoping that this error could be removed by using IFERROR but with no joy.
Any advice please?