Re: $$Excel-Macros$$ how many count zero of 10000000 with excel formula

2014-05-20 Thread Vishal Angre
=LEN(K4)-LEN(SUBSTITUTE(K4,0,)) On Wed, May 21, 2014 at 10:19 AM, Ashish Kumar kumar.ashish...@gmail.comwrote: Hi Saleem, PFA!!! Thanks Ashish -- Forwarded message -- From: Saleem Ansari ​​ ​​ saleem.logic...@gmail.com Date: 21 May 2014 10:09 Subject: Re:

Re: $$Excel-Macros$$ Need Help

2012-07-10 Thread vishal angre
On Tue, Jul 10, 2012 at 3:55 PM, Deba Ranjan drdeva...@gmail.com wrote: PFA, might it will help you. Thanks Regards, *Deba Ranjan P* On Tue, Jul 10, 2012 at 3:35 PM, Imran khan ikha...@gmail.com wrote: Hello, I need IF formula in attached sheet. IF Column C0, Then Pre-Ops

Re: $$Excel-Macros$$ need a macro to change the background color a cell as soon as i change the value (alphanumeric)

2012-07-04 Thread vishal angre
see attached file On Wed, Jul 4, 2012 at 11:53 AM, vijay yadav vijay.ganesh.ya...@gmail.comwrote: Hi, how to conditional format for a changed alpahnumerical cell value? is it possible? if i have a filled worksheet where tb3 is value in cell A1 and *tb4 is value in cell A2* and I

Re: $$Excel-Macros$$ delete blank columns

2012-06-18 Thread vishal angre
press F5 click special button select blanks button selected cell delete On Fri, Jun 15, 2012 at 11:56 AM, Excel Vba excelvba.lear...@gmail.comwrote: Hi Smitha, PFA Workbook. I hope this will help u. Regards, Hemant.

Re: $$Excel-Macros$$ Vlookup in Macro

2010-12-11 Thread Vishal Angre
Sub vlookup() Dim lookfor As Range Dim rng As Range Dim col As Integer Set lookfor = ActiveCell.Offset(0, -1) Set rng = ActiveWorkbook.Worksheets(MV).Range(A:C) col = 3 dept_code = Application.WorksheetFunction.vlookup(lookfor, rng, col, 0) End Sub On Fri, Dec 10, 2010 at 10:02

Re: $$Excel-Macros$$ Excel Utilities

2010-11-13 Thread Vishal Angre
use this addin for all excel version http://www.asap-utilities.com/download-asap-utilities.php for user help User Guide will show you what you can do with ASAP Utilities http://www2.asap-utilities.com/download/f/ASAP_Utilities_User_Guide.pdf Thanking You Vishal K. Angre --

Re: $$Excel-Macros$$ Excel Utilities

2010-11-13 Thread Vishal Angre
JMT EXCEL UTILITIES http://www.andrewsexceltips.net/JMT%20Full%20List.htm -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

$$Excel-Macros$$ Column hide from excel

2010-10-08 Thread Vishal Angre
4 column(A,B,C,D) in atteched excel, please tell me how to do this -- With Regards, *Vishal K. Angre* E-mail : visha...@gmail.com vishal.k.an...@gmail.com -- -- Some important links for excel users:

Re: $$Excel-Macros$$ Column hide from excel

2010-10-08 Thread Vishal Angre
then enter protect row Thanks 7 Regards Sumit On Fri, Oct 8, 2010 at 4:03 PM, Vishal Angre vishal.k.an...@gmail.comwrote: 4 column(A,B,C,D) in atteched excel, please tell me how to do this -- With Regards, *Vishal K. Angre* E-mail : visha...@gmail.com vishal.k.an

Re: $$Excel-Macros$$ Column hide from excel

2010-10-08 Thread Vishal Angre
Thank you On Fri, Oct 8, 2010 at 6:07 PM, عمر omar27...@gmail.com wrote: See this http://www.youtube.com/watch?v=CrX6353lSx4 *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *Vishal Angre *Sent:* Friday, October 08, 2010 12:34 PM