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 :
Thank you very much Aashishbhai...incredible!
nemi
On Feb 15, 8:47 pm, ashish koul koul.ash...@gmail.com 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)=
=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))-
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 new user
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
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
--
Nuria
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 realsa...@gmail.com 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
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
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
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:
Thanks Stuart - now working perfectly - until the next problem
Thanks once again
BJ
On Feb 16, 7:16 am, Stuart Redmann dertop...@web.de 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
http://chandoo.org/wp/excel-dashboards/
On Wed, Feb 16, 2011 at 5:57 PM, johnson john johnsond...@gmail.com 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
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 nalini.pradha...@gmail.comwrote:
Thank you very much for the prompt reply Sir.
-
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
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
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
End
check the attachment
On Wed, Feb 16, 2011 at 6:19 PM, Jagadeesh B S jagg...@gmail.com 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
Marketable
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 realsa...@gmail.com wrote:
Thanks Ashish for your reply, but it no going to solve my purpose.
Plz go through the excel and see wht kind of
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
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 to find out
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 myitems2...@gmail.com 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
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
--
Regards
Hi Ashish
Thank You very much.I checked the code it is working well.
Regards Thanks
Rajesh Kainikkara
On 2/16/11, ashish koul koul.ash...@gmail.com wrote:
Sub tests()
Dim i As Long
For i = 1 To Sheets(2).Range(b1).End(xlDown).Row
If
Maximum 4 classifications
1) Regular
2) Substandard
3) Doubtful
4) Loss
On Tue, Feb 15, 2011 at 8:34 PM, ashish koul koul.ash...@gmail.com wrote:
will it be these three classifications only
On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad
aamirshahza...@gmail.comwrote:
Thanks *Ashish *for
welcome.
On Wed, Feb 16, 2011 at 8:59 PM, Rajesh K R rajeshkainikk...@gmail.comwrote:
Hi Ashish
Thank You very much.I checked the code it is working well.
Regards Thanks
Rajesh Kainikkara
On 2/16/11, ashish koul koul.ash...@gmail.com wrote:
Sub tests()
Dim i As Long
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
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
Thanks Ashish.
On Wed, Feb 16, 2011 at 1:12 AM, ashish koul koul.ash...@gmail.com 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
can you please send the sample workbook
On Thu, Feb 17, 2011 at 3:03 AM, RFisher fishe...@uregina.ca 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;
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 i).Value
i = i + 1
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
Ashish Koul
Thank you soo much for the help...
On Wed, Feb 16, 2011 at 8:31 PM, ashish koul koul.ash...@gmail.com wrote:
check the attachment
On Wed, Feb 16, 2011 at 6:19 PM, Jagadeesh B S jagg...@gmail.com wrote:
Hello all
I have date like
Cash in Banks - Oper. Accts.
10
-
try this
On Thu, Feb 17, 2011 at 9:43 AM, saggi realsa...@gmail.com wrote:
YES ASHISH, I WANT to chnage the formula for incorrect
option.where i mention incorrect there formula picking wrong values
--
--
34 matches
Mail list logo