MROUND(ROUNDUP(NUMBER,-2),500)
On Tue, Aug 25, 2009 at 5:09 PM, NOURREDINE BELHAJ <
nourredine.bel...@gmail.com> wrote:
> Hi All,
>
> Hope you are well.
>
> I would like to ROUNDUP the figure below
>
> 9,235,200.23 € to 9,500
>
> Can you please advise ?
> Thanks
> --
> Regards
>
> Nourredine BELH
Hi Cheechu & "Dear Group Frnds"
You can download the "FileFormatConverter"/"Compatibility pack of Office
2007" from Microsoft website to open files created with Office 2007. I do
have this tool, but because of huge Size, which is 28,192KB I am not able to
send it to you.
--
DILIP KUMAR PANDEY
Thanks Ashish..!!
For the benefit of group, can you share us the detailed and comparitive
features of Excel 2003 and Excel 2007 in a chart or table. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/
use the LARGE function, =large(data array,2)
On Mon, Aug 24, 2009 at 7:39 PM, Gaurav Banerjee wrote:
> Hi,, How to fnd the second highest no. in a grop of 10 No. using formulae.
> For eg.
> 12
> 3
> 45
> 1
> 18
> 90
> 15
> 76
> 99
> 9
>
> the result should be 90.
>
> Can any1 hlp out with this?
>
Use sumifs which is a new function in 2007. this is very easy
On Tue, Aug 25, 2009 at 5:53 PM, suresh k wrote:
>
> Can anyone provide me the formula for below query.
>
>Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03
> 7/2/2009 7.92 7/2/2009 9.02 7/3/2009 9.05
> Answer
Hi All,
This is challenge for all excel users. Solve these puzzles and sharpen your
excel acumen. So, here goes the first puzzle of "Excel Macros Google Group"
in attached file.
--
Regards
Ashish Jain
(Excel Macros - Google G
Vidyut why don't you use a simple pivot table, it will do the trick.
On Tue, Aug 25, 2009 at 4:22 PM, vidyut more wrote:
> can i use this formula to another sheet extract data from another sheet.
>
>
> -- Forwarded message --
> From: Anish Shrivastava
> Date: Tue, Aug 25, 2009 a
Hi Prashant,
Try OPEN XL - http://www.openexcel.com
It's commercial/personal use is free.
--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Hi RajKumar,
Dilip is right and here is some more information:
Maximum Arguments in a function 30
Maximum Nested levels of functions 7
Number of available worksheet functions 329
For more information on MS Excel limits - please visit -
http://office.microsoft.com/en-us/excel
Hi Ashish,
Try this formula - I just used trim function to solve your issue.
=INDEX(B$2:D$4,MATCH(TRIM(B10),A$2:A$4,0),MATCH(A10,B$1:D$1,0))
--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.
Hi Abdul,
Your requirements are not clear. The data can be fetched using macro/
UDF from sheet 2 but on what basis. Please specify. For elbow45/90
it's only elb in the description. So, please clear your requirements
and description column. The problem can be solved, it's an easy one.
---
Hello,
I need your help with VBA code. In one column I have several different
objects and I need to copy only one of these (11,20,30,60,61) into
another column.
I have prepared this code:
For counter = 0 To not_empty_cells
For counter_dep = 1 To 5
position = InStr(1, (Cells(counter
Hi Mahesh,
I was not able to open your file since I'm with Excel 2003. Please,
could you save as 2003 and re send? If you can have sheet 1 sorted
ascending, I think that you could use Vlookup without "TRUE" argument
at the end.
Thanks,
Chechu
On Sep 5, 4:07 am, Mahesh wrote:
> Dear Firends,
>
Hi,
I need to create a macro that will find the last row/column/cell in a
worksheet, create a list with headers, then format columns 1-4 in a
certain way within the list.
Please let me know if you have any tips - nothing I've tried is
creating able to create a list without first defining the ran
*Dear All Group Members,
*
There are two different files, now i wish to merge data from two sheets into
one sheet.
If any one having macro for such, then i will be really greatful to you, if
you share the same.
Thanks & Regards
*Prasad Gadgil
Cell: 9819442088*
--~--~-~--~~---
I'm having a difficult time with something that sounds pretty simple
on the surface but seems to get devilishly hard (at least for me) as I
look further into it. I need to calculate contract renewal dates based
on the original signing date. For a 1 year term it's pretty straight
forward but for
Hello,
could somebody help me with this please? In one column I have
different objects separated by a comma. I need to select one of these:
11,20,30,60,61 and copy it into another column. I have used this code:
For counter = 0 To not_empty_cells
For counter_dep = 1 To 5
position = I
how do i go about importing a table in powerpoint to excel?
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downl
Dear All, I have a workbook with sheet1 (name of sheet qty) and sheet2(name
of sheet price) I want in Sheet2(price) i.e multiplication of qty and price
cell by cell and then sum of each multiplication in a cell. i.e Qty.Sheet
price sheet Cell c6:c21 c6:c21 Cell d6:d21 d6:d21 ... upto Cell j6:j21
j6
Hi Uma,
I have given the solution in the attached workbook. All logics are working
in conditional formatting itself. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/3/09, Umakant Hale wrote:
>
> F
Hi Gyanesh,
The Table function should be a customised function and can be used to enter
with Ctrl + Shift + Enter key combination of keyboard. If you want to know
about Array formula, below is the help.
Below is what I got when I searched "Array formula" in Excel 2003 in -built
help:-
About a
Hi Satiq,
Follow the below steps:-
1. Select the cell / range where you have the formula. Choose Format ->
Cells.
2. Go to right most page tab "Protection". Check the checkbox against
"Locked" and "Hidden"
3. Go to Tools -> Protection -> Protect Sheet. (give the password if you
want and press
Hi Prashant,
Thanks for the appreciation and one thing which I want to say here that I am
helping others just to give myself "the opportunities to learn".
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/5/
Dear All,
Just want to share , one useful add in named ASAP Utility, which has lot of
customized macros for use. Some good tricks are -
1. Copy value to next line
2. Create index page with clickable option
3. Merge multiple txt, excel sheets
4. Use of is error
Dear Vikas/Satish,
Kindly share the trick with all users
Regards,
Prashant
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of vivek agrawal
Sent: Friday, September 04, 2009 9:09 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Urge
Dear Dilip,
Many thanks , formula is perfect for my need . One more thing, really
appreciate your commitment to provide the solution to each & every query of
the group members
Regards,
Prashant
From: Dilip Pandey [mailto:dilipan...@gmail.com]
Sent: Friday, September 04, 2009 8:
http://www.downloadsource.net/d4189/PDFCreator/
Dear Saurabh,
This one I use, just print document using pdf creator printer.
Regards,
Prashant
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Saurabh
Sent: Friday, September 04, 2009 12:1
Anyone has a template which allows to plan rota of 20+ people
operating 2 shifts?
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Tex
Dear Firends,
need ur help here.
i want to enter number in sheet 2 and want to match it in sheet 1
if the same number is not in the sheet 1 then it will find the nearest
number either +1 or -1.
Please check the attached sheet.
--
With Love,
Mahesh Bisht
--~--~-~--~~~--
I've uploaded an Excel Addin "ColorEasyTune". Looking for testers and
critics.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text),
30 matches
Mail list logo
