Make a list by a formula?
Posted by Nico on December 27, 2001 1:32 PM
Sorry for the poor english...
It is possible with a formula to get a list of items from a range. I have an area with a list of holidays, in the first column stands the name of holidays and in the second column stands the date values. Now I want to lookup for a date value and get all holidays-names for this date. I have a VBA-solution
, but i would like to do it by a formula - but how? My only solution was to make it with the OFFSET-Formula in more then one cell, but the formula is to long. Can somebody help me?