multiple results from search / how to?
Hi,
Illustrative example of my problem: I have a list of numbers and letters. How can I lookup the value " 1 " and return the multiple results of z, a, g ? I want to type only one formula in one cell, although I don't mind the result being spread out over multiple cells. Thanks for your thoughts on this. 1 z 2 b 1 a 3 e 4 f 1 g |
All times are GMT +1. The time now is 11:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com