try this
On Thu, Feb 17, 2011 at 9:43 AM, saggi wrote:
> YES ASHISH, I WANT to chnage the formula for incorrect
> option.where i mention incorrect there formula picking wrong values
>
> --
>
> --
> Some important
Ashish Koul
Thank you soo much for the help...
On Wed, Feb 16, 2011 at 8:31 PM, ashish koul wrote:
> check the attachment
>
> On Wed, Feb 16, 2011 at 6:19 PM, Jagadeesh B S wrote:
>
>> Hello all
>>
>>
>>
>> I have date like
>>
>> Cash in Banks - Oper. Accts.
>>
>> 10
>>
>> -
>>
>> 100099
YES ASHISH, I WANT to chnage the formula for incorrect
option.where i mention incorrect there formula picking wrong values
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and li
try this
Sub test()
Dim i, j As Long
Dim s As String
j = 1
For i = 3 To Sheets(1).Range("a2").End(xlDown).Row
s = ""
k = i
Sheets(1).Range("h" & j).Value = Sheets(1).Range("a" & i).Value
Do Until Sheets(1).Range("a" & i).Value <> Sheets(1).Range("a" & i +
1).Value
s = s & "-" & Sheets(1).Range("c"
can you please send the sample workbook
On Thu, Feb 17, 2011 at 3:03 AM, RFisher wrote:
> Hi everyone,
> It's great to find a list with such a helpful group. I have a
> question. I received some recent weather data (precipitation in mm)
> for weather stations in Canada; however, the file isn
Thanks Ashish.
On Wed, Feb 16, 2011 at 1:12 AM, ashish koul wrote:
> see if this helps
>
>
> Sub growth()
> Dim i As Long
> i = Range("s21").End(xlDown).Row
> Columns("S:S").Select
> Selection.Insert Shift:=xlToRight
> Range("S21").Select
> ActiveCell.FormulaR1C1 = "Growth"
>
I want to import data from SQL server 2005 into Excel 2007 using
Data=>from other sources=>From SQL server. I am able to import
complete table (e.g. Item) but there are too many unnecessary fields
as well as records which also get imported. I want to filter the data
before importing into excel but
Hi everyone,
It's great to find a list with such a helpful group. I have a
question. I received some recent weather data (precipitation in mm)
for weather stations in Canada; however, the file isn't quite
formatted for how I need it in order to analyse it. The excel file is
formatting like the fol
welcome.
On Wed, Feb 16, 2011 at 8:59 PM, Rajesh K R wrote:
> Hi Ashish
> Thank You very much.I checked the code it is working well.
>
> Regards & Thanks
> Rajesh Kainikkara
>
>
> On 2/16/11, ashish koul wrote:
> > Sub tests()
> > Dim i As Long
> >
> > For i = 1 To Sheets(2).Range("
IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C:C,A:A,A4,B:B,"Substandard"))=SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),"Doubtful",IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C
Hello All,
I am new to this forum..
Can any one of the experts provide me with the call center call volume
forecasting template for a long term basis and also a short term
basis. It would be helpful if any one let me know the procedure or if
any other important tips to be considered for forecast
Maximum 4 classifications
1) Regular
2) Substandard
3) Doubtful
4) Loss
On Tue, Feb 15, 2011 at 8:34 PM, ashish koul wrote:
> will it be these three classifications only
>
>
> On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad
> wrote:
>
>> Thanks *Ashish *for reply but can you please provide formu
Hi Ashish
Thank You very much.I checked the code it is working well.
Regards & Thanks
Rajesh Kainikkara
On 2/16/11, ashish koul wrote:
> Sub tests()
> Dim i As Long
>
> For i = 1 To Sheets(2).Range("b1").End(xlDown).Row
> If Application.WorksheetFunction.CountIf(Sheets(1).Range("b:b"),
> Sheet
https://groups.google.com/group/excel-macros/subscribe?hl=en
click on unsubscribe
On Wed, Feb 16, 2011 at 7:31 PM, NOURREDINE BELHAJ <
nourredine.bel...@gmail.com> wrote:
> Hi All,
>
> I would like to be taken out from this distro list.
>
> Could you please help with this ?
> Thanks
> --
> Re
check this link
http://vbnet.mvps.org/index.html?code/internet/urldownloadtofilenocache.htm
see if it helps
On Tue, Feb 15, 2011 at 10:27 PM, San Pat wrote:
> I am using a web url.
>
> Is there anyway I can covert/save web url in picture format and then call
> it in the below function?
>
> Reg
j1 start date
j2 end date
monday =I
F(TEXT(J1,"")<>"Monday",NETWORKDAYS(J1,J2)/5,INT(NETWORKDAYS(J1,J2)/5)+1)
saturday = INT(((J2-J1)-NETWORKDAYS(J1,J2))/2)
On Wed, Feb 16, 2011 at 7:10 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:
> hi ashish,
>
> Can you please help t
Sub tests()
Dim i As Long
For i = 1 To Sheets(2).Range("b1").End(xlDown).Row
If Application.WorksheetFunction.CountIf(Sheets(1).Range("b:b"),
Sheets(2).Range("b" & i).Value) = 0 Then
Sheets(2).Select
Sheets(2).Range("b" & i).Select
Selection.EntireRow.Copy
Sheets(1).Select
Sheets(1).Cells(Sheets(
Hi
Thanks for ur fast reply, now it copying the data in column"B" if I
want to copy the entire raw how to change the code.
Regards & Thanks
Rajesh kainikkara
On 2/16/11, ashish koul wrote:
> Sub tests()
> Dim i As Long
>
> For i = 1 To Sheets(2).Range("b1").End(xlDown).Row
> If Application.Works
hi you wanted to change the formula for incorrect option or you wanted to
mark the status correct or incorrect
On Wed, Feb 16, 2011 at 5:50 PM, saggi wrote:
>
> Thanks Ashish for your reply, but it no going to solve my purpose.
>
> Plz go through the excel and see wht kind of result i am looking
check the attachment
On Wed, Feb 16, 2011 at 6:19 PM, Jagadeesh B S wrote:
> Hello all
>
>
>
> I have date like
>
> Cash in Banks - Oper. Accts.
>
> 10
>
> -
>
> 100099
>
> Cash in Banks - Time Deposits
>
> 101000
>
> -
>
> 101099
>
> Restrictive Cash - Current
>
> 102000
>
> -
>
> 102099
>
Sub tests()
Dim i As Long
For i = 1 To Sheets(2).Range("b1").End(xlDown).Row
If Application.WorksheetFunction.CountIf(Sheets(1).Range("b:b"),
Sheets(2).Range("b" & i).Value) = 0 Then
Sheets(1).Cells(Sheets(1).Range("b1").End(xlDown).Row + 1, 2).Value =
Sheets(2).Range("b" & i).Value
End If
Next i
Hi Experts
How can select data from sheet2 which don't exist in sheet1 and copy
the entire raw and paste in sheet1. Pls find the attached file to get
more details
Regards
Rajesh Kainikkara
--
--
Some important links
Hi All,
I would like to be taken out from this distro list.
Could you please help with this ?
Thanks
--
Regards
Nourredine BELHAJ
+41783081988
+33665248617
--
--
Some important links for excel users:
1. Follow us
hi ashish,
Can you please help to find out how many mondays and saturdays are
present for the same above query.
01/16/2011 to 02/16/20111
Thanks,
Raj
On Tue, Feb 15, 2011 at 12:46 PM, N Pradhan wrote:
> Thank you very much for the prompt reply Sir.
>
>
>
> - Original Message -
>
> *
http://chandoo.org/wp/excel-dashboards/
On Wed, Feb 16, 2011 at 5:57 PM, johnson john wrote:
> Dear Members,
>
> Can any one Pls. share few Excel Sales Dash Boards? It would be of great
> help to me in my day in and day out professional life.
>
> Best Regards.,
> Johnson CA
>
> --
>
> ---
Thanks Stuart - now working perfectly - until the next problem
Thanks once again
BJ
On Feb 16, 7:16 am, Stuart Redmann wrote:
> > On Feb 15, BJthebear wrote:
> > > I have written a sub routine to add a name to a dynamic list but I
> > > have three problems with it and would be grateful for some
Dear Members,
Can any one Pls. share few Excel Sales Dash Boards? It would be of great
help to me in my day in and day out professional life.
Best Regards.,
Johnson CA
--
--
Some important links for excel users:
1
Thanks Ashish for your reply, but it no going to solve my purpose.
Plz go through the excel and see wht kind of result i am looking for.
Thanks in advance
--
--
Some important links for excel users:
1. Follow us on
Hi Paul,
Thanks for the detailed info. Not too wordy at all. I hadn't realised that
there were 2 different syntaxes (syntii?) - Sheets(1) and Sheet1. That makes
sense now.
So then Sheets(1).Name will always return something, (though not always what
you'd expect) because it is just the first she
use this
IF(MIN(G2:K2)=0,SMALL(G2:K2,COUNTIF(G2:K2,0)+1),MIN(G2:K2))
On Wed, Feb 16, 2011 at 2:42 PM, Vj Realsaggi wrote:
> Dear Team,
>
> Kindly go through Attached Xl,
>
> In category Column i insert nested if formula, which give me minimum Column
> Values comparing "Sum of Quantity " To 5 o
Dear all,
In a big table I need that *all cells* changes it color, depending formula
,
cell under study (file, row)
*if (*row*$20="c";$F*file*;$G*file*) *
I want to extend the conditional format to all the table but without change
all the other formants,
Thanks and best regards
--
Nuri
Dear Team,
Kindly go through Attached Xl,
In category Column i insert nested if formula, which give me minimum Column
Values comparing "Sum of Quantity " To 5 other Column.
Regards
Vijay
--
--
Some important links
> On Feb 15, BJthebear wrote:
> > I have written a sub routine to add a name to a dynamic list but I
> > have three problems with it and would be grateful for some advice.
> >
> > Sub InputNewUser()
> >
> > Dim Newuser As String
> > Dim nextRow As Long
> >
[snipped some code]
> > 'Ask for name of
=VLOOKUP(IF(SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))>K8,SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))-
K8,SUM(VLOOKUP(
Thank you very much Aashishbhai...incredible!
nemi
On Feb 15, 8:47 pm, ashish koul wrote:
> VLOOKUP(IF(VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)>=
> 1440,VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)-1440,VLOOKUP(
Dear All,
my Question is we can use use two header in p. Table.?
--
Thanks & Regards
Anil Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twi
36 matches
Mail list logo
