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.