Hi Guys, I didn't find exactly what I was looking for, and maybe you can help.
Basically I have a document with thousands of lines of data. The data is organized across per row.
Columns; A, B, C, D, E, F, G.
A: Has a Name, we'll call it "Apple"
My array is from A2:G2000
Example:
<tbody>
</tbody>I'd like to create a formula that going down, will search the entire array from A2 to G2000,
And If I search for "Apple" and go down and organize the rows together. Then I'd do the same thing for Pear, Banana etc.
So If I was searching for "Apple" using the data above my output would need to be;
Apple 10/24 Crate Lot 1 AX1 CA CA $35
Apple 10/24 Create Lot 2 AX1 MD MD $35
Apple 10/24 Create Lot 7 AX1 IA IA $10
It will output in order, going down.
Hopefully this makes sense.
My Current Low Tech Solution:
Filter by "Apple" on Column A, then copy and paste the filtered values into the sheet.
Same thing for Pear, Banana etc.
I'd like to automate the process a bit further.
Thanks!
Basically I have a document with thousands of lines of data. The data is organized across per row.
Columns; A, B, C, D, E, F, G.
A: Has a Name, we'll call it "Apple"
My array is from A2:G2000
Example:
A | B | C | D | E | F | G |
Apple | 10/24 | Crate Lot 1 | AX1 | CA | CA | $35 |
Apple | 10/24 | Create Lot 2 | AX1 | MD | MD | $35 |
Pear | 10/26 | Box 1 | AX1 | FL | FL | $15 |
Apple | 10/24 | Create Lot 7 | AX1 | IA | IA | $10 |
Banana | 10/28 | Packet 1 | BX1 | TX | TX | $15 |
Banana | 10/22 | Packet 5 | BX1 | CA | CA | $10 |
... So on so forth for 2000 lines |
<tbody>
</tbody>
And If I search for "Apple" and go down and organize the rows together. Then I'd do the same thing for Pear, Banana etc.
So If I was searching for "Apple" using the data above my output would need to be;
Apple 10/24 Crate Lot 1 AX1 CA CA $35
Apple 10/24 Create Lot 2 AX1 MD MD $35
Apple 10/24 Create Lot 7 AX1 IA IA $10
It will output in order, going down.
Hopefully this makes sense.
My Current Low Tech Solution:
Filter by "Apple" on Column A, then copy and paste the filtered values into the sheet.
Same thing for Pear, Banana etc.
I'd like to automate the process a bit further.
Thanks!
Last edited: