Bala Iyer From Mumbai
On Sat, Sep 21, 2013 at 11:10 AM, Rupesh Patil
wrote:
> Hi My name is Rupesh from Pune Maharashtra, India. I am working as
> technical support engineer and customer support engineer.
> I am looking for VBA help. actually I have task assigned to build up tool
> for data entr
Hi My name is Rupesh from Pune Maharashtra, India. I am working as
technical support engineer and customer support engineer.
I am looking for VBA help. actually I have task assigned to build up tool
for data entry and I am completely new with VBA so,
Thanks and regards, Rp.
On Saturday, 9 Jun
PFA:-
=INDEX($H$1:$H$29, SMALL(IF(($P$4=$F$4:$F$29)*1>0,ROW($F$4:$F$29)),3)) FOR
3RD
=INDEX($H$1:$H$29, SMALL(IF(($P$4=$F$4:$F$29)*1>0,ROW($F$4:$F$29)),3)) FOR
4TH
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Muralidhar E
Sent: Saturday, Septem
Dear Friends & experts,
Good morning
If any one can helped can be appreciated,iam using excel-2010, my problem
is i want to get the result for third match(occurence) value, but
iam failed to do so.Information reg. data is explained the file.
Thanks in advance.
*Thanks & Regards,*
**
*Muralidhar
Hi अनिल नारायण गवली,
can you please tell me how to use your file
thanks
*(¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!!
`•.¸.•´
Thanks & Regards´¨)
¸ •´ ¸.•*´¨) ¸.•*¨)
(¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
* *
*P Let us do our best to save nature
Hi mum,
The 5 digit number is the equivalent value of the corresponding date in
that cell. You should see the correct format if you press CTRL+`
` is normally found just about the TAB key
Regards,
Sam Mathai Chacko
On Fri, Sep 20, 2013 at 8:31 PM, Dawn wrote:
> Hi!
> Im updating my skills in
Try To Press Button CTRL + ` (a button before button "1", in the top of
TAB button bellow the ESC ) :D
Or
Goto Menu Formula then deactivate Sub Menu "Show Formulas"
On 20-09-2013 22:01, Dawn wrote:
Hi!
Im updating my skills in excel and have created a spreadsheet with
heaps of dates in a col
Hi!
Im updating my skills in excel and have created a spreadsheet with heaps of
dates in a column. They have 'somehow' all changed to a five digit
number! The original date can still be seen in the text bar at the top but
doesn't appear in the cell. Ive tried to format the column back to a s
no probs i got it
On Fri, Sep 20, 2013 at 2:54 PM, Hilary Lomotey wrote:
> one word,
>
> S U P E R B
>
> nicely done. thanks
>
> can u explain this line Find("USER NAME ").Column pls thanks
>
>
> On Fri, Sep 20, 2013 at 2:49 PM, priti verma wrote:
>
>> Try this
>>
>> Sub ROOTY()
>>
>> Dim r As
one word,
S U P E R B
nicely done. thanks
can u explain this line Find("USER NAME ").Column pls thanks
On Fri, Sep 20, 2013 at 2:49 PM, priti verma wrote:
> Try this
>
> Sub ROOTY()
>
> Dim r As Long
> Dim lngcolumn As Long
> r = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
> lngcolumn = Sheet1.
Try this
Sub ROOTY()
Dim r As Long
Dim lngcolumn As Long
r = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
lngcolumn = Sheet1.UsedRange.Rows(1).Find("USER NAME ").Column
For Each cell In Range("l2:l" & r)
If cell.Value = "Rolled-Over" Then
Sheet1.Cells(cell.Row, 1).Resize(, lngcolumn).Select
thanks priti for the response, the first line of code is ok but i dont
want to delete entire because i may have other information on that row in
another column, how can i manage that? is it possible? thanks
On Fri, Sep 20, 2013 at 2:36 PM, priti verma wrote:
> Hi,
>
> Replace these line
>
> If
Use below one there is no field named as country.. if it doesn't
work then let me knw.
SELECT TOP 20 MIDASQ12013.COUNTRY, MIDASQ12013.ATC3_COD,
Sum(MIDASQ12013.EUR_2008) AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09,
Sum(MIDASQ12013.EUR_2010) AS KEUR10, Sum(MIDASQ12013.EUR_2011) AS KEUR11
Hi,
Replace these line
If Range("l2:l" & r).Value = "Rolled-Over" Then
Range("A" & cell & ":Q " & cell).ClearContents
with
If cell.Value = "Rolled-Over" Then
cell.EntireRow.ClearContents
On Fri, Sep 20, 2013 at 7:20 AM, Hilary Lomotey wrote:
> Hello Champs,
>
> i have written t
Please share your file..
On Fri, Sep 20, 2013 at 5:50 PM, Richard Mogy wrote:
> Sorry. I was saying that the field I'm selecting in my query, called xyz
> is defined in the SQL table as varchar (max), which means, to me, that the
> number of characters cab vary to the maximum allowed by SQL.
Hello Champs,
i have written the macro below to clear the row contents if a certain
criteria is met but am getting a type match error, pls assist with proper
code.
what i want is in col L if there is dont roll over i want the information
on that row to be cleared ie only from A to Q of that parti
test mail
On Fri, Sep 20, 2013 at 5:58 PM, Ravinder wrote:
> ** **
>
> --
> 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, ac
--
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 thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Sorry. I was saying that the field I'm selecting in my query, called xyz
is defined in the SQL table as varchar (max), which means, to me, that the
number of characters cab vary to the maximum allowed by SQL.
Rich
On Sep 19, 2013 10:21 PM, "Anoop K Sharma" wrote:
> Hi Richard,
>
> Your query is
Respected Waseem,
Just Select the entire sheet and go to any row or column intersection such
as Column A & B or Row 1 & 2 etc.Just double click when your cursor turns
into a double arrow.Now the whole sheet is adjusted accordingly and you
need not drag it everytime.
Regards,
Vijaykumar
On Fri,
Image is not there, please send again with example excel file.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Waseem Saifi
Sent: Friday, September 20, 2013 2:57 PM
To: excel-macros
Subject: $$Excel-Macros$$ Auto Filter too short
In My Excel, Auto Fil
Respected Prabhakar,
Install the addin a new excel work book.To install the addin go to the
excel options button and go to the add-in tab,in the rightside down part
you will have a go button .Click it and you will have a dialog box with
brose and three other buttons.Click brose and select the save
Thanks Ravinder,
can you tell me how did you done this and also tell me how to lock the work
book as it is.
Rgds,
Prabhakar
On Friday, September 20, 2013 10:50:54 AM UTC+5:30, ravinder negi wrote:
> PFA
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On
Hello,
Thanks a lot. Its working fine.
Regards,
Chandra
On Fri, Sep 20, 2013 at 12:28 AM, Excel Beginner wrote:
> ** **
>
> Hi Chandra Sekar ,
>
> ** **
>
> Use the below formula.
>
> ** **
>
> =ROUNDUP(SUM(1/COUNTIF(B2:B15,B2:B15)*IF(A2:A15=C2,1,0)),0)
24 matches
Mail list logo
