which version of excel r u using
On Mon, Mar 17, 2014 at 12:22 PM, Prabhu Pinky wrote:
> Guys...pls help with my query
> On 17-Mar-2014 9:22 AM, "Prabhu Pinky" wrote:
>
>> Hi Experts,
>>
>> Please find the attached file. there i used many SUMPRODUCT formula. it
>> slow down my excel.
>>
>>
Guys...pls help with my query
On 17-Mar-2014 9:22 AM, "Prabhu Pinky" 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, if u give me
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 wrote:
> Thanks Ashish.
>
>
> On Sun, Mar 16, 2014 at 8:56 PM, ashish koul wrote:
>
>> then try left and fi
Thanks Ashish.
On Sun, Mar 16, 2014 at 8:56 PM, ashish koul wrote:
> then try left and find function combined
>
>
> On Sun, Mar 16, 2014 at 1:02 AM, Indrajit $nai wrote:
>
>> Yes Ashish...
>>
>>
>> On Sat, Mar 15, 2014 at 3:39 PM, ashish koul wrote:
>>
>>> is ACT common in all
>>>
>>>
>>> O
Function workbook_path(txt1 As String) As String
Dim pathname As String
Dim wkb As Workbook
pathname = Environ("Temp") & txt1 & " " & VBA.Format(VBA.Now,
"ddmmmyy_hhmmss") & ".xlsx"
If Sheets("Branch Name").AutoFilterMode = True Then
Sheets("Branch Name").AutoFilterMode =
Sub TES()
Dim i As Long
Dim cl As Range
For Each cl In Sheets("Sheet1").Range("c1:c31")
If Weekday(cl.Value, vbMonday) < 6 Then
With Sheets("Sheet2").Range("XFD2").End(xlToLeft).Offset(0, 1)
.Value = cl
.NumberFormat = "DD-MMM-"
End With
End If
Next
End Sub
On Sun, Mar 16, 2014 at 8
thanks asish,
but in second sheet, names should start from 3rd row only. i mean from B3
onwards only.
Thanks & Regards,
Prabhu R
On 16 March 2014 12:50, ashish koul wrote:
>
> Sub test()
> Dim cl As Range
> Dim j As Long
> For Each cl In Sheets("Sheet1").Range("b3:b7")
> j = Sheets("Sheet2")
then try left and find function combined
On Sun, Mar 16, 2014 at 1:02 AM, Indrajit $nai wrote:
> Yes Ashish...
>
>
> On Sat, Mar 15, 2014 at 3:39 PM, ashish koul wrote:
>
>> is ACT common in all
>>
>>
>> On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai
>> wrote:
>>
>>> Hi Experts,
>>>
>>> Is ther
use this function
http://support.microsoft.com/KB/213360
http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html
Regards
Ashish
On Sat, Mar 15, 2014 at 7:42 PM, irshad khan wrote:
> Hi Team,
>
> Is it possible to convert numeric value to alpha value.
>
> example :
> 1
using data validation or with vba you can add conditions to cells
On Fri, Mar 14, 2014 at 10:41 PM, Carlos Antonio
wrote:
> Olá.
>
> Na planilha que estou melhorando há os seguintes campos: cpf, nome, email
> E nomebreve.
>
> Necessito o seguinte;
>
> 1 - cpf : somente seus números e quantidade
For those who would like to recommend a learning Excel VBA programming
course, Cal Poly is offering it's first MOOC, "Introduction to VBA/Excel
Programming."
>From the course website:
"In this free 10-week online course, you will learn the fundamentals of
computer programming using the Visual
Sub test()
Dim cl As Range
Dim j As Long
For Each cl In Sheets("Sheet1").Range("b3:b7")
j = Sheets("Sheet2").Range("C65356").End(xlUp).Row
Sheets("Sheet2").Range("C" & j & ":c" & j + 3).Value = cl.Value
Next
End Sub
On Sun, Mar 16, 2014 at 12:21 PM, Prabhu Pinky wrote:
> hi experts,
>
> PFA
12 matches
Mail list logo
