Daniel Stefan
New Member
- Joined
- Oct 15, 2002
- Messages
- 4
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
>
> 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