Dear Seniors,
I want total count of unique User ID's. These are 594 ID's in data. But
unique is 308. I want only unique user ID's count. and the output is 308
which i want. kindly help. and find the attachment.
Thanks,
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Dear Ashish,
See d attached workbook.
Wam Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Mon, Sep 23, 2013 at 11:48 AM, Ashish Kumar
kumar.ashish...@gmail.com wrote:
Dear Seniors,
I want total count of unique User ID's.
Dear Anil,
Can you please help me to reslove this query through Excel formula.
Thanks,
Ashish
On Monday, September 23, 2013 12:15:31 PM UTC+5:30, अनिल नारायण गवली wrote:
Dear Ashish,
See d attached workbook.
Wam Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software
Dear Ashish,
find the same with formula.
*Regards,
Prafull Jadhav
9920553518*
On Mon, Sep 23, 2013 at 1:39 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Anil,
Can you please help me to reslove this query through Excel formula.
Thanks,
Ashish
On Monday, September 23, 2013
Thanks for the sheet - but it doesn't address the problem
I have attached a better example (I hope)
regards
John
On Monday, 23 September 2013 07:19:33 UTC+1, barnwal wrote:
Dear Johnny
PFA
Regards
Deepak
On Sun, Sep 22, 2013 at 9:19 PM, ashish koul
=SUM(IF(FREQUENCY(MATCH(A2:A595,A2:A595,0),MATCH(A2:A595,A2:A595,0)),1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Kumar
Sent: Monday, September 23, 2013 11:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Total Count of
Can somebody help me calculating euclidean distance for the attached
sample file.
Column 2, 3 4 contains X, Y Z information of samples for which the
euclidean distance is required to be calculated.
The formula for the Euclidean distance in 3d 2d are mentioned below.
I am finding difficult
Sorry for my Fault, I translate PAIS in portuguese to country and this can
mess your thoughts but nevertheless you were precise! I adapt just the name
and works beutifully!
I am thankful for your help.
Follow the answer.
SELECT TOP 20 MIDASQ12013.PAIS AS Expr1, MIDASQ12013.ATC3_COD,
I pull data for individual customers from a source system into an Excel
workbook. I have a separate Excel workbook template that contains macros,
which allow me to reformat the data in the source workbook. I am trying to
add another macro that will do additional formatting, but when trying to
Dear Friends,
Assume that following values are in A1,A2, A3 . Column.
I want to split the Alphabetic Name in B1, B2.. Column Numbers in C
Column. Pl. help.
Alphanumeric Data Expected Answer A Column B Column C Column
Dhananjay420 Dhananjay 420 Ramesh007 Ramesh 7 Prashant786
=LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A10123456789))-1)
=RIGHT(A1,LEN(A1)-LEN(E1))
see if it helps
On Mon, Sep 23, 2013 at 8:52 PM, Dhananjay Pinjan dppin...@gmail.comwrote:
Dear Friends,
Assume that following values are in A1,A2, A3 . Column.
I want to split the Alphabetic Name in
Do u want a formula which will convert image into excel ?
Regards
Ashish
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Mani Manju manisw...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 23 Sep 2013 08:21:17
To: excel-macros@googlegroups.com
Reply-To:
yes i need that and i need to work as same as the output conversion data
which i attached
On 23 September 2013 22:36, koul.ash...@gmail.com wrote:
**
Do u want a formula which will convert image into excel ?
Regards
Ashish
Sent on my BlackBerry® from Vodafone
Hello experts,
I have some doubt in VLOOKUP, that how can i get lookup value from previous
cell?. please find the attached sheet and advice.. thanks a lot.
Thanks
Satiq
--
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
you can use index match if you want to do this only with Vlookup
You can try This
=VLOOKUP(I2,CHOOSE({1,2,3,4},D:D,C:C,B:B,A:A),3,0)
On Mon, Sep 23, 2013 at 11:09 AM, Satiqjaffar ali
satiqjaffar...@gmail.comwrote:
Hello experts,
I have some doubt in VLOOKUP, that how can i get lookup value
Hi Ashish,
Use this =SUMPRODUCT(1/COUNTIF(A2:A595,A2:A595))
Regards,
Excel Beginner
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Kumar
Sent: Monday, September 23, 2013 11:49 AM
To:
*Hi Experts / Ravinder / Anil,*
I need a small update on that file, which you guys had updated.
I need to collect data from almost 500 + files, and the macro is doing it's
job pretty well. :)
But facing a new issue, suppose I am collecting this data from the slave
files on readonly mode,
Can someone please tell me how to create a formula that will transpose the
today function to a 8 digit numerical value ? The today function would be
in cell A1... B1 would return the value.
Example:
A1 = 9/23/213
B1 = 20130923
Thanks.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
return the value.
Example:
A1 = 9/23/213
B1 = 20130923
Thanks.
--
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 @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
javascript:
wrote:
Can someone please tell me how to create a formula that will transpose
the today function to a 8 digit numerical value ? The today function
would be in cell A1... B1 would return the value.
Example:
A1 = 9/23/213
B1 = 20130923
Thanks.
--
Are you =EXP(E:RT
the value.
Example:
A1 = 9/23/213
B1 = 20130923
Thanks.
--
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 @
https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel
FORUM RULES
1
the today function to a 8 digit numerical value ? The today function
would be in cell A1... B1 would return the value.
Example:
A1 = 9/23/213
B1 = 20130923
Thanks.
--
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
Dear Friends,
As i had attached two files one is the source file named Attendance
workbook and another is output .
in attendance file there are no. of sheets which contain all the
attendance data.
I want that data should convert as output file as attached with the
name output file.
Note : In
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Monday, September 23, 2013 9:47 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ How to split Alphabetic Numeric data in
different cells
Dear Indrajit,
Kindly send it across the Slave files also so that we can test it from out side.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 24, 2013 at 3:48 AM, Indrajit $nai talk2indra...@gmail.com wrote:
Hi
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 24, 2013 at 10:01 AM, अनिल नारायण गवली
gawlianil8...@gmail.com wrote:
Dear Friends,
As i had attached two files one is the source file named Attendance
workbook and another is output .
in
Very short Cute formula... Thanks a lot for sharing this with group.
Can you please explain how it is calculating.
I have tried to check each piece of formula but could not got a clue only
=COUNTIF(A2:A595,A2:A595) is giving me 0 as result! -:)
Also if you can share other uses of
27 matches
Mail list logo