Thanks a lot :-)
On Fri, Jul 1, 2011 at 6:06 PM, ashish koul koul.ash...@gmail.com wrote:
try the attachment
On Fri, Jul 1, 2011 at 3:50 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
I need a formula which need to ignore weekends. Thanks
For Ex:
A1=01/07/2011 - Input
You are welcome. . .
Regards,
DILIPandey
On 7/2/11, Atul atul_pate...@yahoo.com wrote:
Thnaks you Pandeyji. ITs working fine
On Jun 29, 2:45 am, Dilip Pandey dilipan...@gmail.com wrote:
Hi Atul,
You were clear in the first email itself. It is my mistake that I had
overlooked the point.
hi kurikkal
get files from the link below, i had uploaded there. i tried to
attach files but due to excess size of files, it cant be attached .
http://cmaankur.webs.com/apps/documents/
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not
Use this Function
Function ConCat(ParamArray arr() As Variant) As String
For i = 0 To UBound(arr())
ConCat = ConCat Format(arr(i), arr(i).NumberFormat)
Next
End Function
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ICWAI Help
Sent:
See if it helps
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Friday, July 01, 2011 5:17 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ need required for data validation value query
sorry , i forget to attach a
*
*
Chandra Singh Bohra
Champawat
Uttrakhand
09717336333
chandu...@gmail.com
chandu...@rediffmail.com
chandu.u...@yahoo.co.in
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
Hi All,
Thanks for the prompt support.
Regards
Pooja Sharma
Sent from BlackBerry® on Airtel
-Original Message-
From: ashish koul koul.ash...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 1 Jul 2011 21:24:01
To: excel-macros@googlegroups.com
Reply-To:
Hi Ankur,
Nice Sharing...Good stuff thank u so much...
*Best Regards,*
*Venkat*
*
*
On Sat, Jul 2, 2011 at 3:17 PM, ankur ankurpande...@gmail.com wrote:
hi kurikkal
get files from the link below, i had uploaded there. i tried to
attach files but due to excess size of files, it cant be
Dear Chandra Singh,
I think you are very new to excel , this group will be more profitable for
you,
See if it help,
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Singh Bora
Sent: Saturday, July 02, 2011 4:41 PM
To:
Hi All.
As m working in a import house for that i have to sales bills on daily basis
i just want a help that makes me easy to make that
If someone tell that how to make 5 random numbers selection between 197.001
to 203.999 which gives the total of 1000.000
Please help meurgent guys
Cheers
Hi All.
As m working in a import house for that i have to sales bills on daily basis
i just want a help that makes me easy to make that
If someone tell that how to make 5 random numbers selection between 197.001
to 203.999 which gives the total of 1000.000
Please help meurgent guys
Cheers
See if it helps
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anshul Gupta
Sent: Saturday, July 02, 2011 7:39 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help required!!
Hi All.
As m working in a import house for
Hi
I know a bit of SQL.. can write a bit of complicated query..
At work, I don't have Write right to SQL server.. because my role is to
investigate and report.
I would create a stored procedure and simply bring records I want using
'From other source' in Data tab.
But that's not
Hi
I can think of a way to write this macro.
What I want is to find any possible combination of numbers from given
numbers to a given total. For example,
Let's say
Given numbers: 1, 2, 3, 4, 5
total = 30
Will it be possible to get any combination of Given numbers adding up to
30?
Sir,
Do u have any idea of auto filling magic squre for a particular sum total.
Iam interested
to know it. Thanks if u could help.
-R.Karunanithi
--- On Sat, 7/2/11, Rajan_Verma rajanverma1...@gmail.com wrote:
From: Rajan_Verma rajanverma1...@gmail.com
Subject: RE: $$Excel-Macros$$ Urgent
HI,
I AM INTERESTED TO KNOW HOW TO AUTO FILL A 4X4 MAGIC SQUARE FOR ANY
SUM WITH NO NUMBER REPEATS FROM A SERIES OF NUMBERS.
THANKS IN ADVANCE
-R.KARUNANITHI,2/7/2011.
--
--
Some important links for excel users:
Hi Dilip,
The formula only returned the first sheet, I need it to sum all sheets
with reference to different ranges for the same criteria , and summing
different ranges.
I tried SUMPRODUCT(SUM(IF...
I tried SUM(IF and inserting a + before each proceeding IF
Neither of those worked.
What about
see if it helps
SUMIF($D$2:$D$81,G3,E2:E81)+SUMIF(Sheet3!D:D,Sheet1!G3,Sheet3!E:E)+SUMIF(Sheet2!D:D,Sheet1!G3,Sheet2!E:E)
On Sat, Jul 2, 2011 at 9:52 PM, Susan sunni...@gmail.com wrote:
Hi Dilip,
The formula only returned the first sheet, I need it to sum all sheets
with reference to
try this
http://www.ozgrid.com/forum/showthread.php?t=83016page=1
On Sat, Jul 2, 2011 at 9:09 PM, Markkim mark@gmail.com wrote:
Hi
I know a bit of SQL.. can write a bit of complicated query..
At work, I don't have Write right to SQL server.. because my role is to
investigate and
Dear Susan,
You select all sheets(Group it ) and then try this formula.You may get
result in all sheets
*Best Regards,*
*Venkat*
*
*
On Sat, Jul 2, 2011 at 9:52 PM, Susan sunni...@gmail.com wrote:
Hi Dilip,
The formula only returned the first sheet, I need it to sum all sheets
with
Hi Susan,
Here's two ways to solve it
1. With a simple combo of sumif formulas
=SUMIF(D2:D6,C Wagner,E2:E6)+SUMIF(Sheet3!D11:D18,C Wagner,Sheet3!
E11:E18)+SUMIF(Sheet2!D13:D23,C Wagner,Sheet2!E13:E23)
2. With an array formula.
{=SUM((D2:D11=C Wagner)*(E2:E11)+(Sheet3!D11:D20=C
I mean copy without the curly braces. They are inserted by Excel when
you use the CSE keys
On Jul 2, 9:22 pm, Susan sunni...@gmail.com wrote:
Hi Dilip,
The formula only returned the first sheet, I need it to sum all sheets
with reference to different ranges for the same criteria , and summing
Can you post an example? Not sure how a magic square works.
Sam Mathai Chacko
On Jul 2, 9:17 pm, karunanithi ramaswamy era_...@yahoo.com wrote:
HI,
I AM INTERESTED TO KNOW HOW TO AUTO FILL A 4X4 MAGIC SQUARE FOR ANY
SUM WITH NO NUMBER REPEATS FROM A SERIES OF NUMBERS.
THANKS IN ADVANCE
Unable to open file
Sam Mathai Chacko
On Jul 2, 1:45 pm, ali abbas tigarman...@gmail.com wrote:
Dear All,
Attached a word 2007 file that contain a permanant/protected HEADER AND
FOOTER.
Can anyone know how to protect Header and Fooer in Word and Excel 2007 ?.
Please check this file and
No dude its not owrking proerly which buttun you give to generate thats is
also not working and the random numbers are not coming in decimels there
coming in proper figure.
Anyone else who can help me out buddy's
please help me out
cheers!!!
On Sat, Jul 2, 2011 at 8:25 PM, Rajan_Verma
http://support.microsoft.com/kb/888184
On Sat, Jul 2, 2011 at 10:47 PM, Venkatesan c venkat1@gmail.com wrote:
Dear Tigarman,
Find attached protected headerfooter...
way to protect Just check the attached image..
*Best Regards,*
*Venkat*
*
*
On Sat, Jul 2, 2011 at 2:15 PM,
Recruiter dilpreet.bha...@zensar.in
Greetings!!
This is with reference to your resume on a job portal which is an excellent
match for an opportunity in VBA development with Zensar Technologies at our
PUNE office.
Please mail me your updated resume alongwith the following details if this
hi
can you explain it in detail
On Fri, Jul 1, 2011 at 11:44 AM, Rash rashmiv.ni...@gmail.com wrote:
Hi I am using the attached bill of material. I need to search the whole
sheet to find unique product numbers. Explained in more detail in the
attached .docx file.
Attached .xls is my excel
28 matches
Mail list logo