Rubber Beaked Woodpecker
Board Regular
- Joined
- Aug 30, 2015
- Messages
- 203
- Office Version
- 2021
In D84 I have the following formula;
=IF(AND((100-$A83)>=D$141),"",IFERROR(INDEX(29:29,AGGREGATE(14,6,COLUMN($D70:$XFD70)/($D70:$XFD70<>""),COLUMNS($D$2:D$13))),""))
It normally returns data in the following format;
Aisle1 4th Mar - 14:10 Middle Left
Is there a way to modify the original formula so only the following is returned?
4th Mar - 14:10
Many thanks,
RBW
=IF(AND((100-$A83)>=D$141),"",IFERROR(INDEX(29:29,AGGREGATE(14,6,COLUMN($D70:$XFD70)/($D70:$XFD70<>""),COLUMNS($D$2:D$13))),""))
It normally returns data in the following format;
Aisle1 4th Mar - 14:10 Middle Left
Is there a way to modify the original formula so only the following is returned?
4th Mar - 14:10
Many thanks,
RBW