Hi Vinod,
Thank you very much,
Vinod can you give me vba code for that issue
Regards
Vilas
On Sat, Aug 28, 2010 at 9:11 PM, VILAS CHAVAN vilaschav...@gmail.com wrote:
Hi vinod,
You are not sending me any attachment please send solve attachment please
regards
Vilas
On Sat, Aug
I did not get it what does it means? i m newly in excel, so plz decribe it
thanks regards
ankit
On Sun, Aug 29, 2010 at 10:14 AM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
You have custom formatting in the both of your main data columns, which
means that only the numeric value is
Hi,
Unfortuneately, your data is not as it appears. On the workbook you posted,
select cell B5.
Look in the formula bar (just above the Column headers)
You will see: 180.5 even though the cell displays 180.500 kg
This is because custom cell formatting in B5 puts in the extra info.
Now, in
Hi Dear
There is problem because cells are in custom format. You should enter this
in general format.
Chandra Gupta Maurya
On Sun, Aug 29, 2010 at 9:51 AM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Hello Sir,
I need help in separate the num alpha value in the one cell into another
check the attachment if it helps
On Sun, Aug 29, 2010 at 1:21 PM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
Unfortuneately, your data is not as it appears. On the workbook you posted,
select cell B5.
Look in the formula bar (just above the Column headers)
You will see: *180.5*
Hi Vilas,
Please find below the macro recorded by me...
Sub Date_Format()
'
' Date_Format Macro
' Macro to convert date format- 8/29/2010 by Vinod
'
Columns(A:A).Select
With Selection
Selection.TextToColumns Destination:=Range(A1), DataType:=xlDelimited,
_
Steve,
Lets assume that your columns are labeled A, B C. meaning that cell
A2=2, B2=3, C2=5
put this formula in cell C2, =IF(B2=,A2+C1-A1,B2+A2)
Copy that formula down.
Michael
On Aug 28, 12:43 am, xsrossiter steverossi...@sbcglobal.net wrote:
Hello,
I am using Excel 2002 SP3 and hope
Dear Thakur,
I am not sure what you are looking for. Can you elaborate more
through a sample file.
If you are willing to vlookup the values based on the names, then
vlookup will fetch the first value and will ignore the other values
which are in bottom. Further to this, I am not sure what are
Hi Ashish,
Thanks for the solution. It is good for the old Indian Currency
format, but how can we include new Indian Rupee format.
Thanks,
Dilip Kumar Pandey
On 8/21/10, ashish koul koul.ash...@gmail.com wrote:
check the attachment
regards
ashish koul
akoul.blogspot.com
On Sat, Aug
Hm, for some reason I only received this email after I send the last one.
Ashish's solution is much more elegant than mine.
Please forgive for sending useless attachments to your emails.
On Sun, Aug 29, 2010 at 5:32 AM, ashish koul koul.ash...@gmail.com wrote:
check the attachment if it helps
Thank you both, Michael and Vinod N, for these helpful solutions,
Steve.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Hi Guyzz,
Come on ..Please participate in this
If you dont respond, It means that you dont love excel.
Express yourself !!
Thanks to those who responded quickly :)
-Ayush Jain
Group Manager
On Aug 29, 1:26 am, Vinod N nvino...@gmail.com wrote:
Excel makes life simple Be it an
thank you sir,
but again it is not easy to me yet, But I m trying to understand it.
On Sun, Aug 29, 2010 at 7:17 PM, Maries talk2mar...@gmail.com wrote:
Dear Friend,
Pls. find the attached file.. it will help you to know HLOOKUP and VLOOKUP.
Regards,
Maries
On Sun, Aug 29, 2010 at
13 matches
Mail list logo