Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon.

Pages: 1-

Advanced Excel Help

Name: Anonymous 2008-01-24 20:34

I need some help with excel...
Lets say I have a list of numbers in a column (1-20 for example), but there are a few numbers missing. 

Can Excel point out which numbers are missing and put them into a list?

Name: Anonymous 2008-01-24 20:37

EDIT:  I know I can tell which numbers in between 1-20 are missing, but I am actually dealing with 1,000 numbers, and that is not quite as easy.

Name: Anonymous !4aO74ChaNs 2008-01-24 23:46

...

Name: Anonymous 2008-01-24 23:49

Ask Clippy.

Name: Anonymous 2008-01-25 2:21

One liner in bash.

Name: Anonymous 2008-01-25 4:25

hav u tried shouting at it?

Name: Anonymous 2008-01-25 22:24

>>5
This may surprise you, but I invented that meme.

Name: Anonymous 2008-01-25 23:29

>>7
This may surprise you, but so did I.

Name: Anonymous 2008-01-26 13:03

Feed it to a neural network
Don't change these.
Name: Email:
Entire Thread Thread List
All trademarks and copyrights on this site are owned by their respective parties. All comments and posts are the responsibility of their own posters.
- Tinychan + 2ch Mode -