Hi Indrajit,
try this
=IF(ISERR(FIND(ACT,A4,FIND(ACT,A4)+1)),LEFT(A4,FIND(ACT,A4)-1),LEFT(A4,FIND(ACT,A4,FIND(ACT,A4)+1)-1))
On Mon, Mar 17, 2014 at 12:32 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Thanks Ashish.
On Sun, Mar 16, 2014 at 8:56 PM, ashish koul
Guys...pls help with my query
On 17-Mar-2014 9:22 AM, Prabhu Pinky prabhupin...@gmail.com wrote:
Hi Experts,
Please find the attached file. there i used many SUMPRODUCT formula. it
slow down my excel.
please help with macro or any simplified formula.
*am doing this on a daily basis,
which version of excel r u using
On Mon, Mar 17, 2014 at 12:22 PM, Prabhu Pinky prabhupin...@gmail.comwrote:
Guys...pls help with my query
On 17-Mar-2014 9:22 AM, Prabhu Pinky prabhupin...@gmail.com wrote:
Hi Experts,
Please find the attached file. there i used many SUMPRODUCT
Thanks Shahzad.
On Mon, Mar 17, 2014 at 12:04 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Hi Indrajit,
try this
=IF(ISERR(FIND(ACT,A4,FIND(ACT,A4)+1)),LEFT(A4,FIND(ACT,A4)-1),LEFT(A4,FIND(ACT,A4,FIND(ACT,A4)+1)-1))
On Mon, Mar 17, 2014 at 12:32 AM, Indrajit $nai
Greetings
I have created a code which takes a long time to run. The code has certain
messages to be displayed in the window e.g. CIRCULATION LOOP NUMBER _,
ANGLE OF ATTACK LOOP NUMBER _ etc. It must popup when the command button
is pressed, and display the messages when prompted by the main
Am using excel 2007.
On 17-Mar-2014 12:24 PM, ashish koul koul.ash...@gmail.com wrote:
which version of excel r u using
On Mon, Mar 17, 2014 at 12:22 PM, Prabhu Pinky prabhupin...@gmail.comwrote:
Guys...pls help with my query
On 17-Mar-2014 9:22 AM, Prabhu Pinky prabhupin...@gmail.com
Y don't u use sumifs or countifs
Sent on my BlackBerry(R) from Vodafone
-Original Message-
From: Prabhu Pinky prabhupin...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 17 Mar 2014 15:48:28
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject:
can you workout and send me..i did tried.. but am not getting result.
if you provide VBA code.. it would be so great.
Thanks Regards,
Prabhu R
On 17 March 2014 15:51, koul.ash...@gmail.com wrote:
Y don't u use sumifs or countifs
Sent on my BlackBerry(R) from Vodafone
Error status No Error ? C ? NC ?
Error --How to find out Quality- how to find out
Regards,
Prafull Jadhav
9920553518
On 17 March 2014 16:58, Prabhu Pinky prabhupin...@gmail.com wrote:
can you workout and send me..i did tried.. but am not getting result.
if you provide VBA code.. it
Please check and ..let me know.
Regards,
Prafull Jadhav
9920553518
On 17 March 2014 21:12, Prafull Jadhav prafulltjad...@gmail.com wrote:
Error status No Error ? C ? NC ?
Error --How to find out Quality- how to find out
Regards,
Prafull Jadhav
9920553518
On 17 March 2014
Experts
How to lock only columns in vba...row reference should be change...
I want to lock only column range
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
Hi Prabhu,
You can use..
I = 1
Range(A1:A i)
I = I + i
===
Cells(i ,a)
Use I counter to increment the row no. Hope it will help
Thanks regards,
http://mrexcel4u.blogspot.com/ www.MrExcel4U.com
From: excel-macros@googlegroups.com
Hi please find below snapshot.
i used sumifs formula and get value in cell D4 using VBA code as below.
=SUMIFS('Audit details'!$L$3:$L$54,'Audit
details'!$H$3:$H$54,Sheet2!$B3,'Audit
details'!$B$3:$B$54,Sheet2!D$2)
in which the yellow highlighted cell refers the agent AAA, when i run the
macro
Pfa,,
Type:=8 refer to range
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu Pinky
Sent: Sunday, March 16, 2014 12:21 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ query2
hi experts,
PFA, i have few names in sheet 1, my
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu Pinky
Sent: Sunday, March 16, 2014 8:02 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ query need help
Hi experts,
please find the attached file. my query is.
i want
15 matches
Mail list logo