Siraj,
I think this would be possible using an image in your footer.
If the text/borders won't change very often, you could do a screen capture.
Then in your footer use the option to insert the picture.
To automate updating of the footer with an image of the range would appear
to require use
Hi,
Also try...
=SUMIF(A7:A291,D7,B7:B291)
On Fri, May 18, 2012 at 8:10 AM, Seraj Alam seraj.ala...@gmail.com wrote:
Hi Ashish,
You can try below formula also...
=INDEX(B:B,MATCH(D7,A:A,0))
On Wed, May 16, 2012 at 6:03 AM, ashish damor damor.ash...@gmail.comwrote:
Dear Sir,
Thanks
*Dear Anil Sir,
The file that you have share is not at all working. Please check from
your end. and on clicking the Traced data button The UserfForm1 should
show and in userfrom customer data or name list should validate, on
selecting the customer name the database of that particular
Dear Experts,
i wrote
daniyal without quote in cell a1 and i want to count All a without quote
in this daniyal a.
is there any method to do this? any formula?
and DIV error can be count?another formula?
Date: Fri, 18 May 2012 15:00:36 +0530
Subject: Re: $$Excel-Macros$$ Form tracker and
Len(a1)-len(substitute(a1,a,))
Try see if it works
Sent on my BlackBerry® from Vodafone
-Original Message-
From: danial mansoor danial_...@hotmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 18 May 2012 09:48:57
To: excel-macros@googlegroups.com
Reply-To:
thanx
but is ther a way we can count errors like div error and others in whole
range?like we use count for counting numbers?
Subject: Re: $$Excel-Macros$$ count tricky question
To: excel-macros@googlegroups.com
From: koul.ash...@gmail.com
Date: Fri, 18 May 2012 10:01:02 +
Dear Excel Guru,
Please find the attheche file.
No of Student FSLE FSB FSC FSPA Total My Ans should be 25 13
40 10 88 Result requiredEXP Amount FSLE FSB FSC FSPA
Printing 23,456 Yes Yes Yes Yes 6,664
3,465
10,662 2,665 Fees
If u want to count total errors then
Sum(if(iserror(a1:a10),1,0))
Press ctrl +shift+ enter
And if you want to count types of error simply use countif
Sent on my BlackBerry® from Vodafone
-Original Message-
From: danial mansoor danial_...@hotmail.com
Sender:
Please find.
On 18 May 2012 15:34, Sandeep Chhajer chhajersand...@gmail.com wrote:
Dear Excel Guru,
Please find the attheche file.
No of Student FSLE FSB FSC FSPA Total My Ans should be 25
13 40 10 88 Result requiredEXP Amount FSLE FSB FSC FSPA
Printing
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the
Try this Function:
=IF(ISERROR(VLOOKUP(*A2*,Sheet2!A:B,2,0)),VLOOKUP(*LEFT(A2,5)*,Sheet2!A:B,2,0),VLOOKUP(*A2*,Sheet2!A:B,2,0))
Regards
Rajan
On Friday, 18 May 2012 16:36:27 UTC+5:30, lakshm...@yahoo.com wrote:
*Dear
*Dear Anil,
Thank you very much for your effort on this. Thats good
but can you please send me the file once again that is working in your
system please. Please before attachment please check the file once again
and please do let me know the button where i need to click. Thank you
Dear sir,
Can you please explain how to assigned ?
Note:-- And in the combox, if i click then nothing is drop down. Please
check it. Please create a new button to show the UserForm1, so that it will
better understand and show. Please if you don't mind,
Thank you once again.
Thanks Regards,
Hi Anil,
Plz see cell D13 and D17 value or #NA data no coming
From: Anil Gawli gawlianil8...@gmail.com
To: excel-macros@googlegroups.com
Sent: Friday, May 18, 2012 5:37 PM
Subject: Re: $$Excel-Macros$$ unable to use advance vlookup
Try this see
Sir,
I have lot of data in excel how to export it to Tally ERP 9, please give
suggestions sir.
Thanks
Raghu
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
Put in J5 and drag across and down
=IF(E5yes,,$C5/SUMPRODUCT(($E5:$H5=yes)*$E$3:$H$3)*E$3)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sandeep Chhajer
Sent: Friday, May 18, 2012 5:04 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Apportioned of
subsidary sheet in A17 is 10020-16A-BLKC-MR. ANUPAM SARKAR and in sheet2
in A17 is 10020--BLKC-MR. ANUPAM SARKAR(2)
both are not matching that,s why
Regards,
Anil Gawli
On Fri, May 18, 2012 at 6:05 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote:
Hi Anil,
Plz see cell D13 and D17
if you use Tally 9 Then you have import the excel file in tally
On Fri, May 18, 2012 at 6:13 PM, raghu gr balaji.bra...@gmail.com wrote:
Sir,
I have lot of data in excel how to export it to Tally ERP 9, please give
suggestions sir.
Thanks
Raghu
--
FORUM RULES (986+ members already
https://groups.google.com/forum/?fromgroups#!forum/excel-macros
in my membership choose leave group
On Fri, May 18, 2012 at 4:40 PM, saurabh kumar saurabh.1...@yahoo.co.inwrote:
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
see if it helps
On Fri, May 18, 2012 at 6:20 PM, dguillett1 dguille...@gmail.com wrote:
Put in J5 and drag across and down
=IF(E5yes,,$C5/SUMPRODUCT(($E5:$H5=yes)*$E$3:$H$3)*E$3)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Sandeep Chhajer
VLOOKUP(A2*,Sheet2!A:B,2,0)
In some cases you can use below formula
IFERROR(VLOOKUP(A2*,Sheet2!A:B,2,0),VLOOKUP(LEFT(A2,FIND(-,A2,2)-1)-RIGHT(A2,LEN(A2)-FIND(-,A2,FIND(-,A2,2)+1))*,Sheet2!A:B,2,0))
On Fri, May 18, 2012 at 6:22 PM, Anil Gawli gawlianil8...@gmail.com wrote:
subsidary sheet in
hi Anil
when select the combobox2 (mobile no), it giving error of *Object doesn't
support this property or method* . Please look at this.
Dhartikumar
On Fri, May 18, 2012 at 6:12 PM, Anil Gawli gawlianil8...@gmail.com wrote:
first of all extention should be .xlsm
after that right click on
Hi,**
This is Aparna – Sr. Technical Recruiter from SancroSoft USA Inc**
We have an urgent requirement as follows:
Please respond with resumes in MS-Word Format with the following details to
*apa...@sancrosoftusa.com* apa...@sancrosoftusa.com
Full Name:
Phone Number:
Email Id:
Visa
Hello
Was trying to understand and learn the formula used by Ashish Koul.
However, when I edit the formula and exit the formula bar (without
making any changes), I get #Name? as the result.
I would assume that is has something to do with _xlfn.Sumifs used in the
formula and Excel 2003
Here's one with SUMIF
Regards,
Sam Mathai Chacko
On Fri, May 18, 2012 at 9:22 AM, Ashish Pradhan ashlyprad...@gmail.comwrote:
Hello
Was trying to understand and learn the formula used by Ashish Koul.
However, when I edit the formula and exit the formula bar (without making
any changes),
Hi,**
This is Aparna – Sr. Technical Recruiter from SancroSoft USA Inc**
We have an urgent requirement as follows:
Please respond with resumes in MS-Word Format with the following details to
*apa...@sancrosoftusa.com* apa...@sancrosoftusa.com
Full Name:
Phone Number:
Email Id:
Visa
Hi,**
This is Aparna – Sr. Technical Recruiter from SancroSoft USA Inc**
We have an urgent requirement as follows:
Please respond with resumes in MS-Word Format with the following details to
*apa...@sancrosoftusa.com* apa...@sancrosoftusa.com
Full Name:
Phone Number:
Email Id:
Visa
Hi,**
This is Aparna – Sr. Technical Recruiter from SancroSoft USA Inc**
We have an urgent requirement as follows:
Please respond with resumes in MS-Word Format with the following details to
*apa...@sancrosoftusa.com* apa...@sancrosoftusa.com
Full Name:
Phone Number:
Email Id:
Visa
Hi,**
This is Aparna – Sr. Technical Recruiter from SancroSoft USA Inc**
We have an urgent requirement as follows:
Please respond with resumes in MS-Word Format with the following details to
*apa...@sancrosoftusa.com* apa...@sancrosoftusa.com
Full Name:
Phone Number:
Email Id:
Visa
Hi,**
This is Aparna – Sr. Technical Recruiter from SancroSoft USA Inc**
We have an urgent requirement as follows:
Please respond with resumes in MS-Word Format with the following details to
*apa...@sancrosoftusa.com* apa...@sancrosoftusa.com
Full Name:
Phone Number:
Email Id:
Visa
Sorry u have added a field in data sheet..I need a formula in Pivot...
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Aamir Shahzad
Sent: 18 May 2012 23:54
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Addition of
Dear All,
i want to protect my excel workbook while emailing it to s omebody.
nobody should edit or copy my data.
Pleaes suggest me the formula or the procedure .
Thanks Regards
Reshma
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
32 matches
Mail list logo