Refer attached file for the depiction of data form & desired result.
Refer attached file for the depiction of data form & desired result.
G5:
=LEFT(G6)
G6:
Similar to G14:Q15, change the reference.Please Login or Register to view this content.
Quang PT
Thanks for the reply.
Kindly clarify where should i apply this formula?
Also , will your formula copy both rows :
row1: A A A B B C C C C
row2: A1 A2 A3 B1 B2 C1 C2 C3 C4
Re-read the reply from Bebo in post #2: you are told where to put the formulae.
Plus he supplied a file with the results.
G6 cell array formula , darg right
HTML Code:
G15 cell array formula , darg right
HTML Code:
John thanks for clarifying!
Question: What is the purpose of the symbol"@" used at 3 places in the formula.
Clarification: Regarding formula for A5:C5 & A14:D14, using A,B,C,D was a mistake, these entries will be some name of companies. I've corrected the file. If possible, kindly advise.
Remaining formula is working perfectly.
Last edited by GAURAVVOHRA; 06-07-2021 at 10:20 AM. Reason: forgot to attach the file
in G5
=INDEX($A$5:$C$5,SUMPRODUCT(($A$6:$C$9=G$6)*COLUMN($A:$C)))
in G14
=INDEX($A$14:$D$14,SUMPRODUCT(($A$15:$D$18=G$15)*COLUMN($A:$D)))
G6 and G15 formulae as per post#2 from Bebo.
Cell G5 array formula , drag right and copy to Cell G14
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks