hi all
i have a list of information like;
random info 1
random info 2
random info 3
name
number
random info 4
this pattern repeats down about 1,000 times
i have a list of all the numbers in sheet 2 (i did this by using find and copy and pasted it), now from the list of numbers i need the name that goes with it, any ideas on how to do this, the name will always be in the cell directly above the number.
sorry if i haven't explained myself well
thanks for any help
michael
Bookmarks