Dear Expert ,
Help required,
pla find the sample attached file, want to like column final date
Rgd's
LAKSHMAN
--
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 @
*Excel File Password Recovery Software is the good performer tool to
recover Excel file password and unlock Excel file
http://www.excelunlocker.com/ then fastly re-open Microsoft Excel
file.*
Read More-:
http://www.microsoftexcelpasswordrecovery.com/
--
Are you =EXP(E:RT) or
Excel password recovery tool very fastly recover Excel file password and
unlock
MS Excel workbook http://www.excelpasswordunlocker.com/ after then
instantly open Microsoft Excel file..
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Hi,
Use 'End of month' formula and add 720or whatever number of months to find
the date of retirement.(Usually retirement happens at the last day of the month)
- r.karunanithi.
On Wednesday, February 19, 2014 4:29 PM, prabhakar_k...@sify.com
prabhakar_k...@sify.com wrote:
thanks its working
Hi Prafull,
Try this if you want to use In Cell formulas, paste bellow code in module
Function IsOK(CRef As Range) As String
Dim Str As String
Str = UCase(CRef.Value)
If InStr(1, Str, YES) Or InStr(1, Str, NO) Or InStr(1, Str,
CORRECT) Then IsOK = OK
End Function
Then just type in
Thank you very much, i'm not getting words to express ...
Its was simply superb
Can you please teach me . Why was first consolidated workbook was pulling
data even from header for individual production log.(eg: A1, A2, A3 rows)
Is there any option that we can extract data from A4 rows.
Thanks
Hi Rob,
Try this 2 code, first sub code just need a few line code, but it slower
than next sub code, i suggest second sub code if you have large data
list to process
Sub Simple()
Dim Rng As Range
For Each Rng In Sheet1.UsedRange.Offset(1)
If Not Trim(Rng) = Then
try this udf
Function finaldt(st As String) As String
Dim arr, out1 As String
st = Application.WorksheetFunction.Substitute(st, , )
arr = Split(st, /)
For i = LBound(arr) To UBound(arr)
If Len(arr(i)) 1 And InStr(out1, arr(i)) = 0 Then
out1 = out1 /
Sub sample()
Dim cl As Range
Dim j As Integer
For Each cl In Range(a2:m29)
j = 0
If cl.Column 1 Then
j = Application.WorksheetFunction.CountIf(Range(Cells(cl.Row, 1),
Cells(cl.Row, cl.Column - 1)), cl)
End If
If Application.WorksheetFunction.CountIf(Range(a1:m cl.Row - 1),
cl) + j 0
try this link
http://oco-carbon.com/2012/03/06/google-excel-distance-function/
On Tue, Feb 18, 2014 at 8:32 PM, Greg Hart hartg...@gmail.com wrote:
Ashish - thank you for posting. I receive a #value! error in the distance
field. I am using Excel 2013, any assistance is greatly appreciated.
pls share sample file and specify what exactly u wanna do
On Mon, Feb 17, 2014 at 6:30 PM, Manjunath Narayanappa
manjunath.n1...@gmail.com wrote:
Sir,
Can you please help me out with it
Thanks
Manjunath
On Mon, Feb 17, 2014 at 1:09 PM, Manjunath Narayanappa
can u share a sample file
On Tue, Feb 11, 2014 at 10:33 AM, Ty tyrone_...@yahoo.com wrote:
I have an excel Macro to convert columns to rows. Unable to get to work.
Place cursor in A1 on the sheet with the data. Receive error. Stops at
Set target. Maybe I am using excel incorrectly. I
try this
On Mon, Feb 17, 2014 at 4:37 PM, Swapnil Palande
palande.swapni...@gmail.com wrote:
Hi,
I think what Kathir want is to repeat Request ID as per value mentioned in
column F.
Regards,
Swapnil.
On Mon, Feb 17, 2014 at 3:56 PM, Ravinder ravindervbacli...@gmail.comwrote:
13 matches
Mail list logo