Dear Experts...
Good Noon..
Need your help per attached example.
Thanks in advance.
JP.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
Hi Shekhar,
you can use same formula by changing the column type to Text.
excel will treat (8911.11) as negative numeric value.
You just change the Column Type from General to Text and apply the same
formula..
Else
try this...
=RIGHT(A1,LEN(A1)-IF(ISERROR(FIND("(",A1,2)),LEN(A1),FIND("(",A1,2
Dear Excel Experts,
I am having a challenge in addressing the following problem. Your advice is
greatly appreciated.
Background:
I have about 40 Powerpoint Files that I need to analyze the data from. These
files have the data structured such that there are 3 textboxes and a PowerPoint
table w
Hi Ashish,
Thank you so much, the suggestion you provided me worked.
You Rock
Thanks & Regards,
Francis
From: francis vinod
To: "koul.ash...@gmail.com" ;
"excel-macros@googlegroups.com"
Sent: Monday, 6 August 2012 12:59 PM
Subject: Re: $$Excel-Macros
=IF(AND(LEN(D3)<>LEN(M3),RIGHT(D3,8)=RIGHT(M3,8)),L3,"")
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Wednesday, August 08, 2012 12:45 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ formula base on condition
Hi All,
I
Hi Pawel,
please see the attachment.
regards
prince
On Wednesday, August 8, 2012 11:15:30 PM UTC+5:30, lupinskip wrote:
>
> Hi All,
>
> I'm looking for formula that will be checking cell base on the condition
> that last 8 digits will be match, with 8 digits from different cell. Pls
> see a
Hi All,
I'm looking for formula that will be checking cell base on the condition that
last 8 digits will be match, with 8 digits from different cell. Pls see
attachement.
Regards,
Pawel
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (112
hi muneer,
please see the attachment.
prince
On Wednesday, August 8, 2012 5:34:03 PM UTC+5:30, Mohammed Muneer wrote:
>
> Dear Group,
>
>
>
> Make bold the data relevant in the below rows that follows the yellow
> highlighted in cell A1.
>
>
>
>
>
>
>
> Regards,
>
> Muneer,
>
Hi Muneer,
please see the attachment hope this will help you.
regards
prince
On Wednesday, August 8, 2012 6:50:06 PM UTC+5:30, Mohammed Muneer wrote:`
>
> Regards,
>
> Muneer,
>
> CC….
>
>
>
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexce
It would be very difficult to precisely figure the length of text and then
decide on the length of the text and then wrap it
Anyway, in case you want to activate word wrap on any change in the cell,
use
Private Sub Worksheet_Change(ByVal Target As Range)
Target.WrapText = True
End Sub
in t
Hi group,
Hope you will post an excellent solution here :
Let suppose you have a string like below :
A|A|A|B|B|C|A|B|C|D
As you can see the characters are being repeat in this string
output should be : A|B|C|D
I don't think helper column is required J
You can comment here also
htt
Hi Experts
I have added one dropdown in custom menu using xml. can i add their item
value using macros, on workbook_activate method?
Divaker
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use c
Dear friends,
I want to make active the word wrap option here so that the text train
should not cross the page break while typing.
Any formula or vba code is there to be adopted to apply on this.
Regards,
Muneer,
CC
--
Join official facebook page of this
I may not be 100% accurate with this, because programming capabilities change,
but...
VBA is written WITHIN Applications.
Visual Basic is written AS an Application.
(VBScript would be a scaled-down version of VB)
That is to say, if you want to run a VBA macro, you have to have an Application
(l
Dear Group,
Make bold the data relevant in the below rows that follows the yellow
highlighted in cell A1.
Regards,
Muneer,
CC
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for viol
Post a sheet with a sample of the data (at least 20 rows). then we can test
our formulae.
On 8 August 2012 20:35, Shekhar Sharma wrote:
> Guyz,
>
> Can you suggest a VBA code for the same, as I think no formula is working.
>
> I have lots of row and multiple of conditions
>
> Regards
> Shekhar S
Guyz,
Can you suggest a VBA code for the same, as I think no formula is working.
I have lots of row and multiple of conditions
Regards
Shekhar Sharma
On Wed, Aug 8, 2012 at 4:03 PM, Shekhar Sharma wrote:
> Sorry David,
>
> Its not working.
>
> On Tue, Aug 7, 2012 at 5:58 PM, David Grugeon wro
Sorry David,
Its not working.
On Tue, Aug 7, 2012 at 5:58 PM, David Grugeon wrote:
> =MID(A1&B1&C1,SEARCH("(",A1&B1&C1),SEARCH(")",A1&B1&C1)-SEARCH("(",A1&B1&C1)+1)
>
>
>
> On 7 August 2012 21:45, RAJA SEKAR wrote:
>
>> Try This
>>
>> =RIGHT(A1,LEN(A1)-FIND("(",A1,2)) & B1 & IF(LEN(C1)<>FIND("
Hi Raja,
In this case if Column C doesn't have value as 1) and just have values as
(8625.11), this formula is throwing an errror.
On Tue, Aug 7, 2012 at 5:15 PM, RAJA SEKAR wrote:
> Try This
>
> =RIGHT(A1,LEN(A1)-FIND("(",A1,2)) & B1 & IF(LEN(C1)<>FIND(")",C1,1),
> LEFT(C1,FIND(")",C1,1)-1),"")
Hello Friends,
I need to complete a projec. The requirement as follows
1. When i press ENTER button in the INPUT sheet the data should add in
the DATA sheet
2. The cursor should automatically go to the next tex box when i hit
enter button
I would be thankfull if it is done as soon a
Hello Bhopal,
Another sumproduct output result.
PFA.
On Tuesday, August 7, 2012 2:13:53 PM UTC+3, Excel ka Keeda wrote:
>
> Dear Members,
>
> I am facing one challange in Excel 2003, I want the to creat a summary
> from raw data in attach file, i tried it with Sumproduct, but that formula
21 matches
Mail list logo
