Dear Raj Kumar,
Pls find attached herewith.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Fri, Oct 11, 2013 at 3:48 PM, Raj Kumar wrote:
> Hi Guru,
>
> We have to calculate based on id of "Raj" & "Mohan" through Sumifs fo
Dear Harisha,
The files which u have sent is in different format. kindly send proper format.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Oct 9, 2013 at 2:54 PM, Hari wrote:
> Dear Excel gurus,
>
> Please suggest m
Dear Friends,
Sorry for distrubing you . The solution has been resloved now.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Sep 26, 2013 at 12:29 PM, अनिल नारायण गवली
wrote:
> Dear Friends,
>
>
> I
Dear Friends,
I had made a macro, then created a new customized ribbon and assigned
it with this macro. Problem is whenever i click on the ribbon to run
the task then the original file where the macro is created is opening
simulteneously. My idea is it should not open the file and only run
the ma
Dear Junaid,
Kindly attach the error file .
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 25, 2013 at 12:26 PM, Junaid wrote:
> Hi guys,
>
> I am working on Excel 2007 macros. My requirement is to access MS SQL s
gt; =TEXT(A12,"hhmm")
>
>
> On Wed, Sep 25, 2013 at 12:13 PM, अनिल नारायण गवली
> wrote:
>>
>> Dear Friends,
>>
>> i have to convert the time to given format . format is as follows.
>>
>> Time Output
>> 08:590859
>> 17:00
Dear Friends,
i have to convert the time to given format . format is as follows.
Time Output
08:590859
17:001700
15:30 1530
17:05& so on.
13:12
00:00
08:57
17:15
08:55
17:10
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
Are y
Dear Deepak ,
See the Output file outitme is mentioned in the same field of "Time" field.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 24, 2013 at 2:26 PM, Deepak Singh wrote:
> Hi Anil,
>
> You did not mentio
Dear Deepak ,
But here the outtime is missing
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 24, 2013 at 1:33 PM, Deepak Singh wrote:
> Try this code..
>
> Sub test()
> Application.ScreenUpdating = False
> Dim sh
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 24, 2013 at 10:01 AM, अनिल नारायण गवली
wrote:
> Dear Friends,
>
>
> As i had attached two files one is the source file named Attendance
> workbook and another is output
Dear Indrajit,
Kindly send it across the Slave files also so that we can test it from out side.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 24, 2013 at 3:48 AM, Indrajit $nai wrote:
> Hi Experts / Ravinder / An
Dear Friends,
As i had attached two files one is the source file named Attendance
workbook and another is output .
in attendance file there are no. of sheets which contain all the
attendance data.
I want that data should convert as output file as attached with the
name output file.
Note : In
Dear Ashish,
See d attached workbook.
Wam Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Mon, Sep 23, 2013 at 11:48 AM, Ashish Kumar
wrote:
>
>
> Dear Seniors,
>
>
> I want total count of unique User ID's. These are 594 ID's in
Dear Indrajit
Workbooks.Open fil,,false
Try using above code .
Pl reply
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Sep 19, 2013 at 4:33 AM, Indrajit $nai wrote:
> Hi Experts,
>
> I am facing some problem with th
Dear Melimob,
Pl share a workbook with us.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 18, 2013 at 12:29 AM, Melimob wrote:
>
>
> Hi all
>
> I am new to this group so I hope someone can kindly assist..
>
> To s
Dear Prabhu,
Pl see the attached sheet.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 17, 2013 at 10:22 AM, Prabhu Pinky wrote:
> Hi Experts,
>
> Please find the attached file, please revert with appropriate form
Dear Shrinivas,
u can also use =VLOOKUP(F3,A3:E13,COLUMNS(A3:E3),0)
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Sat, Sep 14, 2013 at 11:07 AM, Shrinivas Shevde
wrote:
> Dear Ashish,De Premor,Ravi Kumar
>
> Very very tha
Dear Ashish,
Pl see the attached workbook.
Is it ok?
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 11, 2013 at 2:11 PM, अनिल नारायण गवली
wrote:
> Dear Ashish,
>
> Pl share the workbook with
Dear Ashish,
Pl share the workbook with us.
Warm Regards,
Gawli Anil.
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 11, 2013 at 1:20 PM, Ashish Bhalara
wrote:
> Dear experts,
>
> I have a data columnar and want filter only bold letter da
Dear Prabhu,
In place of Sheet2 write
Sheets(2).range("A10").value=1000
Warm Regards,
Gawli Anil.
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Sep 11, 2013 at 11:44 AM, De Premor wrote:
> Give more attention here !
>
>
> Sheets("she
Dear Prabhu,
Use this code
Sub sample()
Sheets("sheet2").Range("A10").Value = 1000
Sheets("sheet2").Activate
Sheets("sheet2").Range("A10").Select
MsgBox "Task Completed"
If MsgBox("Do you want to Clear the data ?", vbYesNo, "Confirm") = vbYes Then
Range("A:A").ClearContents
MsgBox "Data has be
Dear Prajakt Pande,
Has it has lots of rows init. It will take nearly 5 min, so have patients.
Warm Regards,
Gawli Anil.
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 3, 2013 at 10:07 AM, अनिल नारायण गवली
wrote:
> Dear Prajak
Dear Saggi,
Pl share the file with us.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Mon, Sep 2, 2013 at 11:04 AM, shyam.utha...@gmail.com
wrote:
>
>
> Sent from my HTC
>
>
> - Reply message -
> From: "saggi"
> To
Dear Kushlesh,
You can u with countifs(criteriarange,criteria) and enter
Pl find the attached sheet
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Fri, Aug 30, 2013 at 12:04 PM, Kush Shama wrote:
> Dear Team,
>
> Please f
Dear Waseem,
Mostly font color should be black and cell color should be red for negative.
positive:- font color should be black and cell color should be gree.
Warm Regards,
Gawli Anil.
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Aug 22, 201
Dear svenyarl,
Pls share a worksheet with us.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Aug 21, 2013 at 8:13 PM, wrote:
> I sample of the file I receive is as follows:
>
> 25727861 GM DLT 1
> 20130716 17091432
Dear Santosh,
Pl find attached herewith.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Aug 22, 2013 at 4:55 AM, santosh subudhi
wrote:
> Hi Group,
>
> Is it possible to extract the data which are not common between t
Dear Rajkumar,
U can use text to columns option .
click on comma checkbox and finish it.
Warm Regads,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Aug 21, 2013 at 2:42 PM, Andrew Mangozho
wrote:
> Another simpler but rather long
Dear Manok,
Find attached herewith .
Warm Regards,
Gawli Anil.
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Wed, Aug 21, 2013 at 2:30 PM, Manoj Kumar wrote:
>
> Please help me.
>
> I have a data like details mention below.
>
> xxx a b
Dear Chaya,
Pl share a sample sheet with us.
Warm Regards,
Gawli Anil.
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Aug 20, 2013 at 6:00 AM, Chaya Cooper wrote:
> A tutorial I'm using (to create a multi-select box) suggests right-clicking
Dear Ashkan,
on textbox enter event write a code
Me.txtshiptoparty.BackColor = vbGreen
after on textbox exit event write again the same code with different color.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Aug 20,
Dear Shrinivas,
Pl see that u have filter the ext with the following one.
.Filters.Add "Excel", "*.xls; *.xlsx; *.xlsm; *.xlsb", 1
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Mon, Aug 19, 2013 at 2:24 PM, Shrinivas
Dear Nath,
Pl find the attached herewith.
Warm Regards,
Gawli Anil
On Wed, Aug 14, 2013 at 3:09 PM, Gopinath wrote:
> Dear Shri Satendra Kumar,
> Thank you for your suggestion. However, what I wanted is "Running
> Balance" for each Bank - Datewise as well as "Grand Total Balance"
> available
Dear All,
I have a range.
In that range when i select some range of numbers from other sheets and
paste it in then present range or cell by right click or by just pressing
cltr+V , then it should directly paste it as values. Is there any idea
--
Thanks & Regards,
Gawli Anil Narayan
Soft
Dear Sundar,
Go to File. Excel Options and change the language fro urdu to English US.
Warm Regards,
Gawli Anil.
On Fri, Aug 2, 2013 at 4:44 PM, Sundarvelan N wrote:
> Dear Friends,
>
> Suddenly my excel language (font) changed from english to urdu. What is
> the short cut please.
> Thanks
Dear Rakesh,
Pl find attached herewith.
Warm Regards,
Gawli Anil.
On Fri, Jul 5, 2013 at 12:02 PM, Rakesh Sharma wrote:
> Dear Experts
>
>
> i have two queries in acess 2010 screen shot attached which have data
> mention below
>
> i just want to sum both of two queries. pl help
>
> query 1
Dear Rekha,
Pl see the attached workbook.
Warm Regards,
Gawli Anil
On Fri, Jun 28, 2013 at 10:36 AM, rekha siri wrote:
> Hi Experts,
>
> Please help in this concern
>
> i am attaching sample data spread from Column A TO H
>
> in H Column i want to update Status as per below criteria
>
>
> 1) F
Dear Sajid,
Pl see the attached workbook.
Warm Regards,
Gawli Anil
On Thu, Jun 13, 2013 at 10:19 PM, SAJID MEMON wrote:
>
>
> --
> From: sajidwi...@hotmail.com
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Copy Data by click event
> Date: Thu, 13 J
Dear Souza,
Pl see the attached data is it ok?
Warm Regards,
Gawli Anil
On Fri, Jun 14, 2013 at 12:00 AM, Thiago Souza wrote:
> I need to validate an information like this**
>
> ** **
>
> __AB_C
>
> Name 1 w w
>
> Name 2 w w
>
> Name 3 o
Dear Prabhakar,
See the attached workbook.
Warm Regards,
Gawli Anil
On Tue, Jun 4, 2013 at 4:49 PM, Prabhakar S H wrote:
> Hi Team,
>
> i want to get formula to find Total value of cars with black color only.
> pls help.
>
> Rgds,
> Prabhakar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E
Dear amar,
Its Reference file will no more valid means its reference file is no loger
exists.
Warm Regards,
Gawli Anil
On Fri, May 31, 2013 at 3:21 PM, amar takale wrote:
> Dear All
> Can anybody tell me why Error show while excel file opening.when I open
> excel file then some time to take
Dear Prabhu,
Are u pressing cltr+then selecting the cells and trying to copy the
things.?
if u selecting the cells vertically or horizontally but in straight line
then it should copy by selecting cltr key.
But if u selecting the cells randomly then it will not copy and throws the
message whic
Dear Deepak,
Pl elaborate more on this.
Warm Regards,
Gawli Anil.
On Thu, May 16, 2013 at 11:28 AM, Deepak Rawat wrote:
> Hi
>
> PFA the i have to add all the balance of three bank between two dates in
> "Sheet2"
>
> Kindly show the way
>
> Regards,
> Deepak
>
> --
> Are you =EXP(E:RT) or
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
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
>
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 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
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 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 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 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 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 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
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 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
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 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 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 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
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
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
>>
>&
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
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 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 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
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
>
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
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
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 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
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 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
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
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.
>
>
>
$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
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
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
, 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 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
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 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
>
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 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
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 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 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 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 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 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 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 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 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 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 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 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 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 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
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,
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
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
1 - 100 of 243 matches
Mail list logo
