Hi
Try :
Use below formula in Conditional Formatting
=SUM(LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(ROW(INDIRECT(65:90))),)))=3
Reference :http://dmcritchie.mvps.org/excel/strings.htm
Thanks
Mahesh
On Thu, Jul 28, 2011 at 3:39 AM, qcan comeonove...@gmail.com wrote:
Hi,
Can anyone help me with some
Where is the file?
On Fri, Jul 29, 2011 at 3:14 PM, ICWAI Help icwai.answ...@gmail.com wrote:
HI Ashish,
i have updated the VB password for my excel file while but i am not able to
open now.could you please let me knwo is there any other way to open the
codes.in that.
Thansk,
ICWAI.
It will be very difficult to move the code to the personal.xlsb workbook
without the initial file retaining some code. Can you explain why you want
to do so ? Maybe there should be alternative solutions.
Regards.
Daniel
De : excel-macros@googlegroups.com
Hi,
Do you want to add the rows of each sheet below the preceding ones, or do
you intend to consolidate the sheets like you'll do it with Data,
Consolidate menus ?
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part
Hey Thanks people.. never knew that the Refresh All option eixsted
!..appreciate the help.
Regards,
Ruchi
On Tue, Jul 26, 2011 at 8:13 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Sub allpivotsofworkbook()
activeworkbook.Refreshall
end sub
On Mon, Jul 25, 2011 at 11:55 PM, XLS S
Dear Experts
Is there any use of MS access when a company is using SAP R/3 ?
Regards
Jatin
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
i would like to add rows of respective sheets to be added below one another.
i have never run a macro. Can you please give step by step instruction.
On Sun, Jul 31, 2011 at 5:27 AM, Daniel dcolarde...@free.fr wrote:
Hi,
Do you want to add the rows of each sheet below the preceding ones, or do
Hi,
In AF2 (array formula, validate with Ctrl+Shift+Enter) :
=INDEX($A$1:$AE$1,1,MAX(IF($B$2:$AE$2=P,COLUMN($B$2:$AE$2
Copy down.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de maulik desai
Envoyé : dimanche 31
=INDEX($A$1:$AE$1,SUMPRODUCT(MAX(($B2:$AE2=P)*COLUMN($B$1:$AE$1
will work without an array formula Dan :)
On Jul 31, 5:20 pm, Daniel dcolarde...@free.fr wrote:
Hi,
In AF2 (array formula, validate with Ctrl+Shift+Enter) :
=INDEX($A$1:$AE$1,1,MAX(IF($B$2:$AE$2=P,COLUMN($B$2:$AE$2
HI,
just copy paste the below formula till your last employee which will give
you accurate results
=INDEX($A$1:$AE$1,1,MAX(IF($B2:$AE2=P,COLUMN($B$2:$AE$2
as mentioned bellow with Ctr+shift+Enter
On Sun, Jul 31, 2011 at 5:50 PM, Daniel dcolarde...@free.fr wrote:
Hi,
** **
In AF2
Sorry, it should have more correct to write SUMPRODUCT IS an array
function.
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Daniel
Envoyé : dimanche 31 juillet 2011 15:31
À : excel-macros@googlegroups.com
Objet : RE:
Open the workbook where the results are to be copied in. The macro adds maps
and shipment sheets so there should be no such sheets in the workbook. Press
the Alt+F11 keys, this opens the VB Editor window. Now, keep in mind that I
use a French version of Excel, so the words I use may not be Exactly
Hello,
I protected the sheet (password : excel). In the sheet module I put the
macro :
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
ActiveSheet.Unprotect excel
For Each c In Target
If c Then c.Locked = True
Next c
Dear Maulik,
Please try it with ctrl+shift+Enter
=OFFSET($A$1,0,LARGE(IF(B2:AE2=P,COLUMN($B$1:$AE$1),),COLUMN(1:1))-1)
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Sun, Jul 31, 2011 at 1:56 PM, maulik desai
Thank You Daniel. I really appreciate it.
On Sun, Jul 31, 2011 at 10:52 AM, Daniel dcolarde...@free.fr wrote:
Open the workbook where the results are to be copied in. The macro adds
maps and shipment sheets so there should be no such sheets in the workbook.
Press the Alt+F11 keys, this opens
Hello Maulik,
If you just have single characters in cells like A,P etc... use this,
AF2 copy down.
=LOOKUP(10,SEARCH(p,B2:AE2),B$1:AE$1)
Or,
=LOOKUP(2,1/(B2:AE2=p),B$1:AE$1)
The first one is more faster than second one.
HTH
Haseeb
For tips visit;
http://www.excelfox.com/forum/forum.php
--
Dear daniel,
Actually the raw data for worksheet *ANALYSIS* was
downloaded from *SAP -ERP *,With help of macro it is consolidated into
a*pivot table
* in worksheet *analysis*.Every day i have to do this process many
times,That's why i propose to include in Personal macro
Hey All,
Please find the below link...
http://www.familycomputerclub.com/
http://www.wuala.com/subashvt/Excel%20Macro%20Training/
--
--
Some important links for excel users:
1. Follow us on
Can you attach a sample file such as issued from SAP ? The next point to
discuss is the detail sheets from the pivot. Do you want all of them or only
the ones you double clicked on the value field
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part
Any help in shortening or optimizing this formula would be great. Im
limited by the nested if statements to match week numbers (column s)
and week ended date (Column T), and continue to bog down the
recalculations. It does work, but slows things down.I'm using it
to determine if a date falls
Dear Sir
The formula given by Mr.Daniel is awesome but will give wrong results except
for the first set. A slight modification as given below will bring out the
intended result.
=INDEX($A$1:$AE$1,1,MAX(IF($B2:$AE2=P,COLUMN($B2:$AE2
In the above formula, the second and the third ranges should
Hi,
Try this:
=IF(A5=$T$5,$S$5,IF(A5=$T$6,$S$6,IF(A5=$T$7,$S$7,IF(A5=$T$8,$S$8,IF(A5=$T$9,$S$9,IF(A5=$T$10,$S$10,))
The multiple IF statement stops as soon as it finds a TRUE. So you don't need
to use AND statements to create 'windows'
The above asks:
Is A5 greater or equal to T5? - No -
22 matches
Mail list logo