Create your Key_All name with this formula:
=INDEX(KeyA,INT((ROW(OFFSET($A$1,0,0,COUNTA(KeyA)*COUNTA(KeyB)))-1)/COUNTA(KeyB))+1)&INDEX(KeyB,MOD(ROW(OFFSET($A$1,0,0,COUNTA(KeyA)*COUNTA(KeyB)))-1,COUNTA(KeyB))+1)
Create your Key_All name with this formula:
=INDEX(KeyA,INT((ROW(OFFSET($A$1,0,0,COUNTA(KeyA)*COUNTA(KeyB)))-1)/COUNTA(KeyB))+1)&INDEX(KeyB,MOD(ROW(OFFSET($A$1,0,0,COUNTA(KeyA)*COUNTA(KeyB)))-1,COUNTA(KeyB))+1)
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks