hey guys here I attached a file, if u have any solution please help me .
Thanking you,
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi Dheeraj,
You have done half of the work...You have sorted the data as per the date
and item.
Now the only thing to do is to add the following formula in Sheet 2 in
Column Qty
=VLOOKUP(A4,Sheet1.$B$3:$C$27,2,0)
What this does is it picks the first instance of the Item it encounters in
the
Hi Rajeev,
Sorry for replying late..
Please send the sample file..
Regards,
Andy
On Wed, May 5, 2010 at 1:10 AM, Rajeev Nandan rajeev1...@gmail.com wrote:
Dear Group Member,
Please help me to calculate incentive for each technician. I have
tried to apply countifs but could not succeeded.
Hi,
See attached.
Regards - Dave.
Date: Wed, 5 May 2010 10:27:42 +0400
Subject: $$Excel-Macros$$
From: dbank...@gmail.com
To: excel-macros@googlegroups.com
hey guys here I attached a file, if u have any solution please help me .
Thanking you,
--
can any one help me out i m waiting for your response ..otherwise i have to
apply these thing in all thousand company and its a time taking
On Wed, May 5, 2010 at 9:57 AM, Vikas Chouhan vikask...@gmail.com wrote:
Harry..
2003 format
On Tue, May 4, 2010 at 10:11 AM, Harpreet Singh Gujral
how to open a closed excel file with a password lock
please guys help me out
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
hi all
If i want to pull the dates also in the seond sheet how to pull that dates
pls help.
Actually i want to pul the data right side of the vlookup data.
Pls help
On Wed, May 5, 2010 at 1:41 PM, Aindril De aind...@gmail.com wrote:
Hi Dheeraj,
You have done half of the work...You have
Heya,
It's as simple as the subject states but I can't seem to find an
answer anywhere.
My code at the moment is:
Worksheets(Array(Sat EEA, Sun EEA, Mon EEA, Tue EEA, Wed
EEA, Thu EEA, _
Fri EEA, Sat NonEEA, Sun NonEEA, Mon NonEEA, Tue
NonEEA, Wed NonEEA, _
Thu NonEEA, Fri
Hi Dheeraj,
Attached is the solution you require.
Further to this, I have also considered the fact that if the data is NOT
SORTED, then still it gives right answer.
Get back to me in case of any challenge(s).
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91
Dear Rajeev,
I can assume that you are using version above then Excel 2003 to apply
CountIfs.
Alternatively, you can use Countif with Array functionality or some other
function like Sumproduct.
If possible, share the test file with the Group.
--
Thanks Regards,
DILIP KUMAR PANDEY
On 5 Mai, 11:18, Andy andyr...@hotmail.co.uk wrote:
Heya,
It's as simple as the subject states but I can't seem to find an
answer anywhere.
My code at the moment is:
Worksheets(Array(Sat EEA, Sun EEA, Mon EEA, Tue EEA, Wed
EEA, Thu EEA, _
Fri EEA, Sat NonEEA, Sun NonEEA, Mon
Hi friends,
Please help.
How to automatically set the range to clear the pagebreaks in different
data.
Thanks,
Sundarvelan
On Wed, May 5, 2010 at 5:42 AM, siti Vi villager.g...@gmail.com wrote:
try:
Sheets(MySheet).UsedRange.PageBreak = xlPageBreakNone
--
On May 4,
Hi Champs,
I need Urgent help. Please send .net book
--
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
Dear Chandrabhan Singh,
What do you want to do with the attendance sheet. No details are given.what
is the problem. Don't mention your telephone numbers in mails as they are
very likely to be misused.
Regards,
Vijaykumar
On Wed, May 5, 2010 at 2:22 PM, Born to Win cs4...@gmail.com wrote:
Hi
I have attached sample file. I want formula for picking up rate from
excel sheets. Thanks in advance
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
You can use both Hlookup and match to solve your problem, try using
this formula in the E8 cell:
=HLOOKUP(D8,IF(B8=Party1,Party1!2:180,IF(B8=Party2,Party2!
2:180,IF(B8=Party3,Party3!2:180,0))),IF(B8=Party1,MATCH(C8,Party1!
A:A,0)-1,IF(B8=Party2,MATCH(C8,Party2!A:A,
start writing your own macro library
On May 3, 3:17 pm, D Kumar dkumar9...@gmail.com wrote:
Hi All,
I am not a perfect in excel but i have a little bit knowledge of some
formulas, is anyone in group can help me to learn more about excel with
ready reference.
Regards
Dheeraj S Chauhan
Dear Mr. kumar
my requirement is to make a attendance sheet in which i want to show if any
body is present then his status with Arrival timing same to be follow with
every status i have tried concatenation but timing is not showing in correct
format.
In one file i want to Show Leave status in
Can you tell me, what is the meaning of following argument in the
solution provided?
'Inv for Rate'!D8
With Regards,
Hitesh
From: excel-macros@googlegroups.com
[mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul
Sent: Wednesday, May 05, 2010
19 matches
Mail list logo