LinkBack URL
About LinkBacks
d2=IF($A2="Variable",MIN(IF(($B$2:$B$18=$B2)*($A$2:$A$18<>"Variable"),$C$2:$C$18))&"-"&MAX(IF(($B$2:$B$18=$B2)*($A$2:$A$18<>"Variable"),$C$2:$C$18)),"")
Try this array (Confirm with Ctrl+Shift+Enter) formula and copy towards down
d2=IF($A2="Variable",MIN(IF(($B$2:$B$18=$B2)*($A$2:$A$18<>"Variable"),$C$2:$C$18))&"-"&MAX(IF(($B$2:$B$18=$B2)*($A$2:$A$18<>"Variable"),$C$2:$C$18)),"")
Try this array (Confirm with Ctrl+Shift+Enter) formula and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks