Is there any way of sorting data from one range into another so it fills the second range. I tried using RANK with some lookups but then I have problems if I have more than one item with the same value (and therefore the same rank number).
Any ideas?
Thanks
Nick
Any ideas?
Thanks
Nick