Sunday, January 24, 2016

how to get free ride in jugnoo

jugnoo promo code for first ride

jugnoo free ride code


To get free ride Jugnoo promo code you have flow to following the below steps:-
Download Jugnoo app from  Google play store

After Downloading open the app and sign up using your details

During the SINUP Please Fill l the code RAJEEV431176 

Now you have successfully Get RS 100 OR 50 for Free Ride in Jugnoo.


jugnoo free ride coupon, 

coupon code for jugnoo

Thanks 

Monday, June 2, 2014

how to add formula in text in excel

how to add formula in text in excel





in column E ="Column B+C= " &B1+C1& " result"

type text in invert er  comma and  and formula in  & symbol 

Wednesday, October 30, 2013

vlookup in excel 2007 with example in excel



FORMULA :-

VLOOKUP(Which Value You Want To Search, Where You Want Search value, Table Index Which Value You Want To Display, FALSE/TRUE)


=VLOOKUP(D8,A2:B7,2,FALSE)

excel group by count distinct



formula :-

in C2

 =IF(SUMPRODUCT(($A$1:$A3=A3)*($B$1:$B3=B3))>1,0,1)


excel 2007 count unique values multiple criteria 


Saturday, October 26, 2013

compare two columns in excel for differences 2007

compare two columns in excel for differences 2007

comparing two columns in excel 


=IF(A1=B1,"MATCH","NOT MATCH") 


Thursday, December 20, 2012

updating two tables in a single query in mysql

updating two tables in a single query in mysql



UPDATE  tb1 , tb2  SET  tb1.name= 'new name', tb2.name = 'tb2 name'   WHERE   tb1.id = '1'  AND  tb2.id = '5'



delete data from two tables at the same time in mysql


delete record from two table in same time in mysql 

it is useful when we create two related table in mysql   

 // with inner join 

DELETE tb1, tb2 FROM tb1 inner JOIN tb2  WHERE tb1.id=tb2.tb1id and tb1.id=1



 // with left or Right Join 

DELETE tb1, tb2 FROM tb1 LEFT JOIN tb2 ON tb1.id=tb2.tb1id  WHERE tb1.id=1