Good evening, I would need a formula that counts the sequence of N.1
That we are in an interval.
But I would need the sequence to the right.
In the attached file you can see the expected result in column N.
Thank you .
Good evening, I would need a formula that counts the sequence of N.1
That we are in an interval.
But I would need the sequence to the right.
In the attached file you can see the expected result in column N.
Thank you .
It's probably because you sued Google translate or similar.
What do you mean by 'in an interval' ?
Would it be that you want to select a number of columns and then count the ocurreces of the value 1 in that selection?
You can do this with a macro and a right-click event in the worksheet
I have a attached a file to try it out
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
n2=COLUMN(M2)-LOOKUP(2,1/(A2:M2<>1),COLUMN(A2:M2))
Try this and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Berna11
Check if this is correct for you
=COUNTIFS(A2:L2,A2,B2:M2,B2)
Decio
I hope he answers at all, no reaction so far
Thank you for your answers and help.
@Keebellach
You almost understood what I would do.
With the macro I have the desired result however I have to select on
Each line the range to get the result.
With a formula you would have the result on all the immediate lines.
@nflsales
Your error formula #Valore!
Maybe better if you join the file
@deciog
It's not the result I'm looking for.
Maybe I did not explain it well or the translation.
I try to explain better:
* Since the frequencies of n.1 in each line may be different,
* I just want the sum of the last frequency of N.1 found
* To the right of each line as highlighted in yellow.
If possible with formula thanks again.
I apologize but the translation of the formula
* Excel from English to Italian has betrayed me.
I did not put one ";" After LOOKUP(2,1 =LOOKUP(2;1
The nflsales formula now works.
Thank you all.
Good morning I apologize if I return to the discussion
but I would like if possible a variation in the formula if
the numbering does not end up to the last column.
In the attached file you can see line 2 where in N2 should
give as a result 3 it should not consider empty cells.
Thank you
Try
N2Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Try this one/Tenta questa
Only the one where the last value is not blank and different 1 has to be editted stil.
You need to define the last cell with the value 1 for it to work
@shukla.ankur281190: you're missing the one in row 5 too.
Try array entering this in N2 and filling down. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:Please Login or Register to view this content.
A B C D E F G H I J K L M N 1 2 0 1 1 2 2 3 3 1 1 1 3 3 1 1 2 2 2 3 3 3 1 1 1 1 1 5 4 0 0 1 1 1 2 2 0 0 0 1 1 2 0 5 0 0 1 1 1 2 2 0 0 1 1 1 1 4
Last edited by FlameRetired; 09-20-2017 at 04:00 AM.
Dave
Perfect, thank you very much for working properly
Thanks to the next
@FlameRetired: Tops!
@ Keebellah,
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks