I need help with a formula
 

I need help with a excel formula. I am looking for a formula that will populate a calf number after entering a cows number. If the cows number is
OA12 the O=year born(2000) A=generation(-=first calf A=2nd calf) 12= cows #

Cow 1 Gen. 2 Gen 3 Gen 4 Gen 5 Gen 6 Gen 7 Gen 8 Gen
OA12 2-12 3A12 4B12 5C12 6D12 7E12 8F12 9G12

3-74 5-74 6A74 7B74 8C74 9D74 0E74 1F74 2G74

Any help will be greatly appreciated. Thanks

I need help with a formula
 

Hi Dale,

Am Tue, 31 Mar 2020 16:12:20 -0700 (PDT) schrieb
:

I need help with a excel formula. I am looking for a formula that will populate a calf number after entering a cows number. If the cows number is
OA12 the O=year born(2000) A=generation(-=first calf A=2nd calf) 12= cows #

Cow 1 Gen. 2 Gen 3 Gen 4 Gen 5 Gen 6 Gen 7 Gen 8 Gen
OA12 2-12 3A12 4B12 5C12 6D12 7E12 8F12 9G12

3-74 5-74 6A74 7B74 8C74 9D74 0E74 1F74 2G74

your cow number in A2. Then in B2:
=MOD(LEFT($A2,1)+COLUMN(),10)&IF(COLUMN()=2,"-",CHAR(COLUMN()+62))&RIGHT($A2,2)
and drag it to right.

Or have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgetM...QD93w?e=uCg46P


Regards
Claus B.
--
Windows10
Office 2016

I need help with a formula
 

Thank you for your response. The above formula works great, but it's not quite what I needed.
Exsample
Year 2013
A B
1 Cow # Calf #
2 0A12 3A12

B2 is what I am trying to populate from a formula. Hope this makes sense