BuffaloGuy
New Member
- Joined
- Dec 5, 2017
- Messages
- 28
Sorry for the horrible description, but if I knew how to explain it better I could probably look it up.
But is there a function that will output to a single cell all the row numbers that reference a single description? In my example below, I'm trying to write a function for cells C7 & C8 to output the row number for its categories. If I can do that, I would like the answer to be "None" if the cell would be empty. Any Ideas?
<tbody>
</tbody>
But is there a function that will output to a single cell all the row numbers that reference a single description? In my example below, I'm trying to write a function for cells C7 & C8 to output the row number for its categories. If I can do that, I would like the answer to be "None" if the cell would be empty. Any Ideas?
1 | Apple | Fruit |
2 | Carrot | Vegetable |
3 | Peas | Vegetable |
4 | Lettuce | Vegetable |
5 | Watermelon | Fruit |
6 | Corn | Vegetable |
The Vegetables are: | 2, 3, 4, 6 | |
The Fruits are: | 1, 5 |
<tbody>
</tbody>