Dear All,
pls go through the attached file.
here i m passing row no, is there any way with out passing any row no it
solve entire for entire column
Regards
Harish Upadhyay
9773284902
--~--~-~--~~~---~--~~
Dear Group,
1 reuested to u pls if u r reverting some one's query then pls save ur
attachment in XLS not XLSX,
i thing there are some Learner like me who havent excel 2007, if file in
XLSX format then we are unable to open
Regards
Harish Upadhyay
chk this
Regards
Harish Upadhyay
On 3/25/09, xxx lavanyaredd...@gmail.com wrote:
Hi all,
I need some help since i an beginner in vba programming
I have say an excel table as below:
1 2 3 4 5
2 3 4 5 6 6 78 8 9
hdg dg gdh gj
fsf
sf sfs sfs sf
in this table I have to count number of
Hi!
Pls chk Attached file
Thanks regards
Harish Upadhyay
9773284902
On 1/29/09, Chaudhry Zahid Ali chaudhry.zahid@gmail.com wrote:
Hi,
I have got a little problem that I need to solve I have a sheet with
multiple transactions. The columns include Date and amounts. There are
Dear All,
I Need ur help
i have a excel file having 6 Column 1000 rows
1.mail ID
2.Name
3.Sub
4 Amt
5. 80% of Amt
6. 20% of Amt
i m using lotus note, is it possible a single micro send the all mail to
individul person
Thanks Regards
Harish Upadhyay
9773284902
Chk attached file
Regards
Harish Upadhyay
On 11/4/08, ram bhagath [EMAIL PROTECTED] wrote:
Hi all,,
I have attached the file, and explained the proble there only. I wanted to
pick amount from another table by formula. I tried with vlookup i didnt get
answer. Pls help me.
Regards,
A2 =TEXT(A1,MM/DD/YY) -- u will find date 11/4/2008
A3 =TEXT(A1,HH:MM:SS AM/PM)-- u will find Time 5:51:00 PM
Regards
Harish Upadhyay
On 11/4/08, vinu [EMAIL PROTECTED] wrote:
Hi All,
I have a data like this in a single cell for eg A1 11/4/2008
5:51:00 PM.
I need date in A2
go to
Format Cell -Protection - click on Hidden Check Box - OK
then
Tools - Protection - Protect Sheet - Enter Password
Regards
Harish Upadhyay
On 10/29/08, vinu [EMAIL PROTECTED] wrote:
Hi All,
Could you pls let me know how to hide and unhide only formula in a
particular cell or a
=A1B1TEXT(C1,HH:MM:SS)
Regards
Harish Upadhyay
On 10/29/08, vinu [EMAIL PROTECTED] wrote:
How to concatenate the below one.
A1=India
B1=Bangalore
C1=12:10Am
Thanks in advance.
Vinu.
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
Blank Attachment
Regards
Harish Upadhyay
On 10/25/08, swamy nadan [EMAIL PROTECTED] wrote:
Hi to all
I had attached a xl sheet. In sheet 1 the parts are given and also qty. In
sheet 2 i required the total qty of the parts which in sheet1. Pls give me
any formula to findout.
Thanks in
Pls chk attached file
Regards
Harish Upadhyay
On 10/23/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi All,
I have an issue while using concatenate formula, Can any one of you help me
out with this:
Query:
Column A : MS
Column B : Excel
Column C : 24- Oct-08 ( formated as
pls chk formula in atached file
Thanks Regards
Harish Upadhyay
On 10/6/08, Augustine [EMAIL PROTECTED] wrote:
Hi everybody,
I tried using the DateDif function in Ms-Office 2007 but its not
working. Is there any other way to activate the function since i heard that
the function is
try this confirm
File - Print Preview - Setup - HEader/Footer - Custom Footer - Select The
ICON( #) rightside to format text
Thanx regards
Harish Upadhyay
9773284902
On 9/30/08, vivek jain [EMAIL PROTECTED] wrote:
Thanks for the reply.
But this method does not update page numbers
in column G: =IF(E17=HO,No must be entered between
1- 100,As u wish) this formula means if cell in column E is equal
to HO then in the cell of column G it should show as No must be
entered between 1-100 otherwise it should show as As u wish.
In both columns IF formula has been used
On 9/5/08, H
14 matches
Mail list logo