Could some help me with code that finds missing numbers between 1 and 100 in the in the range of A1:A200.
and show missing numbers on screen.
I did see few scripts looks very complicated and some did not run.
thnsks
var
Could some help me with code that finds missing numbers between 1 and 100 in the in the range of A1:A200.
and show missing numbers on screen.
I did see few scripts looks very complicated and some did not run.
thnsks
var
Try this:
not really clear what you want to do with the missing numbers, but this puts them into an array, then displays the full array in a msgbox.Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Please Login or Register to view this content.
kool..perfect..thats what exactly i wanted olly
thanks to you to haripopuri
Last edited by var; 06-07-2014 at 08:39 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks