finding Unique count of sales between Dates

Key Takeaways

okay so here i'm going to start this one and welcome to my channel but new everyday everything will be the new thing because here i'm going to do not repeated queries it's a unique queries which i got for the for my friends and by under connected by my own and here is one of the query this is the query we have to count the unicorn between these dates okay 13 15 13 and 15. so units count will be three three grape apple two one two and banana is only one two to ten if i change this one into 12 12 and this one is the fourteen let's see what it will give you the answer put it so 12 to 14 apple apple only one orange grape two and banana apple apple one two three four the answer is okay so now i will show you how to do this one right and after this reading i will ask this one okay find out the values for this because v lookup will not work over here read lookup will not work i'll explain you after this query okay first of all what you want to you want to count the dates right sorry total unit count now i will show you how to do that one first of all what you will do first of all make sure that what would be the greater and less than so what i'll do is anything for greater than this sorry greater or equal because that should get also it should include okay now this is the first equation okay it's the first condition and second condition is the same range of 2 less than or equal to or equal to this ass right that's right wherever it finds it will show you the one one one okay so between 12 to 14 1 2 3 4 5 is there so we have to make it the logic after the answer is four but here you're showing for five so you have to make it four how you'll do so what i'll use i'll use frequency if okay automatically one will one will convert into what i'll do greater than three okay the last i will do here okay so now what it is it is so frequently pick up the most of current value as a one as nine as a one if it is true it will see brings or not yet so what i'll use math of close parenthesis and bins will be row of i'll explain you no need to worry f4 minus row of this one this one okay f4 plus one see what will happen let's see by pressing f93 one okay so we have to make it totally four update but if you do sum it will become five so how you do just convert this into greater than zero sorry it will also greater than 1 also work no it will not work because 2 is only unit value so what you use what i'll do is anything is greater than see now count it will be 4 1 2 3 4 convert this into numbers by using double negative f9 one two three four do some product for this for this and enter what happened you have to use ctrl shift enter because here we have used the array function in some product ninety percent of formulas can handle array but ten percent you have to and the next query is this one see v local will not work i want name one here and another name one b if i use what will happen but two this one e and again for second two name two it will come f but not e so you have to tell me how to get this one [Music] i could get output like this okay in what way you can get it output and another query is if it is like this suppose india is there so i like to get i i n i n d i n d i a india legit i should get okay after that when i drag this formula down it should cop it should uh stop over here and you mean it will be blank whenever i increase the word like this india some it should show the blank and that's it so two videos you have to solve it i'm giving this query thank you guys thanks for your support and signing off and i will put this query in the my group if anybody wants to join in my group in the below comment box i will add telegram grouping just click over there and actually it will redirect to the group and you can join over there thank you guys signing off ready nikon