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 1
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 anot
start writing your own macro library
On May 3, 3:17 pm, D Kumar 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
>
> ***All thing
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,
0)-1,IF(B8="Party3",MAT
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 :
http://twitter.com
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 wrote:
> Hi friends,
>
> Plea
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
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 wrote:
> try:
>
> Sheets("MySheet").UsedRange.PageBreak = xlPageBreakNone
>
>
> --
> On May 4, 6:09 pm, Sunda
On 5 Mai, 11:18, Andy 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", "Mo
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
MBA-HR,B.Co
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 981092974
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", _
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 wrote:
> Hi Dheeraj,
>
> You have done half of the work...You have sorted the data a
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 ou
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 wrote:
> Harry..
>
>
> 2003 format
>
>
> On Tue, May 4, 2010 at 10:11 AM, Harpreet Singh Gujral <
> harpreetgu
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,
>
> --
> -
Hi Rajeev,
Sorry for replying late..
Please send the sample file..
Regards,
Andy
On Wed, May 5, 2010 at 1:10 AM, Rajeev Nandan wrote:
> Dear Group Member,
> Please help me to calculate incentive for each technician. I have
> tried to apply "countifs" but could not succeeded. Please suggest if
>
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 rang
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 :
http://twitter.com/exceldailytip
19 matches
Mail list logo
