Dear Amit,
U can use conditional format for each col in that u can use format only
rows that contain lessthanequalto and in formula write =min(range) and
format cell color to desire color.
Regards,
Gawli Anil
On Wed, Jan 16, 2013 at 1:24 PM, Amresh Maurya wrote:
> Hello Amit,
>
> PFA file .Ki
first of all go to data tab
there u'll find from access
there enter the URL and import that content to any of the sheet and see
where the opening and closing number is displayed.
then do as i have given.
Then goto connections and active the checkbox and give 1 minute to referesh.
That's it i hav
hey sorry click on From Web not From Access
sorry for inconvience caused..:(
Warm Regards,
Gawli anil
On Wed, Jan 16, 2013 at 4:06 PM, अनिल नारायण गवली
wrote:
> first of all go to data tab
> there u'll find from access
> there enter the URL and import that content to any of
.TintAndShade = -0.24997717893
> .PatternTintAndShade = 0
> End With
> End If
> n = n + 1
>Next
>Range("a1").Select
>
> End Sub
>
> On Wed, Jan 16, 2013 at 4:57 PM, Amit Gandhi wrote:
> > Thanks Anil
> >
&
gt;
> frstAddr
> End If
> End With
> End With
> AKS:
> Next sh
> MsgBox "Updated Successfully"
> End Sub
>
>
> On Thu, Jan 17, 2013 at 12:21 PM, अनिल नारायण गवली <
> gawlianil8...@gmail.com> wrote:
>
&g
on attached sample
> file.
>
> Regards
>
> Amit
>
>
> On Thu, Jan 17, 2013 at 11:08 AM, अनिल नारायण गवली <
> gawlianil8...@gmail.com> wrote:
>
>> Dear Amit,
>>
>> First select the desire coloum and click on conditional formatting and
>>
Dear Ayush ,
Pl ban this user ASAP.
Warm Regards,
Gawli Anil
On Thu, Jan 17, 2013 at 8:40 AM, Prince wrote:
> Just Ban this user.
>
> On Thursday, January 17, 2013 2:41:34 AM UTC+5:30, mr.amer...@gmail.comwrote:
>>
>> girls online click here
>>
>> http://4medicaltips.blogspot.**com/2012/12/wh
Dear Manjunath,
Pl find attached herewith. Is it OK?
Warm Regards,
Gawli Anil
On Thu, Jan 17, 2013 at 2:17 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Dear Expert,
>
>
>
> Good afternoon have a nice day :)
>
>
>
> I have a data in the attached spreadsheet, automatic
psl find attached herewith
Warm Regards,
Gawli Anil
On Thu, Jan 17, 2013 at 3:48 PM, Ms-Exl-Learner wrote:
> =IF(LEN(TRIM(C5)),LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1,"")
>
--
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
Join official Facebook
Hey Our User ,
Yaar don't get personal afterall we have to help others.
Warm Regardsm
Gawli Anil
On Fri, Jan 18, 2013 at 2:46 AM, Excel_Lover wrote:
> ha ha!!!
>
>
>
> On Thu, Jan 17, 2013 at 2:22 PM, Ms-Exl-Learner
> wrote:
>
>> @ Noorain Ansari,
>>
>> Could you ple
Dear Dhaval,
Pl elaborate you queries four sorting is workingwhat u want
excatly...
Warm Regards,
Gawli Anil
On Fri, Jan 18, 2013 at 12:40 PM, Dhaval Shah wrote:
> Friend i want to make a four different button for sorting data
>
> here with attach a sample file for reference
>
> --
>
; I am not seeing anyone spent time in giving solution for this, Just seeing
> copy paste, *Including your post*.
>
>
>
> On 18-01-2013 10:32 AM, अनिल नारायण गवली wrote:
>
> Hey Our User ,
>
> Yaar don't get personal afterall we have to help others.
>
>
>
Dear Pankaj,
Pl share a workbook with us.
Warm Regards,
Gawli Anil
On Tue, Jan 29, 2013 at 1:16 AM, David Grugeon wrote:
> I really don't understand what you want. Please attac a dashboard sheet
> like you want it with the relevant column headings and the data for at
> least 2 of the rows
>
>
Dear Deepak
Pl see the attached sheet.
Warm Regards,
Gawli Anil
On Mon, Jan 28, 2013 at 9:15 PM, ashish koul wrote:
> HI
>
> try this =SUMPRODUCT((1/COUNTIF(C3:C20,C3:C20&"")))
>
>
> visit
>
> http://www.exceltip.com/st/Counting_number_of_unique_entries_in_a_specified_range./785.html
> or
>
>
SEE THE ATTACHED SHEET
WARM REGARDS,
GAWLI ANIL
On Tue, Jan 29, 2013 at 1:52 PM, hemanath dhanasekar wrote:
> Experts,
>
> Help me in providing a formula to calculate the Half day in the attached
> Attendance Tracker.
>
> If I enter H in the column the Half day column should add up by 0.5 and No
Dear Jaisri,
Pl elaborate some more quries .
Warm Regards,
Gawli Anil
On Wed, Jan 30, 2013 at 10:37 AM, Sri Jai wrote:
> Dear team
>
>
> Need your help on this
>
>
> Tab 1 – Turkey list os over 4000 advertising companies in Turkey (There
> are duplicates as this is actually a contact list but
Dear Manjunath,
see the attached sheet.
Warm Regards,
Gawli Anil
On Wed, Jan 30, 2013 at 4:21 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Dear Experts
>
>
>
> Thanks to all,
>
>
>
> Please find the attachment, please advise in case if we have K508 ,F508,
> E508, A50
its free of cost and take half an hour to complete
go to http://dsaksharta.in/
register and go..
Warm Regards,
Gawli Anil
On Fri, Feb 1, 2013 at 1:24 PM, Amit Desai (MERU)
wrote:
> Please provide more details of the certification;
>
> ** **
>
> **1) **From where did you gave exam;
Dear Shrinivas,
Pls explain more abt your quires . as well attach a sample workbook of
many sheets data.
Warm Regards,
Gawli Anil
On Mon, Feb 4, 2013 at 5:29 PM, Shrinivas Shevde wrote:
> Dear All,
> I want a help to write a macro
> Please find requirement
>
> 1.I have a work book which con
Congrats Mr Prince. Gr8. work..
Warm Regards,
Gawli Anil
On Mon, Feb 4, 2013 at 12:22 PM, amar takale wrote:
> Dear Champ Prince,
>
> Congratulations my friend, well done and keep it up
>
> Thanks for your contribution in our group.
>
> Regards
> Amar
>
>
> On Sun, Feb 3, 2013 at 6:22 AM,
Dear Karunanithi,
Pl find attached herewith required data.
Warm Regards,
Gawli Anil
On Fri, Feb 1, 2013 at 4:56 PM, karunanithi ramaswamy wrote:
> Sir,
>I have data of Station and category in columns a and b. But I want
> the report
> in category wise as in columns h to k. When i use th
ns I want to make 3 work book with
> name as AA BB and CC
> Actually there are many sheet in a work book for An example I took 3
> In case more details required can call me 9869368081 or give u r no I
> will call u
> Thanks once again
> Regards
> Shrinivas
>
> On Tue, Fe
Dear Viking,
This is not the right mail to post u r query. better post a fresh mail to
our expeert groups.
By the way u can use find function or search, or mid to extract your
desired word.
Warm Regards,
Gawli Anil.
On Tue, Feb 5, 2013 at 6:55 PM, wrote:
> **
> Hi prince
>
>
> I have one q
de from macro1, it is not working(error1004 etc)(in Sub
> Test12..End Sub)
> R.Karunanithi.
> 6/2/2013.
> ----------
> *From:* अनिल नारायण गवली
> *To:* excel-macros@googlegroups.com; era_...@yahoo.com
> *Sent:* Tuesday, February 5, 2013 12:05 PM
> *
hey Ayush ,
Ban this user.
Warm Regards,
Gawli Anil
On Thu, Feb 7, 2013 at 4:47 AM, mayank upadhyay
wrote:
> http://www.antonellacimatti.it/1cw3bk.php?s=lf
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook
guys im out of state for a week . pls bear a late for a while.
On 2/13/13, amar takale wrote:
> Dear Champs,
>
> I here want to update chart when I put data in color cell then
> automatically update chart with range.Currently I put data & change source
> data range every time,it is time consumin
Dea Orabakar,
Pl find attached herewith . Password is hide.
Regards,
Gawli Anil
On Mon, Feb 18, 2013 at 9:18 AM, Prabhakar S H wrote:
> Hi,
>
> I have different sheets in attached excel workbook and i want to hide 3rd
> sheet (Settlement Sheet) with protect Password (without Macro) so that
> r
dear prabakar,
Then u can use allow fields to edit .
first protect the sheet and goto allow the fields to edit.
Warm Regards,
Gawli Anil
On Mon, Feb 18, 2013 at 3:16 PM, Prabhakar S H wrote:
> Hi Team,
>
> i want to protect particular in cell in excell without protecting the
> entire sheet. Pl
Dear Prabakar,
Pl find attached sheet .
Warm Regards,
Gawli Anil
On Tue, Feb 19, 2013 at 10:07 AM, Prabhakar S H wrote:
> Hi Experts,
>
> I am not able to lock the particular cell in excel. Please refer attached
> file and help me to lock only the particuar cell which is marked in Yellow.
>
> R
Dear ikhan,
Pl find attached herewith.
Warm Regards,
Gawli Anil
On Tue, Feb 19, 2013 at 11:47 AM, Imran khan wrote:
> Hi,
>
> Can anyone help me count cell by color? I have attached sheet which i need
> to count all green color.
>
> regards,
> Imran Khan
>
> --
> Are you =EXP(E:RT) or =NOT(EXP
Gawli Anil.
On Tue, Feb 19, 2013 at 4:51 PM, Prabhakar H wrote:
> Can you explain me how did you do lock the cell.
>
> Rgds,
> Prabhakar
>
> On Tue, Feb 19, 2013 at 10:13 AM, अनिल नारायण गवली <
> gawlianil8...@gmail.com> wrote:
>
>> Dear Prabakar,
>>
Dear Users,
It can be possible with =SUBSTITUTE(SUBSTITUTE(B2,".","/",1),".","/") also
an another approach.
Warm Regards,
Gawli Anil.
On Tue, Feb 19, 2013 at 6:23 PM, Kuldeep Singh wrote:
>
> Hi Harshad,
>
> Try this one.
>
> *=MID(SUBSTITUTE(SUBSTITUTE(A2,".","/",2),".","/",1),1,10)*
>
> Reg
Dear Amar,
Viper solution is good as compared to our solution. Thanks viper given a
very good logic. I appriciate ur knowledge.
Warm Regards,
Gawli Anil.
On Fri, Feb 22, 2013 at 9:54 AM, The Viper wrote:
> pfa
>
>
> On Thu, Feb 21, 2013 at 7:50 PM, pankaj sangotra wrote:
>
>> Hope this is wh
Dear Ramjit,
Pls share a worksheet with us.
Warm Regards,
Gawli Anil
On Sat, Feb 23, 2013 at 4:06 PM, Ranjeet Negi wrote:
> Dear Sir,
>
> I have a data in Range (C2:C50). There are values. I want to sum all
> value upto or equal to 6500, wherein values greater than 6500 will be
> treated as
Dear Kumar,
First select the desired cell. right click on that select format cells
there goto protection tab.
uncheck all the options and again rightclick on that cell goto
formatcells,protection tab
check the hidden option and goto review and protect the sheet .
on protect sheet uncheck the very
Dear Deepak,
Pl elaborate some more . unable to understand your required query.
Warm Regards,
Gawli Anil.
On Tue, Feb 26, 2013 at 11:27 AM, Deepak Rawat wrote:
> Hi,
>
> I have attached 2 sheets: 1-Form 2-data
> I need to create multiple sheets of the form, as much is data exists.
> and dat
ARWAL <
ankur9_aggarwa...@yahoo.co.in> wrote:
> How is it working ?, Also the code is password protected, can you please
> share the password ?
>
> Warm Regards
> Ankur Aggarwal
> 91-8010614628
> Analyst
> Mckinsey Knowledge Center
> Mckinsey & Co.
>
> -
Dear Kannan,
Pl eaborate your query??
Warm Regards,
Gawli Anil
On Tue, Feb 26, 2013 at 11:59 AM, kannan excel wrote:
> Hi,
>
> Pls find the attachment. here i enclosed my sample data. i want solution
> for anyway like vb coding or formula
>
> regards
> kannan
>
> --
> Are y
Dear Amir,
Pl find enclosed herewith .
Warm Regards,
Gawli Anil
On Wed, Feb 27, 2013 at 1:43 PM, Aamir Shahzad wrote:
> Hi Group,
> I need the Macro, when I run, it insert the blank rows but ask me by
> message box "How many" when I give number e.g. 15, macro insert the blank
> 15 rows after th
pls give some more query ...
Warm Regards,
Gawli Anil
On Mon, Mar 4, 2013 at 11:50 AM, amar takale wrote:
> Dear Experts Team
> I have small query in excel,i give detail information in Attached sheet
> Pls sloved my query
> Amar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo
pls see the attached sheet is it ok?
Warm Regards,
Gawli Anil
On Mon, Mar 4, 2013 at 12:24 PM, अनिल नारायण गवली
wrote:
> pls give some more query ...
>
> Warm Regards,
> Gawli Anil
>
> On Mon, Mar 4, 2013 at 11:50 AM, amar takale wrote:
>
>> Dear Experts Team
>&
Dear Pravin,
Pl share the workbook .
Warm Regards,
Gawli Anil
On Tue, Mar 5, 2013 at 6:56 PM, Pravin Gunjal wrote:
> Hello Friends,
>
> Pl note, I am using the following VB code to gather the data from
> different sheets. Once it was worked fine. But now whenever I am trying
> the data is pi
Dear Anu,
use the following code in worksheet area of Selectionchange event.
ActiveCell.Interior.ColorIndex = 36
Warm Regards,
Gawli Anil
On Wed, Mar 6, 2013 at 12:34 PM, wrote:
> Hi all
>
> I need to change the color of a cell through Macro
> using following code
>
> ===
>
> Sub Mai
pls share the data
On Wed, Mar 6, 2013 at 2:45 PM, xlstime wrote:
> please share required field
>
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Wed, Mar 6, 2013 at 2:09 PM, kannan excel wrote:
>
>> hi friends i want courier management data format in excel
>>
>>
>> regards
>> kann
00, Extn.: 2467, 9716615535
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
> On Wed, Mar 6, 2013 at 2:49 PM, अनिल नारायण गवली
> wrote:
>
>> pls share the data
>>
&g
ng '=Sheet3()' but not working
>
> Am I wrong in calling that function
>
>
>
> On Wednesday, March 6, 2013 4:23:02 PM UTC+5:30, अनिल नारायण गवली wrote:
>
>> Dear Anu,
>>
>> Sorry for wrong file. here is the file.
>>
>>
>> Warm Regards,
Dear Rakesh,
Pl find attached herewith FYI.
Warm Regards,
Gawli Anil
On Fri, Mar 8, 2013 at 3:53 PM, Rakesh Sharma wrote:
> can we arrange rearrange spellings in Excel column.
>
> like i want to arrange my name
>
> hsekar to rakesh
>
>
> --
> **
> RA
Dear Manjunath,
Enclosed herewith the required file and check is it ok??
Warm Regards,
Gawli Anil
On Fri, Mar 8, 2013 at 4:32 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Dear Experts,
>
>
>
>
>
> I have spreadsheet, in which I will be updating the data & i want same
Dear Manjunath,
Pl elaborate some more.. didn't understood
Warm Regards,
Gawli Anil
On Fri, Mar 8, 2013 at 7:13 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Anil,
>
>
>
> Can I use same for existing sheet.
>
>
>
> Example : I have an data in 2nd row & followed b
Dear Karthikeyansankaran,
Goto sheet view code their select worksheet from dropwdown.
Write the code .
ActiveCell.Interior.ColorIndex = 36
Warm Regards,
Gawli Anil
On Sun, Mar 10, 2013 at 5:53 PM, karthikeyan sankaran <
karthikeyansankar...@gmail.com> wrote:
> Hi,
>
> How to highlight ActiveC
Dear Amar,
Now it automatically select the row.
Pl see the attachment.
IS it OK?
Warm Regards,
Gawli Anil.
On Mon, Mar 11, 2013 at 1:55 PM, amar takale wrote:
> Dear Anil
> Can you solved my issue?
>
>
> On Thu, Mar 7, 2013 at 4:33 PM, amar takale wrote:
>
>> Dear Anil,
>>
>>
>> Hi,You know
Dear Rahim
Pl specify your problem little bit more.
Warm Regards,
Gawli Anil
On Mon, Mar 11, 2013 at 11:29 PM, Rahim Sharieff
wrote:
> Hi,
>
> Please find the attached workbook.
>
> 1. There are two tabs "Test 1" and "Test 2"
> 2. The Header row is in row 5 and the data starts from row 6 onwa
Dear SalesRecruiter,
What we do wit this???
Kindly mention the problem with sharing a sample data.
Warm Regards,
Gawli Anil.
On Tue, Mar 12, 2013 at 7:13 PM, rajan verma wrote:
> what to do with this??
>
>
> On Tue, Mar 12, 2013 at 7:36 AM, salesrecruiter04 <
> salesrecruite..
Dear Prabhakar,
Ur formular is right just goto formula tab and click on show formula.
I think u have clicked on show formula that's why it shows only the formula.
Once angain click on show formula and see the changes.
Warm Regards,
Gawli Anil
On Wed, Mar 13, 2013 at 3:27 PM, Prabhakar S H wrote
Dear David,
Pl share your file .
Warm Regards,
Gawli Anil
On Thu, Mar 14, 2013 at 5:49 AM, Bé Trần Văn wrote:
> Using Validation or Combobox.
> You upload the File to handle for convenience.
>
>
> 2013/3/14 David Grugeon
>
>> Use a pivot table. If you need detailed instructions please ask.
>>
Dear Sagar,
>From which mail u want to send the file ? from gmail,yahoo, or from
outlook???
Warm Regards,
Gawli Anil
On Thu, Mar 14, 2013 at 3:29 PM, sagaraher wrote:
> Hello,
>
> I am looking for Macro for filter data & send it to respective user
> through mail, pl find details below
> 1)
Dear Viney,
GoodReally appreciate your first post . that good.Keep it up...
Pls do helping to our forums
Warm Regards.
Gawli Anil
On Thu, Mar 14, 2013 at 4:54 PM, Viney wrote:
> Hi Shiva,
>
> this is my first post to the group...
>
>
> try this macro
>
>
> Sub RemoveDuplicates()
Dear Anil,
Whr is the data or report ?pl share the base sheet.
Warm Regards,
Gawli Anil
On Mon, Mar 18, 2013 at 6:38 PM, Anil B wrote:
> Hi Experts,
>
> find attached the excel sheet
>
> I need ur help to pull up the report by just one click on button with the
> help of Macros and i have t
Dear Ronmcfarlane,
you should use
=COUNTIFS($B$2:$B$6,">"&H2,$C$2:$C$6,"<"&H2)
Because " " inverted commas excel thinks it is a comment only to display..
Warm Regards,
Gawli Anil
On Tue, Mar 19, 2013 at 9:39 AM, Shuzbut wrote:
> I have the following formula
>
> =COUNTIFS($B$2:$B$6,"*>=*1",$
Dear Dhaval,
Your file in which u have mentioned some data is in text format. so direct
deoing sum formula will not work. firstly u should convert that text to
value by using following formula.
=value(a1) it gives u a value then do sum function .
It will work
Warm Regards,
Gawli Anil
On Mon,
Dear Pravin,
Pl see the enclosed sheet .
Warm Regards,
Gawli Anil
On Tue, Mar 19, 2013 at 10:06 AM, Pravin Gunjal wrote:
> Dear Friends,
>
> Is it possible to make "freeze" for unique row & column at a time for many
> sheets?
> Hope to get the solution.
>
> Thank you,
>
> Regards
> Pravin
to drag down from validation and
> have to select the mail id in ExcelOutlook sheet.
>
>
> On 3/19/13, अनिल नारायण गवली wrote:
> > Dear Schreiner,
> >
> > Pl find attached herewith.
> >
> > Warm Regards,
> > Gawli Anil.
> >
> > On Mon, Mar
Dear Kannan,
Pl find attached herewith.
Wam Regards,
Gawli Anil
On Thu, Mar 21, 2013 at 11:59 AM, kannan excel wrote:
> Hi friends,
>
> Anybody have India's State and Region List with Alpha Code??
>
> for example:
>
> *STATE* *REGION* *CODE* ANDHRA PRADESH KADAPA KAD ANDHRA PRADESH KARIM
>
Dear Thampan,
Pl find herewith.
Warm Regards,
Gawli Anil
On Thu, Mar 21, 2013 at 12:16 PM, Midhun Thampan
wrote:
> hi all;
>
> i want to create the bubble chart of the following data.
> not able to create as all the data is not reflecting.
> also the x axis should display high ir low instead of
Dear SantoshKumar.Subudhi,
Pl see the attach sheet.
Warm Regards,
Gawli Anil.
On Mon, Mar 25, 2013 at 11:35 AM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hello Prafull,
>
> Thank you for your early reply.
>
> The solution provided by you contains only two criteria's ,it does't
, March 26, 2013 4:27:59 PM UTC+5:30, अनिल नारायण गवली wrote:
>>
>> Dear Friends,
>>
>>
>>
>> I want a small help which is attached.
>>
>>
>> I want the shiptocode of the smallest amt
>>
>> --
>> Thanks & Regards,
>> Ga
Dear Sundarvelan ,
first select the coloum of A then press cltr+f in find place put 9 then
click on find All button. .
Then it will show u how many records found then select all the reference
sheets . By selecting all the reference sheets it will select all the cells
then click on close button.
co
Dear Praful,
It will come with min and if condition.
See the attached sheet.
Warm Regards,
Gawli Anil
On Thu, Mar 28, 2013 at 11:18 AM, prafull jadhav
wrote:
> Dear Prince,
>
> find the same.
>
> Regards,
> Prafull Jadhav.
>
>
> On Thu, Mar 28, 2013 at 9:19 AM, Prince wrote:
>
>> Share your
$20=**E6) it shows false,false,false,true,true.
>
> false means not matched and true means match. in place of false it takes 0
> . like 0,0,0,0,0,matched values .
> afterwards min(0,0,0,0,07,12) it takes 0 and display .
>
> Regardas,
> Prafull.
>
>
> On Thu, Mar
Thanks friendsfor your efforts.
i used this function.
=INDEX($C$6:$F$20,MATCH(MIN(IF(I8=$E$6:$E$20,$F$6:$F$20)),IF(I8=$E$6:$E$20,$F$6:$F$20),0),1)
with CSE. and it works ...
Warm Regards,
Gawli Anil
On Fri, Mar 29, 2013 at 10:38 AM, Prince wrote:
> sry for mistake
>
> PFA.
>
>
>
Dear Pravin,
u can use it from Group option. Select the sheet by clicking the sheet
name & by pressing shift buton goto last sheetname it automatically select
all the sheets and now u can edit the very first sheet simultaneously the
other sheets will be updating. like a carbon copy.
Warm Regard
Dear All,
Any Progress.Pls ...Help.
Warm Regards,
Gawli Anil
On Sat, Mar 30, 2013 at 2:58 PM, अनिल नारायण गवली
wrote:
> Dear Friends,
>
> From the attached sheets i want the smallest amt soldtocode lookup with
> material code
>
> for eg:- now the material code is 16
On Tue, Apr 2, 2013 at 12:28 AM, vijayajith VA wrote:
> Hi ,
>
>
>
> http://gautamg.wordpress.com/2013/03/30/creating-a-speedometer-in-excel/?goback=%2Egde_82527_member_227695807
>
>
> On Tue, Apr 2, 2013 at 12:27 AM, vijayajith VA wrote:
>
>> Hi,
>>
>> You can try below link/
>>
>> http://www.bra
Dear Amar,
firstly remove refrence . simple copy the entire cell and paste it as
values .
Step 1) select the entire coloum (D) then press cltr+F.
write 0 and tick mark the option of mark entire cell content and press *
FindAll* button.
Step2) now, at down side u find all the finding references s
Dear Kushlesh Sharma,
Pl share the sheet with us.
Warm Regards,
Gawli Anil
On Tue, Apr 2, 2013 at 10:33 PM, Kush Shama wrote:
> I am using multiple sheets in a file. I want to know how to write array
> formulas(those that are combination of formulas or have a lot of brackets).
> any simple le
Dear Deepak,
Pl see the attached sheet. Is it OK.
Warm Regards,
Gawli Anil
On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat wrote:
> Hi
>
> Kindly find attached ,
> i need a graph which change as i select the desired cell.
> suppose if i want to see sales then when i wil select "Sale" cell the
> g
dex formula by
> editing your chart without using Macro.
>
> Please confirm the same whether it is correct or not .
>
> Regard,
> Prafull Jadhav.
>
> On Wed, Apr 3, 2013 at 10:08 AM, अनिल नारायण गवली > wrote:
>
>> Dear Deepak,
>>
>> Pl see the attached
Pl see the attached sheet.
Warm Regards,
Just run the macro.
Gawli Anil
On Fri, Apr 5, 2013 at 12:57 PM, Abhishek Jain wrote:
> See this.
>
>
> On Fri, Apr 5, 2013 at 12:42 PM, Chaya wrote:
>
>> Thanks Abhishek Sir,
>>
>> Actually, where ever the colour of the D cloumn exist or the
>
Dear Amar,
Pl see the solution is it ok?
Warm Regards,
Gawli Anil
On Fri, Apr 5, 2013 at 5:33 PM, amar takale wrote:
> Dear Experts
> I attached Range Solution Sheet with detailed information.Pls give me
> proper Guidance for Range.
> Regards
> Amar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:R
Dear Chaya,
Pl see the attached sheet it will help u .
Warm Regards,
Gawli Anil.
On Mon, Apr 8, 2013 at 10:20 AM, Chaya wrote:
> Dear Experts and folk,
>
> I have been trying to extract numbers and words seperately from
> the strings. Manually i did, but taking huge time and even more
Dear Norman,
Before Protecting the entire sheet first goto review and click on allow
users to edit the ranges and then protext the sheet.
Warm Regards,
Gawli Anil
On Tue, Apr 9, 2013 at 3:32 PM, Norman West wrote:
> I am reading "Excel 2007 for Dummies" in an endeavor to understand protect
>
Dear alanthomas,
Put approximate match or exact match then the result will appear.
=vlookup(value,range,columnno,true,false) or
vlookup(value,range,columnno,1,0)
Warm Regards,
Gawli Anil
On Wed, Apr 10, 2013 at 6:43 AM, Sam Mathai Chacko wrote:
> If you want to look for exact matches, you mu
013 11:12:18 AM UTC+1, अनिल नारायण गवली wrote:
>
>> Dear Norman,
>>
>>
>> Before Protecting the entire sheet first goto review and click on allow
>> users to edit the ranges and then protext the sheet.
>>
>> Warm Regards,
>> Gawli Anil
>>
>&
Yes, U can do it by notes.notessession.
Warm Regards,
Gawli Anil
On Wed, Apr 10, 2013 at 1:42 PM, C.G.Kumar wrote:
> Can we do the same thing using Lotus Notes
>
>
> On Fri, Mar 15, 2013 at 10:58 AM, अनिल नारायण गवली <
> gawlianil8...@gmail.com> wrote:
>
>> Dear
Dear Amit,
Pl share the workbook
Warm Regards,
Gawli Anil.
On Tue, Apr 16, 2013 at 11:30 AM, Priti_verma wrote:
> So what do you need ??
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Amit Desai (MERU)
> *Sent:* 16 April 2013 11
Dear Sagar,
Can u specify more what u want excatly.
Warm Regards,
Gawli Anil N
On Fri, Apr 26, 2013 at 11:50 AM, sagaraher wrote:
> Hello Anil,
>
> You have helped me last time to create different sheets & mail against
> given mail-id through macro. I have one more data sheet to which I need
Dear Excel learner,
Goto formula click on define name put the ranges and click ok..
Warm Regards,
Gawli Anil
On Tue, Apr 30, 2013 at 9:34 AM, excel learner
wrote:
> hi All,
>
> please guide me how to declare variable to save the new worbook with
> Names listed in A column.
>
> i am trying t
Dear Abdulgani,
Pl see the attached sheet.
Warm Regards,
Gawli Anil
On Tue, Apr 30, 2013 at 3:14 PM, ITP Abdulgani Shaikh <
itpabdulg...@gmail.com> wrote:
> I have created hyperlink, using formula but it is not working, whats going
> wrong ? I want to create hyperlink within workbook, that wo
Dear Abdulgani,
See the attached sheet Manually done by hyperlink formula or funtion.
Warm Regards,
Gawli Anil
On Tue, Apr 30, 2013 at 3:23 PM, अनिल नारायण गवली
wrote:
> Dear Abdulgani,
>
> Pl see the attached sheet.
>
> Warm Regards,
> Gawli Anil
>
>
> On Tue, A
needful. Thanks.
>
> Regards
> Pravin Gunjal.
>
> ------ Forwarded message --
> From: अनिल नारायण गवली
> Date: Tue, Apr 30, 2013 at 4:29 PM
> Subject: Re: $$Excel-Macros$$ Export the data from one excel file to other
> To: "excel-macros@googlegroups.com"
Dear Nisha,
Thr r multiple sub function under subtotal function.
Like =subtotal(9,therange) will give u total sum of the range
2) =subtotal(1,therange) will give u average of the range
3) =subtotal(2,therange)will count the nonblank cell
and on..
Warm Regards,
Gawli Ani
Dear Sajid,
Pl Elaborate more on this. didn't understood. Pl give eg. in the
attachment.
Warm Regards,
Gawli Anil
On Wed, May 8, 2013 at 6:23 PM, SAJID MEMON wrote:
> Dear Anil sir,
> I have seen attachment file, Thanx for responce me. but it's not my
> solution. My problem is if database s
Dear Kuldeep,
Pl find attachment.
Warm Regards,
Gawli Anil.
On Wed, May 8, 2013 at 7:37 PM, Kuldeep Singh wrote:
> Hi Experts,
>
> I have a query, if sheet name is similar, how can create a hyperlink.
> query is attached.
>
> I want to via VBA.
>
> Regards,
> Kuldeep
>
> --
> You received this
Dear Manthan,
Pls Elaborate More with Eg.
Warm Regards,
Gawli Anil
On Thu, May 9, 2013 at 2:26 AM, Mathan wrote:
> Hi Experts,
>
> I'm trying to upload a file from shared folder (directory) to the internet
> explorer.
>
> Need a VBA code to do this. Could anyone help me on this?
>
> Thanks i
Dear Chaya,
Use this.
Sub delete()
Dim cell, Searchrange As Range
Set Searchrange = ActiveSheet.Range("A1:K100")
For Each cell In Searchrange
If cell.Value = "Total" Then cell.EntireRow.delete
Next cell
End Sub
On Thu, May 9, 2013 at 12:17 PM, Chaya wrote:
> Thanks Abhishek , it is
Dear Chaya
Pl see the attach sheet
Warm Regards,
Gawli Anil
On Fri, May 10, 2013 at 3:49 PM, Chaya wrote:
> Dear experts,
>
> I want to copy and paste the same range (A2:A8) multiple times below
> the next cell as per the number of copy. and in E1 i have the number copy
> needed.
> exam
Dear Kaushal,
use this.
SELECT
[name]
,create_date
,modify_date
FROM
sys.tables
Warm Regards,
Gawli Anil
On Mon, May 13, 2013 at 12:36 PM, Kaushal Kumar wrote:
> Dear All,
>
> I understand its an excel forum. But just wondering if anybody has got any
> idea to ide
me and your time spare in this.
>>
>> The Datas are not splitting in the solction provided to me. Please
>> check.
>>
>> Thanks again to all
>>
>>
>>
>>
>>
>> Regards,
>> Chaya
>>
>> The excel learner :-)
>>
Dear Pavansai,
Share the workbook with us.
Warm Regards,
Gawli Anil.
On Wed, May 15, 2013 at 1:57 PM, Pavan Valluru
wrote:
> Hi There,
>
> This is pavan. Im a Financial Modeler. I need VBA in My work. Now a days i
> am getting models which will need macro to update huge data. Like I need to
>
opy share price formula for all those companies inputted in the file
> which and for the dates given. please take a look.
>
>
> On Wed, May 15, 2013 at 2:04 PM, अनिल नारायण गवली > wrote:
>
>> Dear Pavansai,
>>
>> Share the workbook with us.
>>
>> Warm
101 - 200 of 243 matches
Mail list logo