Excel Help Again

Reply #8

Sage — Mon, 28 Feb 2011 05:09:35 GMT

Lol Thank you so much! Both of you guys for helping me! It's so appreciated

Reply #7

B$Rizzle — Mon, 28 Feb 2011 02:30:50 GMT

There ya go Sage, what winsum has posted is exactly what you are wanting.

Reply #6

winsumloosesum — Mon, 28 Feb 2011 02:13:08 GMT

This is a method using user defined cell ranges.

http://www.box.net/shared/pb82nb5lmr

Enter your 5 digit number in cell A1 (ascending order) and the missing 5 numbers will be in cell b1.

Reply #5

B$Rizzle — Mon, 28 Feb 2011 01:24:55 GMT

Here is the formula:

=COUNT(SEARCH( - B1 - , - A$1:A$10 - ))=0

You have to set up the excel sheet first by adding the #'s in the specified column. In the example I used column A. Then in the next column you have to put the range of numbers you want. In the example I used 0-9.

Once you do that highlight the #s in column B and then click on Format in Excel, and then Conditional Formatting . Once you are there, under Condition 1 select Formula is and type that formula in. Once yo... [ More ]

Reply #4

Sage — Mon, 28 Feb 2011 00:20:55 GMT

I appreciate your help. Yes this is exactly what I need. Now is there a way to take the hightlighted numbers and put them in their own cell like cell C? Also can you add the formula that hightlights them like this. That is so awesome and I appreciate all your help! Also I need this done without a Macro. I have a macro version that goes crazy when I try to compile it in Doneex.

Reply #3

B$Rizzle — Sun, 27 Feb 2011 23:51:58 GMT

I know of one way it will work but you have to use conditional formatting .

Also the numbers have to be entered into cells like this:

For example in Column A1 put this:

1-2-3-4-5

2-3-4-5-6

0-3-2-4-5

1-2-3-4-5

etc etc

Then in column B you would have the #'s listed like this:

0

1

2

3

4

5

6

7

8

9

If you use the forumula I can give you, it will hightlight all of the #s in Column B that are not in column A like this:

The result wou... [ More ]

Reply #2

Sage — Sun, 27 Feb 2011 23:13:10 GMT

Thanks so much! No I want all 5 digits to be in 1 cell 01234 in cell A or any cell and then show 56789 in another cell like cell E or something! Thanks for a prompt response

Reply #1

B$Rizzle — Sun, 27 Feb 2011 23:10:42 GMT

I need clarification.

Do you want for example cells A1-A10 to be :

A1: 0

A2: 1

A3: 2

A4: 3

A5: 4

A6: 5

A7: 6

A8: 7

And then in cell B1 show the #'s that are not in cells A1-A10? such as 8 9

Excel Help Again

Sage — Sun, 27 Feb 2011 22:19:39 GMT

Good afternoon Lottery Post Family. Last year I posted if someone could help me with an excel formula. I wanted to take digits 0 through 9 and I want to put 5 digits in cell A and have the formula show me the other 5 digits that was not in cell A show up in another cell like cell E or something? I had a version with the macro and I would like a version without using macros if it's possible. Thank you so much