If you have a table, say, with 2 columns
Nominal number (N1,N2,...Nn)
Casualty? (Y/N)
Is there an easy way of selecting (deriving) an (ordinal) casualty number, which is not stored as a column.
e.g. if you had the following data
N1 Y
N2 N
N3 Y
N4 Y
N5 N
selecting casualties only and also a corresponding casualty number, would give
N1 1
N3 2
N4 3
Nominal number (N1,N2,...Nn)
Casualty? (Y/N)
Is there an easy way of selecting (deriving) an (ordinal) casualty number, which is not stored as a column.
e.g. if you had the following data
N1 Y
N2 N
N3 Y
N4 Y
N5 N
selecting casualties only and also a corresponding casualty number, would give
N1 1
N3 2
N4 3