alNafa

Nov 23, 2005, 1:25 pm

im trying to have the MS-Word **Find** function find a number in in a document to see if it's repeated by searching for it in all of its possible ways. for ex: 123 , 132 , 213 , 231 , 312 , 321. i can't figure out an easier ways to do this other than actually typing every number in the Find box..it's a really pain..

Thank you,

Al

Mone

Nov 23, 2005, 1:40 pm

I believe u could go into edit then scroll down to find then put in yr info.

I hope that helps.

alNafa

Nov 23, 2005, 1:53 pm

thanks for replying.

what i'm looking for (exactly) is to be able to enter for example 123 **ONLY** in the Find box, and what the Function would do is find: 123 , 132 , 213 , 231 , 312 , 321 for me..If it is possible, it will help me eliminate the other 5 numbers (132 , 213 , 231 , 312 , 321) when i play that number boxed.. I don't think that is possible in MS-Word, but just thought someone might know an easier way...thanks.

Al

lottaloot

Nov 23, 2005, 5:29 pm

thanks for replying.

what i'm looking for (exactly) is to be able to enter for example 123 **ONLY** in the Find box, and what the Function would do is find: 123 , 132 , 213 , 231 , 312 , 321 for me..If it is possible, it will help me eliminate the other 5 numbers (132 , 213 , 231 , 312 , 321) when i play that number boxed.. I don't think that is possible in MS-Word, but just thought someone might know an easier way...thanks.

Al

Sorry. You must go thru the process of manually typing out each combination.

Been there, done that.

Luckily, I placed my data into excel & sirmetro provided me with a formula that puts the combo into box format. This way I am able to search like that.

alNafa

Nov 25, 2005, 9:54 am

lottaloot,

please post the Formula. thank you.

Al

MollyG

Nov 25, 2005, 10:29 am

Are all your numbers (123) in the same column, or in 3 different columns?

You will need 1 column that has the numbers in numerical order....123

Not 132. You can have the original set as listed....132, but will need the column next to it in series order....123. Then the "find" can locate all of them.

OOPs!!! I was thinking of a spreadsheet. Sorry. As I re-read your message, I realized it was a document.

alNafa

Nov 25, 2005, 10:43 am

thanks anyways.

MollyG

Nov 25, 2005, 10:50 am

lottaloot,

please post the Formula. thank you.

Al

alNafa, I think the formula would be for a spreadsheet...not a document.

It is the same formula needed in my above post.

tntea

Nov 25, 2005, 11:01 am

im trying to have the MS-Word **Find** function find a number in in a document to see if it's repeated by searching for it in all of its possible ways. for ex: 123 , 132 , 213 , 231 , 312 , 321. i can't figure out an easier ways to do this other than actually typing every number in the Find box..it's a really pain..

Thank you,

Al

upgrading membership will allow you to check a number for the entire history of any state..

it is a great feature to use. you type it in one time.. and presto.. get your results..

alNafa

Nov 25, 2005, 12:49 pm

MollyG, can i use that formula if i move my numbers to a spreadsheet?

MollyG

Nov 25, 2005, 1:22 pm

MollyG, can i use that formula if i move my numbers to a spreadsheet?

Depends on what spreadsheet you are using....Excel, Works, Lotus, etc.

The formulas are usually different on each spreadsheet.

alNafa

Nov 25, 2005, 1:28 pm

excel.

MollyG

Nov 25, 2005, 1:32 pm

If you can use Excel...YES, you will have no problem. I will PM you.

lottaloot

Nov 25, 2005, 3:22 pm

=CONCATENATE((MIN(LEFT($C2),MID($C2,2,1),RIGHT($C2))),(MEDIAN(LEFT($C2),MID($C2,2,1),RIGHT($C2))),(MAX(LEFT($C2),MID($C2,2,1),RIGHT($C2))))

This excel formula will change your draw results into a box format that allows you to search in the manner that you spoke of earlier.

SirMetro

Nov 25, 2005, 5:54 pm

Just a general thought.

When developing your spreadsheet, do NOT try to do everything inside one cell. When that happens, you end up with incredibly complex formulas that are nearly impossible to debug if they do not work.

Always think "Divide & Conquer".

Also, take the time to understand formulas. They can be your best friend and your worst nightmare. Learn how to make the computer an extension of your thought process. Also, consider the method you are intending to use. Give it a bit of thought. Sketch it out on paper.

And perhaps the most important, Test your ideas/results BEFORE you spend the $$$.

Another note, easiest way to transfer your numbers to a spreadsheet is to use the following steps:

1) Save the word file as a ASCII TXT file

2) Open this file with NOTEPAD

3) Make sure everything appears uniform (crucial when importing into Excel). I suggest that you use a SPACE between the Date Column and the Number Column.

4) Save the file with Notepad & Close it.

5) Open the file in Excel. To open the TXT file you have created and saved in Notepad, make sure the Drop Down box reads "ALL FILES" instead of just "EXCEL FILES".

6) Once you found the file and clicked OK to open it, you will get a message box indicating that it is NOT an excel file, Open any way?, click yes. The Next screen you see will be the data in TXT file. If you use the SPACE as a Delimiter, Excel will assist you in the import. It is IMPORTANT that you try to import the date in one column and the numbers in another column by itself. Otherwise, you will need other formulas to break the data out.

I hope this helps some.

Sir Metro

TopEnd of thread (1 page)

© 2019 Speednet Group LLC Lottery Post is a registered trademark of Speednet Group. |