Hi,
In a long set of number array made up of lotto numbers (as below), I am trying to fetch how many weeks ago a ball number (from 1-49) was last drawn.
I am trying some formula combinations with Weeknum and Lookups, but I am not so successful. Would you pls help for an excel array formula...