Hello,
I have a spreadsheet with multiple sheets.
Sheet1 Column A has alpha numeric values in it like M1, M2, M3, etc. along with empty cells between them. There may be duplicates but that doesn't matter.
I need a formula that I can put on Sheet2 that will generate a consolidated list of what is on Sheet1 based on certain criteria.
For Example:
SHEET1
<tbody>
</tbody>
SHEET2
I need the formula to look in Column A on Sheet1 and find all the rows that have a value starting with the letter "M", and then return the values Sheet 1 Columns B & C, but consolidated as shown here.
<tbody>
</tbody>
Thank you,
B
I have a spreadsheet with multiple sheets.
Sheet1 Column A has alpha numeric values in it like M1, M2, M3, etc. along with empty cells between them. There may be duplicates but that doesn't matter.
I need a formula that I can put on Sheet2 that will generate a consolidated list of what is on Sheet1 based on certain criteria.
For Example:
SHEET1
A | B | C | |
1 | M1 | 2 | Twigs |
2 | M1 | 1 | Berries |
3 | |||
4 | M2 | 3 | Twigs |
5 |
<tbody>
</tbody>
I need the formula to look in Column A on Sheet1 and find all the rows that have a value starting with the letter "M", and then return the values Sheet 1 Columns B & C, but consolidated as shown here.
A | B | |
1 | Twigs | 5 |
2 | Berries | 1 |
3 | ||
4 | ||
5 |
<tbody>
</tbody>
Thank you,
B