ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   'Code breaking' function (https://www.excelbanter.com/excel-discussion-misc-queries/178550-code-breaking-function.html)

s4

'Code breaking' function
 
Hi guys,
Just wondering if there's a function or way to use Excel to provide another
example, or the actual pattern of numbers if you input some that you know.

Eg, 125873 , 264729
Code would be1st digit times 3 = last digit

Thanks

Pete_UK

'Code breaking' function
 
And if the first digit is 4, what do you take as the last digit?

Pete

"s4" wrote in message
...
Hi guys,
Just wondering if there's a function or way to use Excel to provide
another
example, or the actual pattern of numbers if you input some that you know.

Eg, 125873 , 264729
Code would be1st digit times 3 = last digit

Thanks




s4

'Code breaking' function
 
Well it would be 2, but that's not the point. I only used that as an example
to help explain what I meant by Code Breaking. I know that that particular
pattern is wrong, but like I said it was only an example.

Thanks

"Pete_UK" wrote:

And if the first digit is 4, what do you take as the last digit?

Pete

"s4" wrote in message
...
Hi guys,
Just wondering if there's a function or way to use Excel to provide
another
example, or the actual pattern of numbers if you input some that you know.

Eg, 125873 , 264729
Code would be1st digit times 3 = last digit

Thanks






All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com