separate last digit, and detect even and odd positions and add the amount

**jorel** · 12-31-2019, 07:18 AM

hello, please,separate last digit, and detect even and odd positions and add the amount
https://www.excelforum.com/attachmen...1&d=1577791103

**rorya** · 12-31-2019, 07:27 AM

It looks like you want to count, not add? All you need are some formulas - see attached.

**davsth** · 12-31-2019, 07:37 AM

Im not sure your example is true to the data if I understand it correctly
q6 and copy across =RIGHT(A6,1)*1
ag6 and copy across =IF(ISEVEN(RIGHT(A6,1)*1),"x","") this give 9 and 11 as even but your results don't show that
av6 =COUNTIF(AG6:AU6,"x")
aw6 and copy across =IF(ISODD(RIGHT(A6,1)*1),"x","")
bl6 =COUNTIF(AW6:BK6,"x")

**jorel** · 12-31-2019, 08:29 AM

hello, RORYA,ok correct conglatulations, perfect, thank you

**jorel** · 12-31-2019, 08:30 AM

ok,davsth, perfect, thank you

separate last digit, and detect even and odd positions and add the amount

LinkBack

Thread Tools

Rate This Thread

Display

separate last digit, and detect even and odd positions and add the amount

Re: separate last digit, and detect even and odd positions and add the amount

Re: separate last digit, and detect even and odd positions and add the amount

Re: separate last digit, and detect even and odd positions and add the amount

Re: separate last digit, and detect even and odd positions and add the amount

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] separate the two initial numbers, separate the last type detect the frequency.

detect in each of the 4 groups * the amount of times of each digit,

[SOLVED] separate the last digit into threes, then detect one of the 6 largest patterns.

[SOLVED] separate the starting digit of each number and add the amount in the blue matrix the blue

to detect the full cracks (in red) in the 3 positions.

please detect the last digit and add up the amount of times.

[SOLVED] Round of 7 digit amount into 2 digit

Bookmarks

Bookmarks

Posting Permissions