Thread: How do I reshuffle some column data based on a coding scheme?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
squenson via OfficeKB.com squenson via OfficeKB.com is offline
external usenet poster
  
Posts: 78
Default How do I reshuffle some column data based on a coding scheme?
Dear Mick,

If you expand your range so it contains all the values, then Excel will
consider them in the MATCH formula, nothing else to do. And to avoid changing
the range address each time you insert new items in a list, insert blank
cells *before* the last row of your range and its address will adapt
automatically!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1

Reply With QuoteReply With Quote