Hi All,
I have two columns. Code & Name
I need to use Aggregate or Index & Match formula to get My output
It needs to be 2 blank cells between cells
Name1.gif
Please, Without VBA & help column
Regards,
Jacob
Hi All,
I have two columns. Code & Name
I need to use Aggregate or Index & Match formula to get My output
It needs to be 2 blank cells between cells
Name1.gif
Please, Without VBA & help column
Regards,
Jacob
Last edited by Yaghoub61; 05-02-2020 at 03:41 PM.
Notice:
my main language is not English
If you start the data in a3 and b3 you can use the formula
D3 =IF(MOD(ROW(),3)=0,INDIRECT("A"&(ROW()/3)+2),"") and drag down.
E3 =IF(MOD(ROW(),3)=0,INDIRECT("B"&(ROW()/3)+2),"") and drag down.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Using your current layout, this formula in D2 then fill right to E2 and down as many rows as needed:
Formula:Please Login or Register to view this content.
D2
=if(mod(row()-2,3),"",index(a:a,row()/3+2))
Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks