Hi Shiv,
If you just want to know the information of linked cells/sheets then, One
way could be (CTRL + ` (grave accent))
Go to main sheet tab and press key combination CTRL + `
It will show up the formula used and the sheet names as well.
Note:- If you have some external workbook links then you
Hi ddp,
It is not as big as you have presented. Try the below formula and you will
have the required result.
=+MROUND(A3,100)
'where A3 is the reference
I have tested this on a workbook and same is attached herewith for your
reference.
Thanks,
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B
Hi Dilip,
When I open your workbook (with XL2000), it functions as you say it should.
However, when I type in '=+MROUND(A3,100)' to any cell, I get a #NAME? error.
I don't see 'MROUND' in the function list, or the use of the '+'
Can you tell me what's happening please?
Regards - Dave.
Date:
Hello Group,
I have an excel file that have large number of data (both numbers and
texts). My query relates to detecting the values that are duplicate in
nature, however distinguished by a single text or number. For example:
Inv Number
123
123A
123B
123C
In the above example, the number is
Dear ,
use function @MROUND(FIGURE,50)
DEEPAK
On 6/23/09, Dharmendra Kumar dharmendrakumar...@gmail.com wrote:
Hi members,
Hope you all are doing well.
Please help me with a solution which, I am sure, will benefit others too.
Problem: It is very difficult to remember tones of
Hi Dharmendra,
You can use built in MRound Function in Excel.
If Cell A1 have value of 2723, MRound(A1,100) Would give you 2700.
Regards,
Upendra Singh
9910227325
-
There are 10
+MROUND returns a number rounded to the desired multiple.
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.
Follow these steps
1. On the *Tools* menu, click *Add-Ins*.
2. In the *Add-Ins available* list, select the *Analysis
Hi Dave,
Below is what I found when I searched Excel 2003 help section for MROUND
function.
Please go through it.
Thanks,
==
Hi Subu,
Use the following function:-
=PROPER(MID(A1,1,FIND(_,A1)-1))_LOWER(RIGHT(A1,LEN(A1)-FIND(_,A1)))
Solved workbook is also attached for your reference. Thanks
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New
Hi Ankit,
Try below formula, right next to your column:-
=IF(ISNUMBER(A2),IF(ISNUMBER(MATCH(*A2*,A:A,0)),Keep,Delete),Delete)
Now go ahead and filter out the Delete rows. Select Delete from the
drop down and use Alt+; key combination and then press delete / or delete
entire row, as per your
Hi Mech,
It sounds like you want someone to work on your request on urgent basis and
that to with full dedication.
Friend..!!, we are here to help each other voluntarily and not to charge
money. You can post your query to this group and believe me, there are
many great minds in this group who
Hi Ankit,
Follow the following steps
Sort Inv No Column
write formuls as shown in Column B
Copy Paste the values in Column C
Delete all the rows which have returned '#VALUE'
Attached .xls for your reference.
Regrads
Srinivesulu Yarasi
On Wed, Jun 24, 2009 at 12:29 PM, Ankit Mehra
Hey use this code..
Sub SentenceCase()
For Each cell In Selection.Cells
s = cell.Value
Start = True
For i = 1 To Len(s)
ch = Mid(s, i, 1)
Select Case ch
Case .
Start = True
Case ?
Start = True
Case a To z
If Start Then ch = UCase(ch): Start =
Hi,
Use following formula:
=UPPER(LEFT(B15,1))LOWER(RIGHT(B15,LEN(B15)-1))
Regards,
Swapnil.
On Wed, Jun 24, 2009 at 4:16 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Subu,
Use the following function:-
=PROPER(MID(A1,1,FIND(_,A1)-1))_LOWER(RIGHT(A1,LEN(A1)-FIND(_,A1)))
Solved workbook
Hi Everybody,
Please help me.
I have a file with a lot of inverted commas in cells which should be \ and
many cells have large data due to which 'find and replace' command not working
and saying too long formula.
How can I replace this. Please help me.
Thanks You
How can I replace
Hi Sandeep,
One quick way could be, copy the data from cell and paste that into
Notepad. Now copy again data from Notepad and paste in another Excel tab,
by clicking on a single cell. This will distribute the data in different
cells / rows.
After doing this, you can go ahead and use Find and
Hi subu
find the attach which is solve your problem
Jayavelu
9941260857
On Wed, Jun 24, 2009 at 1:40 PM, Subu mail_to_s...@yahoo.com wrote:
Dear List members and XL Gurus
I have an XL sheet with a column that looks something like
Name_One
nAme_two
NAME_THREE
name_four
name_fIVe
name
Dear Sandeep,
Please find attached the updated file. It shd not be an issue.
Just say select all... then Ctrl + H to open the Find Replace box...
In Find type
In Replace type \
Then press replace all.
Regards,
Andy
On Wed, Jun 24, 2009 at 6:46 PM, Sandeep sandymau...@gmail.com wrote:
Hi
Sorry forgot to upload the file...
Regards,
Andy
On Wed, Jun 24, 2009 at 8:38 PM, Aindril De aind...@gmail.com wrote:
Dear Sandeep,
Please find attached the updated file. It shd not be an issue.
Just say select all... then Ctrl + H to open the Find Replace box...
In Find type
In Replace
it will help u
=UPPER(LEFT(C3,1))LOWER(RIGHT(C3,LEN(C3)-1))
with regards
Moksh
2009/6/24 Subu mail_to_s...@yahoo.com
Dear List members and XL Gurus
I have an XL sheet with a column that looks something like
Name_One
nAme_two
NAME_THREE
name_four
name_fIVe
name SIX
name sevEN
gud
2009/6/24 Deepak Gupta dpk1...@gmail.com
Dear ,
use function @MROUND(FIGURE,50)
DEEPAK
On 6/23/09, Dharmendra Kumar dharmendrakumar...@gmail.com wrote:
Hi members,
Hope you all are doing well.
Please help me with a solution which, I am sure, will benefit others too.
Thank you Dilip, but then it will not possible to revert back data in same
cell. There are many cell with this problem.
I found an alternate way using substitute() function.
Any way thanks you.
- Original Message -
From: Dilip Pandey
To: excel-macros@googlegroups.com
Sent:
HI,
Thanks, Really it works and saving my times
SHIVA
On Wed, Jun 24, 2009 at 1:00 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Shiv,
If you just want to know the information of linked cells/sheets then, One
way could be (CTRL + ` (grave accent))
Go to main sheet tab and press key
Thanks Aindril, but there is no attached file and the this process is not
working.
- Original Message -
From: Aindril De
To: excel-macros@googlegroups.com
Sent: Wednesday, June 24, 2009 7:08 PM
Subject: $$Excel-Macros$$ Re: replace when large data in cell
Dear Sandeep,
I am wanting to parse through a data range one row at a time. Looking
for pairs of numbers. Then display the results of the most common
pairs in a cell on the Excel spreadsheet. Can anyone help with a task
like this?
Levi
--~--~-~--~~~---~--~~
Hello All,
I have 2 Question... Please provide me some solution for those
Question I: How to add an Icon at the upper Left Corner of the
UserForm?
I have tried using .ico File
Question 2: How to Change the backcolor of the MessageBox?
I tried as -- MsgBox.Backcolor = RGB(10,10,10)
But
Hi Subu,
use the function =proper(cell)
e.g., it will be =proper(A2), if your text is in A2.
*Sri*
On Wed, Jun 24, 2009 at 1:40 PM, Subu mail_to_s...@yahoo.com wrote:
Dear List members and XL Gurus
I have an XL sheet with a column that looks something like
Name_One
nAme_two
NAME_THREE
I have a user who after running a macro, has strange formatting
applied to cells in any subsequent workbooks opened in the same Excel
session. When I select one of these strangely formatted cells, I'm
unbale to display the Format Cells dialog.
Anybody encounter anything like this before?
Martin
Hi All,
Is it possible to program a excel sheet to schedule 4 call center agents
working in 3 different shift(0630-1430, 1430-2230 and 2230-0630) for 6 days
in a week( 4 days for call center operations and for 2 days for other
works) and getting single day off on different days...
What I want to
Thanks Deepak..this will help..
Regd,
Dharmendra
On 6/24/09, MOKSH.. krishna.ange...@gmail.com wrote:
gud
2009/6/24 Deepak Gupta dpk1...@gmail.com
Dear ,
use function @MROUND(FIGURE,50)
DEEPAK
On 6/23/09, Dharmendra Kumar dharmendrakumar...@gmail.com wrote:
Hi members,
Hi Sandeep I hope you have recd the attached file now...
The process explained to you... was used to derive the result you
required...
By the way do you use MS Office 2003?
Regards,
Andy
On Wed, Jun 24, 2009 at 8:50 PM, Sandeep sandymau...@gmail.com wrote:
Thanks Aindril, but there is no
Use this formula:
=ROUND(A8;-2)
2009/6/23 ddp dharmendrakumar...@gmail.com
Hi members,
Hope you all are doing well.
Please help me with a solution which, I am sure, will benefit others
too.
Problem:It is very difficult to remember tones of figures
Solution: It is
Place the excell cursor in the C2 cell.
Create a name range with name Odd and referencing the cell A2 without $
for rows, e.g.: =$A2
Do the same for Even refeering to B3: =$B3
Then you cuold use the formula = Odd+Even
2009/6/24 jander jim.ander...@bankofamerica.com
(I've been told that my
Any examples?
On Jun 24, 7:12 pm, Levi rlsmalls...@gmail.com wrote:
I am wanting to parse through a data range one row at a time. Looking
for pairs of numbers. Then display the results of the most common
pairs in a cell on the Excel spreadsheet. Can anyone help with a task
like this?
34 matches
Mail list logo