validation custom

[Daniel Stefan]

Hi Mr. Excel,
>
> I would be grateful if you could help me with the following question.
>
> In column F I want to put a validation list-using a formula-
> that allows
> the user to introduce only the exact number reflecting the name's
> occurrence.
>
> EG: If TODEA VIOLETA appear again in the next record to allow
> the user to
> introduce just 4 figure-the same situation for SIRBU MIHAI-
> (please find
> attached file)
>
> I will also be grateful if I get more information about
> Offset function
> than Excels help offer.
>
> Prompt reply would be highly appreciated.
>
> Yours faithfully,
>
> Daniel STEFAN
Branch No "Issuing
Date" Name Form's No.
AGENTIE NR. BC EMITENT
ALBA IULIA 1 09/03/02 TODEA VIOLETA 1
ALBA IULIA 1 09/03/02 SIRBU MIHAI 1
ALBA IULIA 2 09/05/02 TODEA MARIA 1
ALBA IULIA 3 09/09/02 TODEA MARIA 2
ALBA IULIA 3 09/09/02 TODEA VIOLETA 2
ALBA IULIA 4 09/12/02 SIRBU MIHAI 2
ALBA IULIA 4 09/12/02 SIRBU MIHAI 3
ALBA IULIA 5 09/16/02 TODEA VIOLETA 3
Sorry but you should understand me that I have no possibility to attach file

 

[Andrew Poulsom]

You can do this with a formula. If your data is in columns A:D starting in row 2 enter this formula in cell E2:

=COUNTIF(D$2:D2,D2)

and copy down.

 

[Daniel Stefan]

Thanks for help
One must allways remember the K.I.S.S. principle

 

[Andrew Poulsom]

What didn't you understand about the OFFSET function?

 

[Daniel Stefan]

If you read the Excel's help, they tel you that offset returns a reference to a range, but when you used it you will not get a reference but the containt of the cell-as indirect function-.I have even tried the example from help and nothing new

 

[Andrew Poulsom]

I agree that the help is a bit confusing.

OFFSET returns a reference but the reference is evaluated. Just like the formula:

=A1

contains a reference which is evaluated.

Excel wouldn't be much use if it didn't evaluate references would it?