Welcome Guest
Log In | Register )
You last visited January 20, 2017, 5:30 am
All times shown are
Eastern Time (GMT-5:00)

help from the great programmers please

Topic closed. 17 replies. Last post 2 years ago by SergeM.

Page 2 of 2
PrintE-mailLink
notmyday's avatar - 8ball
florida
United States
Member #136668
December 16, 2012
346 Posts
Offline
Posted: January 11, 2015, 11:37 am - IP Logged

You were doing:

10 - 1
10 - 1
3 - 1
=
9
9
2

What ever you do, you get some row where you want the unique numbers from.

Up to you to work it out according to your fancy ideas and your fancy rules.

Instead of 003 you can split to three columns to simplify the task. Excel is made for Cells, it is Excellent-Cell,
or excel with cells?

well said.

    SergeM's avatar - slow icon.png
    Economy class
    Belgium
    Member #123700
    February 27, 2012
    4035 Posts
    Offline
    Posted: January 11, 2015, 11:44 am - IP Logged

    well said.

    You can also make some lookup-table.

    0 0 0

    0 1 9

    0 2 8

    ...

    9 8 1

    9 9 0

      SergeM's avatar - slow icon.png
      Economy class
      Belgium
      Member #123700
      February 27, 2012
      4035 Posts
      Offline
      Posted: January 11, 2015, 11:57 am - IP Logged

      =
      value(
        right(10 + cell_above - cell_this_line, 1)
      )