Any examples?
On Jun 24, 7:12 pm, Levi 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?
>
> Levi
--~--~---
Thanks Dilip,
Dave.
Date: Wed, 24 Jun 2009 15:39:43 +0530
Subject: $$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or
lower 00 Figures
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
Hi Dave,
Below is what I found when I searched Excel 2003 help section f
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
>
> (I've been told that my previous post was confusing, s
Use this formula:
=ROUND(A8;-2)
2009/6/23 ddp
>
> 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 easier to remember near
I'm sure that your example is a very SIMPLIFIED version of what
you want to do...
I'm also going to assume that you know (or have a method to figure out)
which rows/columns you want to use from the named range.
The problem is that your named range is exactly that, a range.
To select a specific ro
On Wed, Jun 24, 2009 at 4:48 PM, jander wrote:
>
> (I've been told that my previous post was confusing, so I'll try
> again.)
>
> Suppose I have 2 columns, one contains odd numbers, the other even
> numbers. They are named ranges "Odd" and "Even", respectively.
>
> A B
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 wrote:
> Thanks Aindril, but there is no attached file and the th
That sounds like a nice problem for the solver add-in. all linear
constraints. That will tell you if its possible or not. I dont think
a macro is needed?
On Jun 24, 11:51 am, Abdul Rehman wrote:
> Hi All,
>
> Is it possible to program a excel sheet to schedule 4 call center agents
> working i
Thanks Deepak..this will help..
Regd,
Dharmendra
On 6/24/09, MOKSH.. wrote:
> gud
>
> 2009/6/24 Deepak Gupta
>
>>
>> Dear ,
>>
>> use function @MROUND(FIGURE,50)
>>
>>
>> DEEPAK
>>
>> On 6/23/09, Dharmendra Kumar wrote:
>> > Hi members,
>> >
>> > Hope you all are doing well.
>> >
>> >
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 a
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
Hey Harmeet,
Thanks a lot bro,
but can i have form1 loading after inputing the call id ? and 2nd part of
my last mail i.e without any information also the call is getting logged.
Kindly look at it.
thanks
Hems
On Wed, Jun 24, 2009 at 1:44 AM, Harmeet Singh wrote:
>
>
> On Tue, Jun 23, 200
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 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
>
I hope it will help a lot of people who must be looking for these
problems.
So here is my first solution of one of the most asked question while
working in MS-Excel.
Suppose we have a data consisting of months and the some values
related to those months. Name of the months are appearing more tha
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)
Bu
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
--~--~-~--~~~---~--~~
-
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,
HI,
Thanks, Really it works and saving my times
SHIVA
On Wed, Jun 24, 2009 at 1:00 PM, Dilip Pandey 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 combination CTRL + `
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: Wed
gud
2009/6/24 Deepak Gupta
>
> Dear ,
>
> use function @MROUND(FIGURE,50)
>
>
> DEEPAK
>
> On 6/23/09, Dharmendra Kumar 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
it will help u
=UPPER(LEFT(C3,1))&LOWER(RIGHT(C3,LEN(C3)-1))
with regards
Moksh
2009/6/24 Subu
>
> 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
>
> ...and so
Sorry forgot to upload the file...
Regards,
Andy
On Wed, Jun 24, 2009 at 8:38 PM, Aindril De 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 type \"
>
>
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 wrote:
> Hi Everybody,
>
> Please
(I've been told that my previous post was confusing, so I'll try
again.)
Suppose I have 2 columns, one contains odd numbers, the other even
numbers. They are named ranges "Odd" and "Even", respectively.
A B C
1Odd Even
21 2
33
Hi subu
find the attach which is solve your problem
Jayavelu
9941260857
On Wed, Jun 24, 2009 at 1:40 PM, Subu 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 SIX
> nam
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 Rep
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,
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 wrote:
> Hi Subu,
>
> Use the following function:-
> =PROPER(MID(A1,1,FIND("_",A1)-1))&"_"&LOWER(RIGHT(A1,LEN(A1)-FIND("_",A1)))
>
> Solved workbook is also
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 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 wrote:
> H
use
+PROPER(A1)
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Jun 24, 2009 at 1:40 PM, Subu wrote:
>
> Dear List members and XL Gurus
>
> I have an XL sheet with a column that looks something like
>
> Name_On
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 wi
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,
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.c
Hi Dave,
Below is what I found when I searched Excel 2003 help section for "MROUND
function".
Please go through it.
Thanks,
==
=
+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 Tool
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 ki
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
...and so on
I wish to get them all with the first Character in upper case and the
rest all in lower case
I.e. something like
Name
Dear ,
use function @MROUND(FIGURE,50)
DEEPAK
On 6/23/09, Dharmendra Kumar 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 figures
>
> Solution:
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 same,
Hello Every one ,
This is very gud tip,Congratulations to *Mr.Rajesh Kunder* for winning the
Tip award ,KEEP IT UP
This makes us to improve our excell knowldge and helps us in saving of time
regards,
Shiva
On Mon, Jun 22, 2009 at 7:49 PM, Ayush wrote:
>
> Hello Everyone,
>
> Please congr
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: Wed,
Hi,
You can use the ordinary rounding function.
The formula would be:
=ROUND(A3,-2)
While '=ROUND(A3,2)' would round to 2 places LEFT of the decimal point,
'=ROUND(A3,-2)' rounds numbers to 2 places RIGHT of the decimal point.
Hope this helps.
Regards - Dave
> Date: Tue, 23 Jun 2009 10:37:34
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 COM(H
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 c
45 matches
Mail list logo
