Forum Discussion
Develop/Extract List?
Maybe as shown in the attached file. I entered the formula below and it seems to work in my sheet.
=INDEX(A$2:A$8,SMALL(IF($C$2:$C$8="SU22",ROW($A$1:$A$7)),ROW(A1)))Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
Maybe as shown in the attached file. I entered the formula below and it seems to work in my sheet.
=INDEX(A$2:A$8,SMALL(IF($C$2:$C$8="SU22",ROW($A$1:$A$7)),ROW(A1)))
Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
thank you!...this works! Can I put another twist on my problem?
The native format of my data is shown below where there are two different "columns of information" (my first example is a single "column of information" whereby I have to cut the second "column of information" and past it under the first "column of information" to complete the analysis with the formula you provided.
Is there a formula possible that will search both "columns of information" and list the info under the headers just is in the first example I had?...thanks again...John
Course Credits Taken Course Credits Taken Structural Analysis 3 x Construction Graphics 3 S23 Estimating II 3 Su22 Construction Surveying 2 x Construction Law 3 F22 Quality Management 3 F2 Mechanical Electrical 3 F22 Summer 2022 Course Credits Fall 2022 Course Credits Spring 2023 Course Credits I don't have a formula to do that. I think you did absolutely the right thing to copy the two tables under each other. Before creating formulas in Excel, one should always prepare the data in such a way that the simplest and most efficient evaluation possible can be achieved.
