Please help me in reducing the code in the attachment above..
Thnx in advance
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
Can anyone help me with the above post please
:-(
Rash
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Dear Sir,
You pl use the formula
=ROUND(A1,-1)
On Sun, Jul 17, 2011 at 5:22 PM, sharad jain wrote:
> Hi Guys,
>
> Can someone please send me a simple code for round off to nearest 10? (No
> macro if possible.)
>
> For example, if I put 23 in A1, it should result in 20 in B1 and if I put
>
Thanks Venkat
On Sun, Jul 17, 2011 at 7:28 PM, Venkatesan c wrote:
> Hi Siva,
>
> You Can Post your MS Access Query's in this group it self...
> *
> *
> *Best Regards,*
> *Venkat*
>
>
> On Sun, Jul 17, 2011 at 12:13 PM, Siva Sankarnath S wrote:
>
>> Hi Smarts,
>>
>> Good day..
>>
>> Could you se
Dear Mahesh,
Thanks a lot for your immediate reply.
It is almost what I am looking for,but can we create the code on
alphabatical basis like the first client name starting with alphabet 'F' the
code should be like DMF001 and for the second client name starting with same
alphabet, code should be D
Hi Kurikkal
find attach
Thanks
Mahesh
On Sun, Jul 17, 2011 at 4:59 PM, kurikkal padinjarappalla <
padinjarappa...@gmail.com> wrote:
> Dear Experts,
>
> Hope somebody could help me to solve the problem mentioned in the attached
> sheet.
>
> Thanks in advance.
>
> Regards,
> Kurikkal.
>
> --
>
>
Dear Sharad,
You can use MROUND function.
=MROUND(23,10)
On Sun, Jul 17, 2011 at 2:52 PM, sharad jain wrote:
> Hi Guys,
>
> Can someone please send me a simple code for round off to nearest 10? (No
> macro if possible.)
>
> For example, if I put 23 in A1, it should result in 20 in B1 and if I
Dear Sharad,
Use the following formula in B1.
=IF(VALUE(RIGHT(A1,1))<=5,FLOOR(A1,10),CEILING(A1,10))
Regards,
Marieswaran.
+971 55 9828492
On Sun, Jul 17, 2011 at 3:52 PM, sharad jain wrote:
> Hi Guys,
>
> Can someone please send me a simple code for round off to nearest 10? (No
> macro if p
Anish Shrivastava wrote:
> Please have a look on the attached file. This might be helpful.
>
> I tried it only on one column since I dont know in how many columns you will
> have the data. If you could attach a sample sheet for your data, I can make
> it more feasible.
Thanks, Anish, for your a
Use
=ROUND(B12,-1) // (Suppose the number is in B12)
Cheers
Andy
On Sun, Jul 17, 2011 at 5:22 PM, sharad jain wrote:
> Hi Guys,
>
> Can someone please send me a simple code for round off to nearest 10? (No
> macro if possible.)
>
> For example, if I put 23 in A1, it should result in 20 in B1 an
Hi sharad,
look attached..it may Help you...
--
*Best Regards,*
*Venkat*
*
*
On Sun, Jul 17, 2011 at 5:22 PM, sharad jain wrote:
> Hi Guys,
>
> Can someone please send me a simple code for round off to nearest 10? (No
> macro if possible.)
>
> For example, if I put 23 in A1, it should result
Hi Siva,
You Can Post your MS Access Query's in this group it self...
*
*
*Best Regards,*
*Venkat*
On Sun, Jul 17, 2011 at 12:13 PM, Siva Sankarnath S wrote:
> Hi Smarts,
>
> Good day..
>
> Could you send me googlegroup id for MS Access..
>
> --
> Thanks
> Siva
>
> --
>
> --
Hi Guys,
Can someone please send me a simple code for round off to nearest 10? (No
macro if possible.)
For example, if I put 23 in A1, it should result in 20 in B1 and if I put 27
in A1, it should result in 30 in B1. For 25, it should result in 30.
Thanks in advance.
Best,
Sharad
--
-
Dear Experts,
Hope somebody could help me to solve the problem mentioned in the attached
sheet.
Thanks in advance.
Regards,
Kurikkal.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tri
Hi Smarts,
Good day..
Could you send me googlegroup id for MS Access..
--
Thanks
Siva
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailyt
Hi , Perfects
I have one system (5400-FLC-01) in this system I am creating each new
file name example (5400FLC-01-C001) (5400FLC-01-C002)
When I create the new file should be update in the attached file with
shade.
Thanks!
5400FLC-01
1
2
3
4
5
Best Regards
hi experts,
Please help me in this concern.
i need to perform vlookup function using VBA
i have attached sample work book for referance
>From the attached workbook i need update summary sheet using the company
code as base from SBU Mapping sheet.
i need to insert one column after Data1 , Data
Take the Log Contact in Column and data Field in Pivot Table
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vincent Torralbes
Sent: Saturday, July 16, 2011 9:11 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Calculating distinct events by
Have a look at the attached workbook.
Daniel
- Mail Original -
De: "RockyFontane"
À: "MS EXCEL AND VBA MACROS"
Envoyé: Samedi 16 Juillet 2011 18h06:05 GMT +01:00 Amsterdam / Berlin / Berne /
Rome / Stockholm / Vienne
Objet: $$Excel-Macros$$ Excel formula for Calculating distinct events
From: Quetzal Verify Private Limited [mailto:j...@quetzal.in]
Sent: Saturday, July 16, 2011 10:52 AM
To: rajanverma1...@gmail.com
Subject: Job Opening_Big4_Spreadsheet Analyst
For Internal Use of Employer (Please don't delete or modify while replying to
this email)
Monster Resume ID
20 matches
Mail list logo
