hi guys i am new here and i really need help i cant explain so i just made an illustration to illustrate what i wanted to do
CIPhnhf.jpg
what i want to do is detect every next number and see if its high and low then count
thank you in advance
hi guys i am new here and i really need help i cant explain so i just made an illustration to illustrate what i wanted to do
CIPhnhf.jpg
what i want to do is detect every next number and see if its high and low then count
thank you in advance
If you want it all in one formula, that's a little more complicated than im willing to attempt right now. However, if you can do it in steps (helper columns), it isn't that bad.
=countif(A2:A21,"<50") would count your lower values.
=mod(row(a2),2) in C then double click down gives a helper column telling if they are odd or even (every other row).
so then you can use:
=countifs(A2:A21,"<50",C2:C21,1)
to determine if low and if it is on every other row as desired.
if you want it to print out results on the side as you have, you could approach it a different way.
=if(mod(row(a2),2)=1,if(a2>=50,"higher","lower"),"") in the B column
then you could use
=countif(b2:b21,higher)
and
=countif(b2:b21,lower)
wow thats fast thank ill try this right now :D
hi i was trying to play with the example code you given to do another task but i cant seem to figure it out how i almost played with it for 2 hours pls refer to screenshot
bWK6BWy.jpg
what i was trying to do here is that detect numbers from 90 above and tell if the value next to it is higher or lower
thanks
Write this formula on B2 and copy down :
Please Login or Register to view this content.
sorry i think i now know what i want to do actually i am sorry if i am being spoonfed but glad to find out that there is an active community dedicated to help but still im new to excel so pls bear with me and help me accomplish what i need ..
pls see screenshots
oP34MYq.jpg
T5JziYx.jpg
MiylTe1.jpg
6CqP4MW.jpg
i am having hard time to explain thats why i chose to make screenshots instead to explain what i want to accomplish on the screenshots i want to find certain numbers and detect whether the value next to it is high or low, i made 4 separate screenshots just to make it look simple cause i dont want to have a lot of arrows :P but its supposed to be in 1 page
This formula will give you that result :
This will count the higher value from row 2 to 21. Change it as you want. If your starting row is 3 then change A1 to A2 and A2 to A3. If your ending row is 50 then change 21 to 50 and 22 to 51.Please Login or Register to view this content.
If you want to show the words "Higher" and "Lower" beside then write this formula in B2 and copy down.
Please Login or Register to view this content.
No. This formula will not work with whole column.
This will not be a good choice to use that formula on whole column. But I providing it as you want :
Please Login or Register to view this content.
ok thanks i got over 3000 numbers and have to verify if its working correctly but really i appreciate your time and effort :D
You are welcome and thanks for the rep.
if i can only donate i would anyway is it possible to just get the value to be compared on a cell? example
vbrSNg9.jpg
so i just have to drag it rather than type the numbers over and over again
Yes. But you have to use this in this way :
Here C8 is lower value, C9 is Upper value and C10 is 50.Please Login or Register to view this content.
thank you guys closing this thread now as i have another question :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks