Instead of a formula based approach why not simply copy and paste the data
on column R on to another sheet
Sort the data
and paste it back on column D in your original sheet

"Rod" wrote in message
...
How can I have excel:
1) search a specific row, e.g R4:R500 and for every occurance of a
non-blank
cell
2) bring back what corresponds to that row in col D?

Thanks