Excel Referencing

Closed
ExcelLearner Posts 1 Registration date Wednesday February 5, 2014 Status Member Last seen February 5, 2014 - Feb 5, 2014 at 08:57 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 5, 2014 at 11:17 PM
Hi Experts, I am having the following columns in the excel

AA BB CC
REQ_3.1_1 REQ_4.1.1_2
REQ_4.1.1_3
REQ_4.1.1_4
REQ_4.1.1_3
REQ_4.1.1_4
REQ_3.1_2
REQ_4.1_1
REQ_4.1_2
REQ_4.1_3 REQ_4.1.1_5
REQ_4.1.1_6
REQ_4.1.1_1
REQ_4.1.1_2 REQ_3.1_1
REQ_4.1.1_3 REQ_3.1_1
REQ_4.1.1_4 REQ_3.1_1
REQ_4.1.1_5 REQ_4.1_3
REQ_4.1.1_6 REQ_4.1_3


Here. in column BB has values from column AA. It is required that in column CC it should display all the Values from column AA, that has the reference that point in column BB.

Please help me, how can I use excel intelligence to do the same for a list that has more than 1000 points.

Thanks
Sheba Singh

2 replies

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Feb 5, 2014 at 11:15 PM
suppose ro;w o. 1 is header row
data from row 2

formula in CC2 is

=AA2&" "&BB2
0
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Feb 5, 2014 at 11:17 PM
COPY CC2 DOWN .
0