Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula autofill to cells below – formula arguments are cell areas in different columns | Excel Discussion (Misc queries) | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |