Posts

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 

how to add formula in text in excel

Image
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 

vlookup in excel 2007 with example in excel

Image
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

Image
formula :- in C2   =IF(SUMPRODUCT(($A$1:$A3=A3)*($B$1:$B3=B3))>1,0,1) excel 2007 count unique values multiple criteria 

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") 

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