Great Noorain!!
Does anybody have more method for sorting..
On Sat, Aug 27, 2011 at 9:06 PM, NOORAIN ANSARI wrote:
> Hi Group,
>
> I have added some extra sorting tips in rajan's Sorting tips.
> Like
> Sorting through Vlookup/Hlookup
> Sorting Through Sumporduct
>
> Vertical and Horizental both
Hi Team,
I had create Compound Calculator in Excel VB sheet , i had already set
the Formula in VB but when i Click on the Calculate Button it shows error,
hence i request you to help me on this.
Regards
--
--
Som
Dear Experts,
I am still waiting for reply from you all. Please help me in this matter.
Thanks
Regards,
Zafar Iqbal
On Sat, Aug 27, 2011 at 10:29 AM, Zafar Iqbal wrote:
> Dear Expert,
>
> Ref your instructions, please find attached file with conditional
> formatting applied. My worry is about
Hi Sajid,
Just install the below PDF Printer Driver and use code for Printing...
http://www.bullzip.com/products/pdf/info.php
*Best Regards,*
*Venkat *
*Chennai*
On Sat, Aug 27, 2011 at 3:58 AM, SAJID MEMON wrote:
> Dear Experts,
>
> I want an active sheet with command button (EXCEL 2003) con
Dear Noorain,
Good solution array formula...
*Best Regards,*
*Venkat *
*Chennai*
On Sat, Aug 27, 2011 at 8:48 AM, NOORAIN ANSARI wrote:
> Dear Kannan,
>
> Venkat solution is great but you can use one Vlookup Instead of Three
> Vlookup.
>
> Press ctrl+shift+Enter
>
> {=VLOOKUP(B2,'Aug 11'!$C:$J
are you sure your data is correct.. because none of the sim or mobile no
from last sheet matches to any of the sheet.
regards,
Mrinal
On Sat, Aug 27, 2011 at 4:10 PM, kannan excel wrote:
> Dear Guru,
>
>
> Pls find the attachment and help me.
> and i want vloopkup formulas.
>
> Your's
>
> kannan
Hi Group,
I have added some extra sorting tips in rajan's Sorting tips.
Like
Sorting through Vlookup/Hlookup
Sorting Through Sumporduct
Vertical and Horizental both sorting attached herewith.
On Sat, Aug 27, 2011 at 6:48 PM, Rajan_Verma wrote:
> Hi Group,
>
> Refer the attached sheet with
Hi rajan,
good work. keep it up.
fantastic
regards
Kannan V
Aircel limited
On Sat, Aug 27, 2011 at 6:48 PM, Rajan_Verma wrote:
> Hi Group,
>
> Refer the attached sheet with some Data Sorting Example. Hope you will like
> it
>
> ** **
>
> Rajan.
>
> ** **
>
> --
>
> -
Thanks Guru.
i am really happy.
Regards
Kannan V
Aircel Limited.
Chennai
On Sat, Aug 27, 2011 at 5:03 PM, Venkat CV wrote:
> Hi Kannan..
>
> Look attached...
>
> On Sat, Aug 27, 2011 at 4:37 PM, kannan excel wrote:
>
>> Pls help guru, its most urgent for me.
>>
>> help me
>>
>> On Sat, Au
Hi Rajan,
It's Superb...
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Sat, Aug 27, 2011 at 6:48 PM, Rajan_Verma wrote:
> Hi Group,
>
> Refer the attached sheet with some Data Sorting Example. Hope you will like
> it
>
> ** **
>
> Rajan.
>
> ** **
>
> --
>
> --
Hi Kannan,
You are Welcome...
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Sat, Aug 27, 2011 at 5:51 PM, kannan excel wrote:
> Thanks Guru.
>
> i am really happy.
>
> Regards
>
> Kannan V
> Aircel Limited.
> Chennai
>
> On Sat, Aug 27, 2011 at 5:03 PM, Venkat CV wrote:
>
>> Hi Kannan..
>>
>> Loo
Rajan's solution is simple, easy and I like it bestbut it does not
address the need for formula as requested.
On Aug 26, 6:21 am, "Rajan_Verma" wrote:
> Press CTRL+G Goto Special Choose Blanks ,
>
> It will select all Blank cell then Press 0 and Ctrl + Enter
>
> From: excel-macros@googlegroup
Pls help guru, its most urgent for me.
help me
On Sat, Aug 27, 2011 at 4:20 PM, kannan excel wrote:
> Sorry Guru,
>
> Not i attached valid SIM NUMBER. You can match that in sim number
>
>
> thanks & regards
> Kannan V
> Aircel Limited
> Chennai
>
>
>
> On Sat, Aug 27, 2011 at 4:16 PM, Venkat CV
Hi friend,
Pls try this website http://www.ipdfconverter.com/
Regards
Rajesh A
TCS
Chennai
On Sat, Aug 27, 2011 at 4:28 PM, SAJID MEMON wrote:
> Dear Experts,
>
> I want an active sheet with command button (EXCEL 2003) convert into pdf
> file. when i click on command button
> it convert and
See the Below Link ..
http://www.mrexcel.com/forum/showthread.php?t=379973
http://www.pcreview.co.uk/forums/convert-excel-pdf-via-vbulletin-code-t95734
4.html
http://www.giveawayoftheday.com/vba+code+convert+to+pdf/
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com
Dear Experts,
I want an active sheet with command button (EXCEL 2003) convert into pdf file.
when i click on command button
it convert and should be open in pdf format.
Is it possible in excel 2003 version, if Yes then please give me VBA code for
my query
i don't want to use any other con
Thanks.
With regards,
Usha
On Fri, Aug 26, 2011 at 12:40 PM, Usha Gusain wrote:
> We have some blank cells in excel (2007), which we want to fill with zero.
> what is the formula for the same?
>
> With regards,
> Usha
>
> --
>
> -
Hello,
See attached workbook.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de C.G.Kumar
Envoyé : vendredi 26 août 2011 06:14
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Conditional Lookup or data validation
Dear All,
Hi Sajid,
Just Upload in this website..and you will get as a PDF
http://www.pdftoexcelonline.com/
Install Below application and try Print Option..
http://www.bullzip.com/products/pdf/info.php
*Best Regards,*
*Venkat *
*Chennai*
On Sat, Aug 27, 2011 at 1:54 PM, SAJID MEMON wrote:
> Dear Exper
You can Download DoPDF Printer its Free On Internet ..
http://www.dopdf.com/download.php
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SAJID MEMON
Sent: Saturday, August 27, 2011 1:54 PM
To: Excel Group
Subject: $$Excel-Macros$$ 2003 excel to pdf
Dear Experts,
I want an active sheet (EXCEL 2003) convert into pdf file and after convert it
should be open in pdf format. Is it possible in excel 2003 version, if Yes then
please give me VBA code for my query
awaiting your positive responce
sajid memon
without macro solution
Assuming 1,2,3,4,5 etc is stored in A1:A300
Put this formula in D1
*=OFFSET($A$1,ROW(A1)*3-(4-COLUMN(A1)),0)*
copy right & down 3 columns x 100 rows
best regards,
~ siti
On Fri, Aug 26, 2011 at 8:45 PM, GreenBriar wrote:
> Transpose would not work because every 4
Use conditional formatting...
Best Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Usha Gusain
Sent: Friday, August 26, 2011 12:40 PM
To: excel-macros@googlegroups.com
Subject: [[Released From Quarantine ]-] $$Excel-Macros$$ Fill empty
23 matches
Mail list logo