Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
restricted values that can be entered | Excel Worksheet Functions | |||
How do I sum between any two entered values in a vlookup table | Excel Worksheet Functions | |||
Excel does not display entered values correctly | Excel Discussion (Misc queries) | |||
#N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
Selecting data from a list based on entered values | Excel Discussion (Misc queries) |