LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default List values NOT entered yet

I have multiple columns of 10 rows each.
So the first column has cells A1 through A10.
I need to enter the numbers 1 through 10 in cells A1 to A10 in any
order, one number per cell and use each number only once.
In cell A11, I would like to list the numbers that have NOT been
entered yet.
For example, before anything is typed in cells A1 through A10, cell
A11 would be 1,2,3,4,5,6,7,8,9,10
If I type '4' in cell A1, then A11 would be 1,2,3,5,6,7,8,9,10
That's it.

Thank you!

 
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
restricted values that can be entered mweber Excel Worksheet Functions 4 April 21st 23 05:14 PM
How do I sum between any two entered values in a vlookup table hkaempffe Excel Worksheet Functions 4 August 25th 06 02:09 AM
Excel does not display entered values correctly TSL1050 Excel Discussion (Misc queries) 2 January 17th 06 04:00 AM
#N/A Values : Returned by Formulas vs Entered Manually monir Charts and Charting in Excel 8 July 7th 05 01:16 AM
Selecting data from a list based on entered values GrantM Excel Discussion (Misc queries) 1 December 20th 04 10:59 AM


All times are GMT +1. The time now is 05:57 PM.

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

About Us

"It's about Microsoft Excel"