Oh thx DK for a nice solution in H2 and yes i only wanted to show result in Cell G and agree with your suggestion but i really wanted this just to increase my knowledge and this can be helpful in some circumstances ............
About Frequency i just checked it out, it seems to be useful but telling you honestly first time i tried this function but will try to dig in....
anyway I'll wait for some more effective & fast solution from you .....
If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.
Does the formula in post #3 not resolve your issue ?anyway I'll wait for some more effective & fast solution from you .....
ie it only requires the data in B:F
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Originally Posted by DonkeyOte
yes my problem is solved and i was just hoping you to do this by using FREQUENCY
Anyway, I've got the best solution as per expectations and does not force you to do more work on it ......
cheers,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
mubashir aziz 
Register To Reply
Bookmarks