LinkBack URL
About LinkBacks
can we modified the formula that counts doubles but we don’t count doubles of the same number.so is is 11222 should count 0, if is 112222zero again like the example on spread sheet.
thanks a lot!
can we modified the formula that counts doubles but we don’t count doubles of the same number.so is is 11222 should count 0, if is 112222zero again like the example on spread sheet.
thanks a lot!
In what way does this differ from your original query?
https://www.excelforum.com/excel-gen...t-occur-s.html
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
if is 112222 count zero, i want the formula to count only that event 112211221122 ,,please see attachment.again thanks
I have looked at the attachment. Please explain in words how this is different to your original query that I linked to above.
EDIT: OK - I see the difference now. Sorry!
Last edited by AliGW; 01-01-2019 at 09:08 AM.
lets get the idea: if outcome is 22 count 1,if next number is 2 like 222 count 0 again ,if next number was 1 like 221 count 1(like keep count the previous double).
if outcome is now 2222 count 0, if 2212 count 0, if outcome is 221122 count 3 yes?, if outcome 22112 count 2 (keep the count of previous 2 double)
can you help?
Last edited by louis128; 01-01-2019 at 09:48 AM.
i hope its not difficult
Louis - New Year's Day is a holiday in many parts of the world, so being with family and having fun will be top of most people's lists today, not your Excel problem. Just wait patiently until someone offers you help.
correct
Please try at H1 with Ctrl+Shift+Enter
Formula:
Please Login or Register to view this content.
i think i comfused you.its fine!thanks
can you put me that formula at H1(=IFERROR(INT(MATCH(0,INDEX(--(A2:INDEX(A:A,COUNT(A:A))<>A1:INDEX(A:A,COUNT(A:A)-1)),N(IF(1,COUNT(A:A)-ROW(INDIRECT("1:"&COUNT(A:A)-1))))),)/2),INT(COUNT(A:A)/2)) ,which counts the event 12121212 but has a mistake becouse if you have for example 21 counts 1 correct then 212 count 1 correct then 2121 counts 2 correct then if the sequence is 21211 counts 0 correct! but the problem is if now is 212112 it counts 3 it should count 1 becouse the double numbers between(11) should give 0 and start a new count.(double or triple etc gives 0!
Last edited by louis128; 01-01-2019 at 04:30 PM.
Is this right?
H1
Formula:Please Login or Register to view this content.
Yes!my friend ! i thank you with all my heart.
If you see my post #10 i have a formula which needs to be modified in order to count instead of doubles theat121212 and so on if next 2 =0 ,if next is 2 again =0 ,if next is 1 count 1 not sum all counts. like the formula you create above ,the same philosophy.
The post #10 formula still work if you press Ctrl+Shift+Enter
212112 count 1
=IFERROR(INT(MATCH(0,INDEX(--(A2:INDEX(A:A,COUNT(A:A))<>A1:INDEX(A:A,COUNT(A:A)-1)),N(IF(1,COUNT(A:A)-ROW(INDIRECT("1:"&COUNT(A:A)-1))))),)/2),INT(COUNT(A:A)/2))
i think you are correct iam not sure
Last edited by louis128; 01-02-2019 at 02:32 AM.
Please provide some sample on how it does not work.
Is this right?
Untitled.jpg
yes!!! is right!
But i Cant paste the formula,can you paste it at the spread sheet boss ,please , that is the last i want
can you paste it to the sheet,i will be gratefull cause i cant do it
Please see attached Sheet2
great ! my regards!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks