Dear Sunny, My sincere apologies for the confusion caused. I also know I did little to help with the scenario presented. I promise to do better i...
NB Im sorry I think I forgot to add this- The above criteria should be calculated only when either OPEN, CLOSE, HIGH, LOW values are within the range ...
Dear Sunny, Hope your day is going great! I have yet another dilemma. Attached is a sheet but I want to perform logical functions within it. ...
Done it as you instructed with the pivot table and it worked great! I could inverts and choose what i wanted a rows or columns with the help of the he...
Dear Sunny, thank you once again and sorry for the late response. I will try the pivot table option with helper column right away. Will inform you of ...
Dear Sunny, I must thank you so well. I didnt even know SUMIFS could do this. I am very grateful. Exceedingly grateful! Thank you once again!