Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #111534

Re: I need help with a formula

Show all headers | View raw

Hi Dale,

Am Tue, 31 Mar 2020 16:12:20 -0700 (PDT) schrieb
dale.walker82@gmail.com:

> 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!AqMiGBK2qniTgetMnsD0aMKnCQD93w?e=uCg46P


Regards
Claus B.
-- 
Windows10
Office 2016

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

I need help with a formula dale.walker82@gmail.com - 2020-03-31 16:12 -0700
  Re: I need help with a formula Claus Busch <claus_busch@t-online.de> - 2020-04-02 09:55 +0200
    Re: I need help with a formula dale.walker82@gmail.com - 2020-05-04 13:28 -0700

csiph-web