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
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
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 apkra...@gmail.com wrote:
Try This
=RIGHT(A1,LEN(A1)-FIND((,A1,2)) B1 IF(LEN(C1)FIND(),C1,1),
Sorry David,
Its not working.
On Tue, Aug 7, 2012 at 5:58 PM, David Grugeon da...@grugeon.com.au wrote:
=MID(A1B1C1,SEARCH((,A1B1C1),SEARCH(),A1B1C1)-SEARCH((,A1B1C1)+1)
On 7 August 2012 21:45, RAJA SEKAR apkra...@gmail.com wrote:
Try This
=RIGHT(A1,LEN(A1)-FIND((,A1,2)) B1
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 shekhar1...@gmail.comwrote:
Sorry David,
Its not working.
On Tue, Aug 7, 2012 at 5:58 PM,
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 shekhar1...@gmail.com 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
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
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
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
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
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
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
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/discussexcel
FORUM
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,
CC….
--
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
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
=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'm
Hi Ashish,
Thank you so much, the suggestion you provided me worked.
You Rock
Thanks Regards,
Francis
From: francis vinod francis_vi...@yahoo.co.in
To: koul.ash...@gmail.com koul.ash...@gmail.com;
excel-macros@googlegroups.com
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
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...
20 matches
Mail list logo
