LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default Remove selected data from a list

i have a list of sequential numbers eg 1 to 100.
I have a second list of numbers eg 5,6,23,38,90
I want to remove the numbers in the second list from the first list.
Leaving me a list of numbers 1 to 100 minus the 5 numbers in the second list.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create separate list of only selected data Lisa Excel Discussion (Misc queries) 1 September 25th 08 10:40 PM
How to verify selected data from drop-down list? PG Excel Worksheet Functions 1 September 5th 08 03:43 PM
A validated List which link to selected cells according to what is selected on the list WL Excel Worksheet Functions 1 June 5th 06 08:52 PM
data validation list selected from a range Native Excel Discussion (Misc queries) 11 January 20th 06 01:11 AM
return a data list depending on a value selected within a drop dow loren Excel Discussion (Misc queries) 1 April 11th 05 05:17 PM


All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"