Could u pls provide the specific file (slave) in which you are facing this
prob.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: Tuesday, September 24, 2013 3:48 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need
Try the below formula:
=SUM(1/COUNTIF(A2:A595,A2:A595))
After entering this formula, you must press *Ctrl-Shift-Enter.* It will
give the desired result*.
*
Best,
Manoj Kumar*
*
On Mon, Sep 23, 2013 at 11:48 AM, Ashish Kumar wrote:
>
>
> Dear Seniors,
>
>
> I want total count of unique User ID
=SUMPRODUCT(1/COUNTIF(A2:A595,A2:A595))
Actually this formula first count the all values (a2:a595)in full range
(a2:a595) then divide 1 by count of all values and add those with help of
sumprduct
Just like simple eg:- if count of any value is 4 so countif formula will
calculate {4;4;4;4} t
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 "SUM
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 24, 2013 at 10:01 AM, अनिल नारायण गवली
wrote:
> Dear Friends,
>
>
> As i had attached two files one is the source file named Attendance
> workbook and another is output .
>
> in attendance file
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 wrote:
> Hi Experts / Ravinder / An
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
=LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,
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
>>
>>> On Mon, Sep 23, 2013 at 11:46 PM, Bill Q 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
"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.
>>>
p 23, 2013 at 11:46 PM, Bill Q
> > 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.
>>
>
> 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 Facebook page of this forum @
> https:/
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)
*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, but
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: excel-macros@googlegroups.
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
wrote:
> Hello experts,
>
> I have some doubt in VLOOKUP, that how can i get lookup value from
> previous cell?.
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 pag
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, wrote:
> **
> Do u want a formula which will convert image into excel ?
>
> Regards
> Ashish
> Sent on my BlackBerry® from Vodafone
> --
> *From: *
Do u want a formula which will convert image into excel ?
Regards
Ashish
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Mani Manju
Sender: excel-macros@googlegroups.com
Date: Mon, 23 Sep 2013 08:21:17
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
=LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1)
=RIGHT(A1,LEN(A1)-LEN(E1))
see if it helps
On Mon, Sep 23, 2013 at 8:52 PM, Dhananjay Pinjan wrote:
> Dear Friends,
>
> Assume that following values are in A1,A2, A3 . Column.
>
> I want to split the Alphabetic Name in B1, B2.
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 Prash
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 t
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,
Sum(MIDA
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 difficu
=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 U
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
> > wrote:
>
>> ca
Dear Ashish,
find the same with formula.
*Regards,
Prafull Jadhav
9920553518*
On Mon, Sep 23, 2013 at 1:39 PM, Ashish Kumar wrote:
> 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
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
> S
28 matches
Mail list logo
