Thx Vinu,
warmest regards,
DiLipandey
On 5/12/10, Vinu wrote:
> Thanks a lot Dilip,
>
> Sure going forward will attach group in the mails.
>
> On 12 May 2010 15:29, Dilip Pandey wrote:
>
>> Dear Vinu,
>>
>> Attached file is re-formulated as per your criteria. Please get back in
>> case of any
Hi Mike,
I tried using your formula without your If/And prefix, but couldn't get xl to
accept it.
Please send an exact copy of the formula which is currently working (ie,
without the If/And prefix).
Regards - Dave.
> Date: Wed, 12 May 2010 14:49:29 -0700
> Subject: Re: $$Excel-Macros$$ IF A
Hi,
I assume by the leading zeros that the cell is formatted as text.
Try this code, which assumes that your data is in cell E2
Sub InsertComma()
A = 8
B = Len(Range("E2"))
Do Until A > B
B = Len(Range("E2"))
C = Left(Range("E2"), A)
D = Right(Range("E2"), (B - A))
Range("E2") = C & "," & D
Sub Bla_Bla_Bla()
Dim MyRng As Range, n As Long
Set MyRng = ActiveSheet.UsedRange
For n = MyRng.Rows.Count To 1 Step -1
If UCase(Left(Trim(MyRng(n, 1)), 5)) = "TOTAL" _
Then MyRng(n + 1, 1).EntireRow.Insert
Next
End Sub
NOTE:
to insert a row you have to say the range o
I think, removing VPageBreaks and HPageBreaks can be done
by setting FitToPage /Wide/Tall properties to : 1
Sub ClearPgBreasks()
With ActiveSheet.PageSetup
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
End Sub
On May 12, 8:33 pm, Sundarvelan N wrote:
>
Hi Dave!
I appreciate your taking the time to look at the formula I am having
trouble with. I inherited this task and am trying to use what is
already working. The formula is used in many different parts of a
summary sheet, just different filter terms. What the existing
formulas do, which by th
I need a formula that inserts a comma every 8 characters in a cell.
The cell length could be from 8 to over 3000 characters. In this case,
the LEFT, MID, and RIGHT does not work because of random length cells
and the amount of characters. Any help would be appreciated.
Example:
2048204900
Dear VBA guru,
I have a table like below:
col A ColB
1 ?
1 ABD
2 ADC
2
2 ADD
I would like to have results as:
1 ABD
2 ADC; ADD
In other words, I would like to delete the rows with empty cell and
question marks, or other unwanted values (ideally, the
Hello,
I have data that contains certain text strings ("Total" followed by
other text) repeated in column A. When my progam finds this text
string, I want it to insert a blank row below the row that contains
the text.
My macro looks like this:
Set CELLToCHECK = FirstCellR /comment - Fir
Hi Uugandhi,
Its better if you could pls attach the file provided its not confidential.
Best Regards,
Haigreev
On 5/12/10, uu wrote:
> What I would like is under column "D" to be able to select one store
> number at a time from the data sort filter. What I would like to do
> is
> have a VLoo
Hello Friends,
Can anyone help me to remove Page Breaks in Excel sheets Using VBA code.
Thanks,
N.Sundarvelan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://t
can you please share the sample with us so that we can try on the
above query.
Regards,
Rahul Gandhi
On May 12, 12:03 pm, uu wrote:
> What I would like is under column "D" to be able to select one store
> number at a time from the data sort filter. What I would like to do
> is
> have a VLookUp
can you please share the example of your query
On May 12, 2:33 pm, Azhar Rai wrote:
> Hi Members
>
> I have an excel sheet with huge text data and at the beginning of each cell
> text string there are names (mostly single names) I want to count the number
> of letters in the first word (that is t
Thanks a lot Dilip,
Sure going forward will attach group in the mails.
On 12 May 2010 15:29, Dilip Pandey wrote:
> Dear Vinu,
>
> Attached file is re-formulated as per your criteria. Please get back in
> case of any help.
>
> Suggestion:- Please include "Group" in such emails, so that every on
Hi Azhar,
You can use LEN(the cell address) function.
Thanks and Regards,
Anand S
On Wed, May 12, 2010 at 3:03 PM, Azhar Rai wrote:
> Hi Members
>
> I have an excel sheet with huge text data and at the beginning of each cell
> text string there are names (mostly single names) I want to coun
Hi,
Assuming there is a space after the first name, look for that space using
search, then subtract 1:
=SEARCH(" ",A1)-1
Change the A1 ref to suit your data.
Regards - Dave.
From: azhar@gmail.com
Date: Wed, 12 May 2010 14:33:26 +0500
Subject: $$Excel-Macros$$ URGENT Request
To: excel-mac
Hi,
A sample file would be good, but to simplify your formula, use a a name for
'Test Plan'!$I$13:$I$10134
I've used XYZ and your formula now looks like this:
=IF(AND(XYZ ="11",(IF(SUM(IF(XYZ ="NB",1,0)))>0,SUM(IF(XYZ
="NB",1,0)),0)+IF(SUM(IF(XYZ ="QU",1,0))>0,SUM(IF(XYZ
="QU",1,0)),0)+IF
Dear Vinu,
Attached file is re-formulated as per your criteria. Please get back in
case of any help.
Suggestion:- Please include "Group" in such emails, so that every one can
get a fair chance to learn and help others.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +9
Hi Members
I have an excel sheet with huge text data and at the beginning of each cell
text string there are names (mostly single names) I want to count the number
of letters in the first word (that is the name I referred to above). Please
tell some excel function that does this work for me.
Than
use this formula in cell D7
=IF(OR(B7="A",B7="B"),IF(C7<=$C$4,$B$4,IF(C7<=$C$3,$B$3,IF(C7<=$C$2,$B$2,0))),IF(C7<=$E$4,$D$4,IF(C7<=$E$3,$D$3,IF(C7<=$E$2,$D$2,0
On 12 May 2010 12:31, lucky singh wrote:
> Dear All,
>
>
> Kindly help with the IF formula in the attached sheet asap.
>
> Thanks an
How can i get automatic update of the privo tabel?
Best Regards
Peter
On 12 Maj, 06:31, Vikas Chouhan wrote:
> two way
>
> 1) put formula =COUNTIF($A42:$A$8,"Bill")
> 2) Make Pivot table
>
>
> On Tue, May 11, 2010 at 1:00 PM, nyberg75 wrote:
> > Hi
>
> > How can i sum/count the number of
What I would like is under column "D" to be able to select one store
number at a time from the data sort filter. What I would like to do
is
have a VLookUp in cell “I8” for the range of store numbers in column
"D" and have the store name appear depending on what single store is
shown while using the
Dear All,
Kindly help with the IF formula in the attached sheet asap.
Thanks an advance.
Regards,
Lucky Singh
Sr. MIS Analyst.
9987337414
--
--
Some important links for excel users:
1. Follow us on TWITTER for ti
two way
1) put formula =COUNTIF($A42:$A$8,"Bill")
2) Make Pivot table
On Tue, May 11, 2010 at 1:00 PM, nyberg75 wrote:
> Hi
>
> How can i sum/count the number of times a name has occured
>
> Example:
> John
> Bill
> Gordon
> Bill
> Bill
> Sara
> Bill
> John
>
> Result:
> Bill = 4 times
Hi Mike,
It will be better if you send a sample file with some data and your
query. As it may give you a shorter and simple formula for your task.
And about this formula, one can only show you the syntax error and
that not guaranteed for formula to give desired result.
So if you can than attach
Can you send me the code for RTRIM it.
Because I cannot find in Excel function list.
Thanks and Regards,
Anand S
On Tue, May 11, 2010 at 6:10 PM, vikas gupta wrote:
> HI ANAND
>
> YOU CAN USE "RTRIM" COMMAND
>
> REGARDS
> VIKAS GUPTA
> 9311334683
>
>
>
> On Thu, May 6, 2010 at 6:15 PM, anand
Thanks for ur support sumit.
Thanks,
Chandrabhan Singh
On Tue, May 11, 2010 at 7:19 PM, sumit kumar wrote:
> Dear Chandra
>
> here is the attached sheet probably you were looking for.
>
> Sumit
>
> On Tue, May 11, 2010 at 2:54 PM, Born to Win wrote:
>
>> Hi All,
>>
>> Please Help me its urge
27 matches
Mail list logo
