=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}
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 kumar.ashish...@gmail.comwrote:
Dear Seniors,
I want total
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
I don’t know more about this. U can use like below;
=SQRT((x2 – x1)^2 + (y2 – y1)^2 + (z2 – z1)^2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Debasish Sahu
Sent: Monday, September 23, 2013 6:36 PM
To: excel-macros@googlegroups.com
Subject:
Try this code..
Sub test()
Application.ScreenUpdating = False
Dim sh As Object
Dim i As Integer
Dim nwkb As Object
Dim lrow As Long
Set nwkb = Workbooks.Add
nwkb.Sheets(1).Cells(1, 1).Value = Date
nwkb.Sheets(1).Cells(1, 2).Value = Emp code
nwkb.Sheets(1).Cells(1, 3).Value = Time
Dear Deepak ,
But here the outtime is missing
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 24, 2013 at 1:33 PM, Deepak Singh dpk85si...@gmail.com wrote:
Try this code..
Sub test()
Application.ScreenUpdating =
Hi Anil,
You did not mention the Outtime in your Output sheet..following heading are
there in that sheet
Date Emp code Time DDMM HHMM Empcd Final output
--
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
Dear Deepak ,
See the Output file outitme is mentioned in the same field of Time field.
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 24, 2013 at 2:26 PM, Deepak Singh dpk85si...@gmail.com wrote:
Hi Anil,
You
Hi,
with the followong code I can able to paste the all the values from the
excel sheet to the webpage.But if while pasting the second value the first
value is getting replaced. So finally I can paste only the last cell value.
I want all the range of values to be entered in the text filed.
Try this one..
Sub test()
Application.ScreenUpdating = False
Dim sh As Object
Dim i As Integer
Dim nwkb As Object
Dim j As Long
Dim lrow As Long
Set nwkb = Workbooks.Add
nwkb.Sheets(1).Cells(1, 1).Value = Date
nwkb.Sheets(1).Cells(1, 2).Value = Emp code
nwkb.Sheets(1).Cells(1, 3).Value = Time
Not able to access website and not getting how its working.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Menaka Balakrishnamoorthy
Sent: Tuesday, September 24, 2013 2:42 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to paste all
Store the value in any array or collection and then paste it to ie textbox
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Tuesday, September 24, 2013 3:01 PM
To: excel-macros@googlegroups.com
Cc: Soum
can you please say how to store in array or collection
On Tuesday, September 24, 2013 3:23:26 PM UTC+5:30, Ravi Kumar wrote:
Store the value in any array or collection and then paste it to ie
textbox
* *
*Warm Regards,*
*Ravi Kumar.*
*From:* excel-...@googlegroups.com
I want to paste the values of Range A1:A10 in the text box of a web page, I
can paste A1 and while pasting A2, A1 is getting replaced, finally there is
only one value in the text box that is A10, but I need all the values from
A1 to A10 to be pasted. Please help on this. And the link is my VM
Hi,
One example to combined range. Change your range, ie.navigate and element id
also
Sub testin()
Dim ie As Object
dataarr = Range(A2:A4) 'Change according to your criteria
For i = 1 To UBound(dataarr, 1)
If counter = 0 Then
store_value = dataarr(i, 1)
counter = 1
Else
Hi All,
In attached workbook I have some cells which are colored in Red, Green,
Yellow, Orange. I need a count of these cells. Please find attachment. I'm
looking for VBA Code, Excel formula also works fine.
Thanks in Advance
Regards,
Kartik
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Hi Thankyou so much, its working fine. But I need the second value in the
next line not in the comma seperated manner, may I know where should I
change that?
On Tuesday, September 24, 2013 5:48:00 PM UTC+5:30, Ravi Kumar wrote:
Hi,
One example to combined range. Change your range,
Goto the pie chart - double click on the pie - should be able to bring up a
four tab choice box - select option the just adjust the angle in degrees
of the first slice
regards
John
On Thursday, 19 September 2013 18:46:52 UTC+1, Joseph wrote:
Hi,
I have a two slice pie chart and the
try attached file
On Tue, Sep 24, 2013 at 6:47 PM, Kartik Dale kartik.1...@gmail.com wrote:
Hi All,
In attached workbook I have some cells which are colored in Red, Green,
Yellow, Orange. I need a count of these cells. Please find attachment. I'm
looking for VBA Code, Excel formula also
Even if I replace as store_value = store_value Chr(13) dataarr(i, 1)
its pasting in the webpage with comma seperated only
On Tuesday, September 24, 2013 5:48:00 PM UTC+5:30, Ravi Kumar wrote:
Hi,
One example to combined range. Change your range, ie.navigate and element
id also
Thank you Ashish...:)
Regards,
Kartik
On Tue, Sep 24, 2013 at 7:12 PM, ashish koul koul.ash...@gmail.com wrote:
try attached file
On Tue, Sep 24, 2013 at 6:47 PM, Kartik Dale kartik.1...@gmail.comwrote:
Hi All,
In attached workbook I have some cells which are colored in Red,
Hello All,
I have attached one excel file in which one column is source and other in
target, for XXX in target suppose transalation is given, for the source
which have blank in front of it copy the source and hide the all text
except the text just copied. Can any one help to create macro to
Thanks for your response. I know to do it manually but my charts gets
updated very often. So I am looking for an automation.
On Sep 24, 2013 6:54 PM, Johnnyboy5 intermediatec...@gmail.com wrote:
Goto the pie chart - double click on the pie - should be able to bring up
a four tab choice box -
try vbnewline see if it works
store_value = store_value vbnewline dataarr(i, 1)
or
store_value = store_value vbnewline vbnewline dataarr(i, 1)
On Tue, Sep 24, 2013 at 7:30 PM, Menaka Balakrishnamoorthy
menaka.balakris...@gmail.com wrote:
Even if I replace as store_value =
Hello David,
I am working on XL2003, and tried inserting the function in a general
module, but I continue to receive the #NAME? error when applying the
formula...
Any quick hint?
Thanks in advance
Gilberto
On Saturday, 11 August 2012 12:56:32 UTC+1, David Grugeon wrote:
Hi Sharad
Use the
Try this one..for getting number and character and u can use UDF given by
Ravi for get character
From: Ravinder [mailto:ravinderexcelgr...@gmail.com]
Sent: Tuesday, September 24, 2013 10:02 AM
To: 'excel-macros@googlegroups.com'
Cc: Soum (quote.ex...@gmail.com)
Subject: RE: $$Excel-Macros$$
U can use UDF
'For Character
Function gettext(refc As Variant)
For i = 1 To Len(refc)
If Mid(refc, i, 1) Like [a-zA-Z] Then
temp = temp Mid(refc, i, 1)
End If
Next
gettext = temp
End Function
---
Thank you Ravi, its working fine :)
On Tuesday, September 24, 2013 5:48:00 PM UTC+5:30, Ravi Kumar wrote:
Hi,
One example to combined range. Change your range, ie.navigate and element
id also
Sub testin()
Dim ie As Object
dataarr = Range(A2:A4) ‘Change according to
Thanks for the suggestion Ashish, its working fine now.
On Tuesday, September 24, 2013 9:52:04 PM UTC+5:30, ashish wrote:
try vbnewline see if it works
store_value = store_value vbnewline dataarr(i, 1)
or
store_value = store_value vbnewline vbnewline dataarr(i, 1)
On Tue,
Welcome Menaka
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Menaka Balakrishnamoorthy
Sent: Wednesday, September 25, 2013 11:06 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to paste all
30 matches
Mail list logo