Dear Experts,
I was trying to find the values from Rows and coumns which match the
criteria from the data validation like wise in the attached file. please
suggest me the formulas, which formula might get used for finding the
answer. hope that i could able to elabroate by query correctly,
use sumifs with index and match combination..please find attached solution
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 1:03 PM, Chaya chayamon...@gmail.com wrote:
Dear Experts,
I was trying to find the values from Rows and coumns which match the
criteria from
Hi,
I have to count unique count of date citywise
Kindly help on both ( formula macro)
file is attached
Thanx Regards,
Deepak
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Thank you so much Dear Xls. I was amazed you have used sum function,
Actually i thought of sum function is used in only in numerical values
calculation. today i came to know it is used in many calculation. thank you
for that.
Thanks to all.
Regards,
Chaya
The excel learner :-)
On Thu,
try this
=SUMPRODUCT(N($A$2:$A$83=$T$8)*N($B$2:$B$83=$U$8)*N($C$2:$C$83=$X9)*N($D$2:$D$83=Y$8)*INDEX($A$2:$P$83,,MATCH($V$8,$A$1:$P$1,0)))
On Thu, May 30, 2013 at 1:57 PM, Chaya chayamon...@gmail.com wrote:
Thank you so much Dear Xls. I was amazed you have used sum function,
Actually i
Dear XLS,
It is very useful formula and nice formula I was trying the same with
sumproduct ...but it not happen...
first time i have seen sumifs formula with index and match formula.
Regards,
Prafull Jadhav
MIS executive.
On Thu, May 30, 2013 at 1:57 PM, Chaya chayamon...@gmail.com wrote:
Thanks priti for your formula, it will be a new learning era for me with
varities of formula knowledge.
Regards,
Chaya
The excel learner :-)
On Thu, May 30, 2013 at 2:05 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Dear XLS,
It is very useful formula and nice formula I was
use this as an array formula
=SUM(N(FREQUENCY(IF($C$1:$C$85=F9,$A$1:$A$85,),IF($C$1:$C$85=F9,$A$1:$A$85,))0))
On Thu, May 30, 2013 at 1:34 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi,
I have to count unique count of date citywise
Kindly help on both ( formula macro)
file is attached
Hi Deepak,
Please find attached solution
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 1:34 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi,
I have to count unique count of date citywise
Kindly help on both ( formula macro)
file is attached
Thanx Regards,
Tnanx for ur kind reply!!
working f9.
Regards,
Deepak
On Thu, May 30, 2013 at 2:26 PM, xlstime xlst...@gmail.com wrote:
Hi Deepak,
Please find attached solution
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 1:34 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Dear Priti Madam,
Can you tell me ,
What N stand in below formula ?
On Thu, May 30, 2013 at 2:22 PM, priti verma pritiverma1...@gmail.comwrote:
use this as an array formula
=SUM(N(FREQUENCY(IF($C$1:$C$85=F9,$A$1:$A$85,),IF($C$1:$C$85=F9,$A$1:$A$85,))0))
On Thu, May 30, 2013 at 1:34 PM,
Hi prafull,
The N is a function which converts the value of True and False to 1 and 0
respectively .
My formula calculates the unique occurrences with Frequency, returns 0 or
1 for true and false with N and then Sums the value.
On Thu, May 30, 2013 at 3:20 PM, Prafull Jadhav
Hi guys,
I have a problem with a Macro, I have two sheets, I want to compare the
Items ID of the 2 sheets and if the item doesn't exist in sheet Raw data
but exists in Sheet inventory then I want to copy it to the sheet raw
data in the first next blank row.
My code so far is only this because
firstly install flash player then try to play
and for more information about Embed swf in word file
http://www.walkernews.net/2009/04/24/how-to-embed-swf-file-or-shockwave-flash-object-in-microsoft-word-2007/
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 5:12 PM,
*Thanks.*
-- Forwarded message --
From: xlstime xlst...@gmail.com
Date: Thu, May 30, 2013 at 5:49 PM
Subject: Re: $$Excel-Macros$$ Video in Word File
To: excel-macros@googlegroups.com
firstly install flash player then try to play
and for more information about Embed swf in
Respected Pravin,
I downloaded the file and played the video.It is a nice animation about
traffic rules or road ethics.
Regards,
VIJAYKUMAR
On Thu, May 30, 2013 at 6:10 PM, Pravin Gunjal isk1...@gmail.com wrote:
*Thanks.*
-- Forwarded message --
From: xlstime
Hi,
I have issue with line graph *X axis title* and same is attached.
In sheet1 I have only one record and X axis shows A2 A3 but in Sheet2 I
have many records and it shows value as per column 1. Kindly let me know
what I am doing is correct or anything need to be changed
Thanks in advance.
HI,
Is anybody having an example file how to make family tree.
Suggestions / advice are welcome.
Thanks,
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Respected Pravin,
You can download the file from the following addresses
http://office.microsoft.com/en-us/ctndirectdownload.aspx?AssetID=TC001021967Application=XL,Version=11Result=2
and also you have a youu tube video for that in this link
http://www.youtube.com/watch?v=4Xymxie4beg.
Regards,
Hi Chander,
Change Switch Row/Column
Right click in chart then go to select data then Switch Row/Column
Hope it's fulfill your requirement
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 8:02 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
I have issue with
see if it helps
Sub incluvazios()
Dim i As Long
For i = 2 To Sheets(Inventory).Range(a65356).End(xlUp).Row
If Application.WorksheetFunction.CountIf(Sheets(Raw
Data).Range(a:a), Sheets(Inventory).Range(b i).Value) = 0 Then
Sheets(Raw Data).Range(a65356).End(xlUp).Offset(1, 0).Value =
*DATA ANALYTICS With Qlikview and Excel Experience*
*LOCATION* : *NYC/NJ*
*Position *: *FULL TIME*
*Requirement Details:*
On-Project Responsibilities:
- Understand client requirements, business processes and data
sources and define project objectives accordingly
-
Dear Mr Vijay,
I am unable to download the file from the link given below.
Is it possible to make family tree in an excel file?
Regards
Pravin Gunjal.
-- Forwarded message --
From: P.VIJAYKUMAR vijay.4...@gmail.com
Date: Thu, May 30, 2013 at 8:34 PM
Subject: Re:
I have multiple Pivots in which I need to change the data table range all
together..
Is there any shorter way to do that all at a time?
[cid:image001.jpg@01CE5DE9.FD77C0D0]
Best Regards,
Amit Desai
Disclaimer: This message and its attachments contain
24 matches
Mail list logo