Hi,
I have
File is attached for further help
Hi,
I have
File is attached for further help
Last edited by aslam5420; 07-10-2022 at 10:01 AM.
d12 =IF(D10=0,"",IF(OR(AND(C12>C11,C11<C10),AND(C12<C11,C11>C10)),"yes",""))
e3 =Countif$D$3:$D3,"yes")
after that a pivot table.
Notice: I think your expected answers did not met your criteria.
See the attached file.
Last edited by oeldere; 07-03-2022 at 04:58 AM. Reason: formula d12 changed
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi Sir, oeldere
Thank you so much it worked.
Sir, is it possible to get the same these results without using Pivot table. I want a Formula that could find same these values.
You did not replied if the calculated values in my sheet are correct.
H3=ROW()-2
I3=INDEX($A$2:$E$206,MATCH(H3,$E$2:$E$206,0),3)
See the attached file.
Last edited by oeldere; 07-03-2022 at 05:20 AM.
Hi Sir, oeldere
You have calculated these values exactly like hat i want. It was a mistake from my side at cell G46. But you done it in right way.
But i want to find all these values using a Formula
Hi Sir, oeldere
It worked perfectly. I wanted this type of result.
Thank you so much.
Thanks for the rep.
Glad I could help.
Thanks for marking the question solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks