*Try this also:*
*
*
*Formula in A1 is =NOW()*
*
*
*Formula in A2 is*
*
*
*=IF(WEEKDAY(IF(WEEKDAY(A1,2)=6,A1+2+TIME(0,5,0),IF(WEEKDAY(A1,2)=7,A1+1+TIME(0,5,0),A1+TIME(0,5,0))),2)
= 6,
Attached is the file with 2 sheets - input and output.
output i require is based on input tab--- i need every reference value to
be listed as columns and then list down the load nos in which these
reference values exist in the input tab.example
reference7151865O is in 2 load nos below
load
Dear everyone,
Referring to subject line attached a excel file with user form, my question
is
if text box 1 is “” (blank) then while moving cursor to combo box 1 it
shows msgbox with “please enter name” if this condition fulfill (means user
enter the name in textbox1 then it not supposed
Hello Karthik,
You can use text to columns function to get your desired format.
Check attached file.
On Sunday, April 29, 2012 11:08:10 AM UTC+3, karthik n wrote:
Hi friends,
Find the attachment of company address,how to spreat'up the colomn wise
data
Sample data is attached.
Hi
Add the following code in user form code module.
Private Sub TextBox1_MouseMove(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)
If TextBox1.Value = Then
MsgBox Please enter the name
End If
End Sub
Rajan.
From:
Dear Frnds,
I've a data sheet(reports) containing some data text in several row of
entire sheet have another sheet(user ids) in column A containing few
words these words may be or may not be the part of other sheet(report) text
in cell of column A, now i wanna know if the sheet(user ids) text
See the attached file.. Result on Sheet 2
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of prabhat.shrivasta...@gmail.com
Sent: 29 April 2012 22:10
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Find the cell value from other sheet
*Hi Sara *
*
*
*PFA*
*Regards,*
*Lalit Mohan*
On Sun, Apr 29, 2012 at 12:38 PM, Sara Lee lee.sar...@gmail.com wrote:
Attached is the file with 2 sheets - input and output.
output i require is based on input tab--- i need every reference value to
be listed as columns and then list down the
*Hi karthik*
*
*
*PFA*
*Regards,*
*Lalit Mohan*
On Sun, Apr 29, 2012 at 1:38 PM, karthik N n.karthi...@gmail.com wrote:
Hi friends,
Find the attachment of company address,how to spreat'up the colomn wise
data
Sample data is attached.
Regards
karthik.N
--
FORUM RULES (986+ members
*Hi karthik*
*
*
*PFA*
*
*
*Regards,*
*Lalit Mohan*
On Sun, Apr 29, 2012 at 10:56 PM, ╰» ℓαℓιт мσαнη
mohan.pande...@gmail.comwrote:
*Hi karthik*
*
*
*PFA*
*Regards,*
*Lalit Mohan*
On Sun, Apr 29, 2012 at 1:38 PM, karthik N n.karthi...@gmail.com wrote:
Hi friends,
Find the
Nicely done...!!
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ╰» ℓαℓιт мσαнη
Sent: Sunday, April 29, 2012 12:27 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need Your Help
Hi karthik
PFA
Regards,
Lalit Mohan
On Sun, Apr 29,
Really good
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ╰» ℓαℓιт мσαнη
Sent: Sunday, April 29, 2012 12:25 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ data needed in this format
Hi Sara
PFA
Regards,
Lalit Mohan
On Sun, Apr 29,
it s working- Thank you so much .. appreciate it.
On Sun, Apr 29, 2012 at 1:55 PM, dguillett1 dguille...@gmail.com wrote:
Really good
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* ╰» ℓαℓιт мσαнη mohan.pande...@gmail.com
*Sent:* Sunday, April 29, 2012
Hi
Please find solution with Formulas. I just replace “Email Address” to “Email”
in your row data and make formula accordingly
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Sara Lee
Sent: 29 April 2012 23:29
To:
I have two sets of Excel worksheets I am trying to compare. The cells
contained multiple lines of text. Some identical-looking lines do not
compare with string1 = string2 syntax. It appears the comparison is
failing when it tries to compare new line characters (ASCII code 10).
Has
Hi All,
I'm asking you for help, I have a problem with compering two cells base on
conditions. There is no problem if everything is running in order, but if there
is a gap ... there is wrong answer given, pls see attachment and if you can
advice I'll be appreciated.
Regards,
Pawel
--
Thanks for your revert rajan, but i've one query ma sheet(report) contains text
line as A112354 xyz abc etc or xyz A112354 abc etc in several row of sheet
and other sheet(user id) contains only A1123 now i want to know if A1123
available in sheet(report) or nt...
Regards,
Prabhat S
--
FORUM
What formula would return the row or column number of the first value in an
array greater than a specified value? Eventually I'll need to compare the
location with another location to see which comes first chronologically. I
could list the numbers either vertically or horizontally, whichever
Can you attach an example.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Filip Houdek ll00...@yahoo.com
Sender: excel-macros@googlegroups.com
Date: Sun, 29 Apr 2012 21:58:39
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject:
Hello sir,
First of all thanks, secondly I don't know vba so can't use it. is excel
have any formula. plz tell me.
Thanks Regards
Anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
20 matches
Mail list logo