=MID(CELL("filename"),FIND("]",CELL("filename"))+1,31)
:)
Hemant Hegde
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), F
Hi Subu,
Press Alt + T + I
Press Alt + B
select the addin and press delete
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/9/09, Subu wrote:
>
>
> Hi Folks
>
> I have used an add-in on one of
Hi Thomas,
'Try below code:-
Sub del()
Cells(1, 1).Select
Selection.EntireRow.Select
For i = 1 To WorksheetFunction.CountA(Range("a:a")) + 15
If WorksheetFunction.CountIf(Selection, "#") > 0 Then
Selection.EntireRow.Delete
Else
Selection.Offset(1, 0).Select
End If
Next
End Sub
Tested File contain
Mr. Daniel
I have tried to apply Pivot Table on the Base Data but could not succeed as
the pop up message showing "Data source reference is not valid".
Please help
Rajeev
On Sun, Sep 20, 2009 at 1:25 PM, Daniel wrote:
> Sorry Here it is.
>
> > -Original Message-
> > From: excel-macros@goo
Have you a problem with my file ? Please send file.
Daniel
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Rajeev Nandan
Sent: dimanche 20 septembre 2009 13:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: How to Show Count of Zero i
Hi
The scenario given by you is there in the attached workbook along with the
solution. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/10/09, fishbonez wrote:
>
>
> i would like to know how can
Hi All:
First off this is a terrific user group and is required reading for my
team!
Here is my question:
I receive a table that has the headers
A1: Name
B1: Address1
C1: State
D1: Zip
The next time, I receive the table with headers may say:
A1: Name
B1: Address1
C1: Address2
D1: State
E1: Zip
Hi Ashish,
Your query has been solved and attached herewith. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/11/09, ashish koul wrote:
>
> hi
>
> i wanted a formula in sheet 2 which will tell me
Hi Jitheesh,
Actually a good query and reasonable too. Attached workbook has been solved
per your requirements. Enjoy..!!
Suggestion:- Do not merge the cells, just for the shake of looks.
Alternatively keep the data in one cell and do a format boarder, justify etc
to keep the reach and area fil
Dear Jitheesh,
Answered this one at 09:39 PM IST. Check that and let me know if you have
any questions. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/15/09, Jitheesh Vazhapully <7jit...@gmail.com
Hi,
You can set the range address to anoter formula, using offset for instance:
=OFFSET('Address'!R1C1,0,match("Zip",'Address'!R1,0)-1)
that will pont to zip column whenever it is...
regards
2009/9/20 MD18358
>
> Hi All:
>
> First off this is a terrific user group and is required reading for
Hi
i have attached 1 file, in this file i want to fill the frequency column
i hv tried count formula but it doesnt work may be the way i m using
the formula is rong
plz help me
Regards
Ruchi
--~--~-~--~~~---~--~~
-
12 matches
Mail list logo