Key Skill : Advanced Knowledge of XL ( Lookup, Pivot, Count if , Sum
if )
Prefer : Analytical bend of mind
Location: Sec-60 Noida,
Salary : 2-3 Lacs ( Depends on Work Exp)
Mail me @ realsa...@gmail.com
--
--
Some
Oops. That was supposed to be:
=ROUNDDOWN(A2*2,-1)/2 & " - " & (ROUNDDOWN(A2*2,-1)/2)+4
Dave.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/excelda
Hi Sarah,
A way of using worksheet formulas without a lookup table:
If your data is in A2, paste this formula into an adjacent cell:
=ROUNDDOWN(H16*2,-1)/2 & " - " & (ROUNDDOWN(H16*2,-1)/2)+4
It's a bit cumbersome, but gives the answer and format you need.
Regards - Dave.
--
-
Its working good. thanks..
regards
kannan V
On Fri, Jun 10, 2011 at 7:43 AM, STDEV(i) wrote:
> =OFFSET($A$1,MATCH(E2,$B$2:$B$8,0),0)
> or
> =INDEX($A$2:$B$8,MATCH(E2,$B$2:$B$8,0),1)
>
>
>
>
>
> On Fri, Jun 10, 2011 at 3:14 AM, hanumant shinde
> wrote:
>
>> Hi friends,
>>
>> this is really
Johnny
Can you please tell me which code you are talking about workbook which i
attached as answer to this post is having only formulas
can you attach your workbook. and brief description about ur problem
On Thu, Jun 9, 2011 at 11:41 PM, Johnny wrote:
> Ash
>
> Can you post the VBA code? I d
=OFFSET($A$1,MATCH(E2,$B$2:$B$8,0),0)
or
=INDEX($A$2:$B$8,MATCH(E2,$B$2:$B$8,0),1)
On Fri, Jun 10, 2011 at 3:14 AM, hanumant shinde wrote:
> Hi friends,
>
> this is really really urgent and very very very IMP for me so quick help
> would
> be really really appreciated.
>
> Name No
> a 1
> s 2
Can anyone tell me why this works:
Sub LoadActuals(a As Worksheet)
...
a.ListObjects(1).DataBodyRange.Font.Name = "Arial"
...
End Sub
but this gets Error 424 Object required:
Sub LoadActuals(a As Worksheet)
...
With a.ListObjects(1).DataBodyRange
...
.Font.Name = "Arial"
...
End With
End Sub
??
Hi friends,
this is really really urgent and very very very IMP for me so quick help would
be really really appreciated.
Name No
a 1
s 2
d 3
f 4
g 5
h 6
j 7
data is like above i.e. first Name and then No. i want to Vlookup for No.
values
and get Name but without moving any col or modi
Ash
Can you post the VBA code? I downloaded the example but it is not in the
workbook. I need to use a similar code for data extraction also. This code
might help me, too.
Thanks
Johnny
--
--
Some important l
DEF
Highligh the column then go to "DATA" then "Text to Column". You will have 2
choices, Delimited or Fixed. I don't know how the data is so I am guessing
no commas. I would choose Delimited. Click next. Click tab as I think there
is no spaces. If so then click spaces too. click next then
try this
c6= =SUMIFS('Sale Data-10-11'!E:E,'Sale Data-10-11'!A:A,Final!B6,'Sale
Data-10-11'!D:D,">="&Final!$C$4,'Sale Data-10-11'!D:D,"<="&Final!$C$5)
On Thu, Jun 9, 2011 at 7:21 PM, Kal xcel wrote:
> Dear Experts,
>
> I need a help to get product wise total sale between two dates.
>
> Please
Sub CurRegLoopHighLightBorderTopBot()
Dim objArea As Object
For Each objArea In ActiveSheet.UsedRange.SpecialCells(2).Areas
With objArea: .Rows(1).Cells.Interior.Color =
65535: .Rows(.Rows.Count).Cells.Interior.Color = 15773696: End With
Next
End Sub
On Jun 9, 10:42 am, Chan
Hi All,
I recieved this mail regarding opeing with Zensar today, forwarding it to
group . if some is looking for the job HE/SHE can apply
Please find the job details below
Dear ashish,
Greetings from Zensar!
Zensar Technologies (www.zensar.com) is among the top 25 software service
providers
Please attached Your Sample WOrksheet
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kat
Sent: Wednesday, June 08, 2011 6:49 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Excel Macro- source series for a chart from
Thanks for the reply. How to put loop if we have more than one current
region. Thanks!
Regards,
Chandra Shekar B
On Wed, Jun 8, 2011 at 8:06 PM, Rajan_Verma wrote:
> HI
>
> Please use this Code
>
>
>
> Sub HighLight()
>
> Dim rng As Range
>
> ActiveCell.CurrentRegion.Select
>
> Set rng = Selec
Hi Ashish,
Exactly what I wanted. Didn't know about the .TextFrame part.
Thanks!
Regards - Dave.
Date: Thu, 9 Jun 2011 11:10:06 +0530
Subject: Re: $$Excel-Macros$$ Application.Caller
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
below code will help you in extracting the tex
Thanks Ayush.
Best Regards,
DILIPandey
On 6/8/11, Ayush wrote:
> Dilip,
>
> Ok, I will approve the external link if it is opening form for that specific
> job only.
> I hope that is fine.
>
> Dear Group,
> Start posting jobs :)
>
> Regards
> Ayush Jain
> Group Manager
>
> --
> --
17 matches
Mail list logo
