Hi Guys!
i have 4 years data with list of shops. now i need a formula/function which will give me list as per cell value.
for example; in first month we say 3 shops sale oranges than formula will give 3 shop names from the specific list if there are 2 shops than it will auto repeat one from 2 shops. sample file is attached.
Bookmarks