Hi Team / Ayush,
Need a formula about a countif criteria
See the attachment and please do the need full
Regards
prasad
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
Hi Umesh/Group members,
I am attaching the sample data. I know if I take gender for column it'll
solve the problem, but for some reason I don't wish to add any field in the
column..
Thanks !
On Fri, Apr 1, 2011 at 7:07 PM, Umesh Dev umesh.d...@gmail.com wrote:
Hi Rakesh,
can you attach
see if it helps
SUMPRODUCT((List!$A$1:$A$16=Sheet1!$A2)*(List!$B$1:$B$16=Sheet1!B$1))
On Sun, Apr 3, 2011 at 1:39 PM, Suryaprasad suryaprasad...@gmail.comwrote:
Hi Team / Ayush,
Need a formula about a countif criteria
See the attachment and please do the need full
Regards
prasad
--
Hi prasad,
Good day to you!
Attached is the solution. Please have a look and let me know if any
further assistance is required.
Regards
Ayush Jain
Group Manager
On Sun, Apr 3, 2011 at 1:39 PM, Suryaprasad suryaprasad...@gmail.comwrote:
Hi Team / Ayush,
Need a formula about a countif
Congratulations Ashish
You are simply amazing... thanks for the tips and hats off to you for your
excel knowledge
I really amazed with how quickly you can answer the queries of forum with such
a difficult VBA code...
Ayush
On breaking of the records I believe Dave Bonallack
Hi Experts,
i got a assigment to write a macro which will capture time by each agents
along with their work assign to them.please find attached sheet for
refrence.its very important
for me.please help me out.
Thanks,
Prabhat
--
Hi Experts,
i got a assigment to write a macro which will capture time by each agents
along with their work assign to them.please find attached sheet for
refrence.its very important
for me.please help me out.
Thanks,
Prabhat
--
Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
need help in removing zeros in every cell. Regards ,- bhanu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Hi Rakesh,
See if it helps...
Regards,
Jaideep Panchal
New Delhi
- Original Message -
From: rakesh kumar
To: excel-macros@googlegroups.com
Sent: Sunday, April 03, 2011 1:44 PM
Subject: Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range
Hi Umesh/Group members,
Hi Group,
I joined this group few months ago and I find it very helpful, I would like to
thank its group Mgr.
In my org, attendance cycle is 21th to 20th of next month but we need MTD
attendance for few reports. I am attaching a sample sheet, can someone provide
a macro or pivot table if its
run this macro
Sub RemoveAllZeros()
Dim xCell As Range
For Each xCell In ActiveSheet.UsedRange
xCell = Replace(xCell, 0, )
Next
End Sub
since you ask for REMOVING ZERO IN EVERY CELL
1500 will be 15
2100500 will be 215
and so on
On Sun, Apr 3, 2011 at 9:55 PM, bhanu prakash
Please attach file, so see what you need
There are many ways, row or column or range
I answer what you need to pair
2011/4/3 bhanu prakash bhanu...@gmail.com
Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
need help in removing zeros in every cell. Regards ,-
Please attach file, so see what you need
I answer for what you need
2011/4/3 Jaideep Panchal jai.ca...@gmail.com
Hi Group,
I joined this group few months ago and I find it very helpful, I would like
to thank its group Mgr.
In my org, attendance cycle is 21th to 20th of next month but we
Hi
Use
=SUBSTITUTE(A1,0,)
On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash bhanu...@gmail.com wrote:
Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
need help in removing zeros in every cell. Regards ,- bhanu
--
Hi,
Pls find attached file let me know if it serve the purpose.
Regards,
C.G.KUMAR
On Sun, Apr 3, 2011 at 1:39 PM, Suryaprasad suryaprasad...@gmail.comwrote:
Hi Team / Ayush,
Need a formula about a countif criteria
See the attachment and please do the need full
Regards
prasad
u can use the following formula
=SUBSTITUTE(A1,0,)
(where Cell A1 is target data)
Regards,
Dhananjay
On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash bhanu...@gmail.com wrote:
Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
need help in removing zeros in every cell.
Congrats Ashish. Go ahead.
Regards,
Dhananjay
On Sun, Apr 3, 2011 at 4:08 PM, Anil Bhange
anil.bha...@tatacommunications.com wrote:
Congratulations Ashish….
You are simply amazing… thanks for the tips and hats off to you for your
excel knowledge….
I really amazed with how quickly
Hi Bhanu,
Select all the cells where you want to remove zeros and select control + H,
and type 0 and replace with blank and then click on* Replace All.*
*
*
*
*
Thank you,
Shreedar
On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash bhanu...@gmail.com wrote:
Hi - need it help excel. Removing zeros
Thank you!:-)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Tuesday, March 29, 2011 10:30 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Useful Link ( Excel, Access, Word, Powerpoint )
VBA
Hi all
To learn
Guys thanks a ton for responses ,i need to remove only first letter in
cell if it is zero in alpha numeric data - regards - bhanu
On 04-Apr-2011 3:45 AM, STDEV(i) setiyowati.d...@gmail.com wrote:
run this macro
Sub RemoveAllZeros()
Dim xCell As Range
For Each xCell In
then the macro should be modified like this
Sub RemoveLeadingZeros()
Dim xCell As Range, i As Integer, s As String
For Each xCell In ActiveSheet.UsedRange
s = CStr(xCell)
For i = 1 To Len(xCell)
If Mid(xCell, i, 1) = 0 Then
s = Right(s, Len(s) - 1)
21 matches
Mail list logo