string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source='\\192.168.10.54\\D:\\shareff\\Excel.xls';Extended Properties=Excel
8.0;";
OleDbConnection conn = new OleDbConnection(connString);
conn.Open();
OleDbDataAdapter adapter = new OleDbD
HI..
Please share sample file..
Thnks
On Fri, Jun 1, 2012 at 2:12 AM, Dan Brimley wrote:
> I have been asked to help with a bunch of Excel functions and programming.
> There are a few that are beyond my level. I didn't come up with these
> ideas, just trying to help the person who did, so the
Hi ...
Please attach sample file.
Thanks
On Sat, Jun 2, 2012 at 1:02 AM, Babak H wrote:
> Hello,
>
> I am new to this group and I am unsure if this topic was covered in the
> past so I apologize in advance.
>
> *Problem*: I have external worksheets that i get on a montly basis
> (Naming co
Dear Mark,
You can try..
.
.Range("q" & i).Formula = *Evaluate(*"=SUMIFS(O$2:O$26196,A$2:A$26196," &
"a" & i & ",N$2:N$26196," & "n" & i & ")"*)*
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Sat, Jun 2, 2012 at 12:13 AM, Mark Kerin wrote:
>
> T
I haven't said anything in the past, thinking it may just be a culture
difference --
But now I will offer my opinion:
I too am against sharing pirated material. I have seen apparently pirated
ebooks posted, linked to, or offered on this list many times. I have also
seen copy-paste responses
Hello,
I am new to this group and I am unsure if this topic was covered in the
past so I apologize in advance.
*Problem*: I have external worksheets that i get on a montly basis (Naming
convention is the same and the date gets updated. I.E. "Report May
2012.xls", "Report April 2012.xls")
I hav
Hi NOORAIN,
Thanks for your help man both the formula and macro works fine.
you are just awesome man simply great only 5 lines of code and doing
exceptional task.
salute for your logic and your knowledge.
not just words ! :)
simply great.
Regards,
Avinash
On Friday, June 1, 2012 11:17:
This formula works in a cell:
=SUMIFS(O$2:O$26196,A$2:A$26196,A2,N$2:N$26196,"<="&N2)
1) I want to have vba make this calculation - because calculating it in
each cell bogs down the xls.
I got the following vba to work but I cant figure out how to add "<=" to
the last clause (col N has dates):
.R
Thanks Don for suggestion..
For VBA Ebook you can send me mail on my personal email ID instead of group
email ID.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Fri, Jun 1, 2012 at 10:03 PM, dguillett1 wrote:
> These messages are cluttering
Dear Avinash,
Please try it with ctrl+shfit+Enter
*=INDEX($D$2:$D$21,SMALL(IF($A$2:$A$21=1,ROW($D$2:$D$21),""),ROW(A1))-1)*
See attached sheet
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Fri, Jun 1, 2012 at 10:59 PM, Avinash wrote:
> Hi Excel
Hi Excel's,
I want to retrieve unique records from the data. 1st preference will be
formula.
otherwise if anyone can help me with the macro or function will also
welcome.
please find attached sheet for better understanding.
Regards,
Avinash
--
FORUM RULES (986+ members already BANNED for
Thanks Haseeb, will try now, very grateful
On Fri, Jun 1, 2012 at 3:53 PM, Haseeb A wrote:
> Hello Hilary,
>
> If you want to return the exact 2nd occurrance value, you can use VLOOKUP
> like this,
>
> =VLOOKUP(A14,INDEX(A:A,MATCH(A14,A:A,0)+1):INDEX(B:B,65536),2,0)
>
> Regards,
> Haseeb
>
> --
These messages are cluttering.
For the sake of us all can you strongly suggest that responses to offers be
make OFF LIST.
When I offer a file I will either attach to the group, put in files area (if
available) or say
“I will ONLY respond to OFF list requests for this file”
Don Guillett
Microso
Could you please send me that macro book too ?
On Fri, Jun 1, 2012 at 7:05 PM, Amol Jadhav wrote:
> Hi Noorain sir,
> Please send the ebook to my email id also...my email id is ---
> asjad...@gmail.com, amol.jha...@originenergy.com.au
>
> On 31 May 2012 14:59, NOORAIN ANSARI wrote:
>
>> Dear T
Hello Hilary,
If you want to return the exact 2nd occurrance value, you can use VLOOKUP
like this,
=VLOOKUP(A14,INDEX(A:A,MATCH(A14,A:A,0)+1):INDEX(B:B,65536),2,0)
Regards,
Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor threa
Try a stacked bar chart. Excel will put it as 3 separate bars and you have to
go into the data setting and tell it to swap x and y. You might try a
percentage graph variant. Ten you need a second series to give the cursor with
values like h
45, 2, 53 to show the cursor. Then you tweak the fo
Hi Friends,
Dose any one have any template or format for a capacity tracker, to provide
the teams available capacity project and day wise.
Thanks a lot!!!
Regards,
Mayank
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, lik
Hi , Pls help
On Friday, June 1, 2012 1:15:22 PM UTC+5:30, Kishore wrote:
>
> Hi Excel Gurus,
>
> I have three different excel sheets with data & top of the first at rows
> names are described, all though three excel sheets headings at rows are
> little vary , I would like to merge all these
Dear Mr Tarun,
This is already discussed in this forum. You will find free utilities
available on NSDL website on following link :
https://www.tin-nsdl.com/etds-etcs/eTDS-download-regular.php
Regards
On Fri, Jun 1, 2012 at 1:58 PM, Anil Gawli wrote:
> pls give me the output of the report,
--
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 thre
Hi Asa
Your formula is working to perfection, thanks a lot, just two quick
questions
Kindly explain this bit of the formula taking out "ROW(INDEX(NamesRange,1)"
from the entire formula
Are a Lecturer or some sort?, i always look at the way you explain every
problem that you tackle, its like a lec
Hi Hilary,
It is possible without using countif or Helping column
Please try it
=INDEX($B$2:$B$10,SMALL(IF($A$2:$A$10=A14,ROW($B$2:$B$10),""),ROW($A$2))-1)
with ctrl+shfit+enter
It is also possible through Sumproudct and offset
See attached sheet.
--
Thanks & regards,
Noorain Ansari
www.noor
pls give me the output of the report, means it will give me idea to create.
Regards,
Gawli Anil
On Fri, Jun 1, 2012 at 1:01 PM, Tarun Mondal wrote:
> Sir , please try to solve my problem...i want to calulate income tax of
> around 300 employees and want to create quarterly return report , annua
Thanks Asa
Attached is what i attempted doing, but after testing my formula this
morning with other examples i realised, its doesnt work for all, i will try
your now. thanks
On Fri, Jun 1, 2012 at 1:06 AM, Asa Rossoff wrote:
> Hi Hilary,
>
> Mind sharing your solution with the group?
>
Sir , please try to solve my problem...i want to calulate income tax of
around 300 employees and want to create quarterly return report , annual
return report and form 16 using excel and print out facility should be in
it...please help.
--
FORUM RULES (986+ members already BANNED for violatio
Dear Ayush & Noorian,
If the is a free e-book Can you please send me those e-books to my mail id:
prajakt.pa...@gmail.com
Thanks & Regards,
Prajakt Pande
+971551388482
**
On Thu, May 31, 2012 at 6:55 PM, Ayush Jain wrote:
> Hello everyone,
>
> I hope the book which is being shared in this th
26 matches
Mail list logo