40754651
C - +91 977 3284902
On 6/21/09, ayush jain wrote:
>
> Hi Harish,
>
> Please post your tip in the group. Replying to me won't work.
>
> Thanks.
>
> On Sun, Jun 21, 2009 at 9:14 PM, H Upadhyay wrote:
>
>>
>> *CTRL Key *
>>
>&
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
--~--~-~--~~~---~--~~
--
Hi Tariq
Passwored.xla crack password, but there is some way that we know what is the
password.
Regards
Harish Upadhyay
On 5/18/09, tariq wrote:
>
>
> hello mahesh,
>
> this file password is : AABBBAABBAAP
>
> AND ANY PASSWARD CRACKING SO MAIL ME ...
>
> my e_mail : tariq.78...@gmail.com & con
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
--~--~-~--~~~---~--~
Dear All,
Need ur help, pls suggest how can i create code for Solver
Regards
Harishh Upadhyay
9773284902
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and
n = 23) Then
> Sheets("Sheet2").Cells(1, 1) = Cells(Target.Row, 1)
> End If
> End Sub
>
> hope this helps,
>
> Paul
>
> --
> *From:* H Upadhyay
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, April 21, 2009 11:3
Dear All,
Need ur help
i have data in Sheet 1
A B C D E F G H I J K L M N O P Q R S T U V W X
Y Z
1
2
3
4
5
6
7
8
9
.
.
.
.
.
.
.
.
.
1
is it possible if i click sheet 1 W1 then i will get D1's value in Sheet
2's A1 range
if i click sheet 1 W2 then i will get
chk this
Regards
Harish Upadhyay
On 3/25/09, xxx 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 occupied cel
Dear Group Members
Need ur help
Is it possible taht if we can pickup fields Name from drop down (list) other
than original pivot table & same time Pivot table will changed
automatically?
Pls chk attached file its explain itself
Thanks & Regards
Harish Upadhyay
+919773284902
--~--~-~--
Hi!
Pls chk Attached file
Thanks & regards
Harish Upadhyay
9773284902
On 1/29/09, Chaudhry Zahid Ali 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
> multiple amounts against a
Pls chk attached Add-Ins
Thanks & Regards
Harish Upadhyay
9773284902
On 1/25/09, sarfaraz ahmed wrote:
>
> Hello Vikash,
>
> I think I have achieved what you want and posted the same on my blog.
> Kindly visit the link. Though it does not return after decimal.
>
>
> I think mere modification wou
use CONCATENATE
Thanks & Regards
On 1/22/09, Tobi Hammet wrote:
>
>
> This does not have to be a makro, if its possible.
>
> Source:
>
> A1:5
> A2:7
> A3:7
>
> what i want from this:
>
> B1: 5,7,7
>
> (those values seperated by kommas)
>
> so can it be done without a makro?
>
> >
>
--~--~-
Dear Group,
Need ur help, pls suggest is it possible some macro or formula find some
specific text from data & Add some text in before the text
e.g in a lage data base i have some name containing
"Kumar","Kaur","Chandra", "Kumari"
if name contains Kumar then Mr. will add as prefix like
Pradeep
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
--~--~-~--~~
On 12/4/08, Tom Jeffries <[EMAIL PROTECTED]> wrote:
>
> I am attaching a function (GetRate) that does what you describe. If you
> have any questions let me know.
>
> Tom
>
> On Wed, Dec 3, 2008 at 11:25 AM, raghuveer kumar <[EMAIL PROTECTED]>wrote:
>
>> Hi,
>>
>> I had a small query.
>>
>> I had a
use
=IF(C7>=589,"L",IF(C7>=542,12,11))
Thanks & Regards
Harish Upadhyay
On 11/14/08, jmholt <[EMAIL PROTECTED]> wrote:
>
>
> I'm trying to figure out nested IF statements. The statement below
> works fine except for the last argument:
>
> IF(C7<=542,11,IF(C7<=589,12,L16)).
>
> IF C7=540 then it
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
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.
>
> Reg
=A1&B1&TEXT(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
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
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.
>
>
>
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
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
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 functi
t; 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 Upadhyay <[EMAIL PROTECTED]> wrote:
> > Dear Exports,
&g
Dear Exports,
Need ur help
I have 1 Excel file in which
1. you cant Left Column "F" Blank if Column "E" Not Blank
2. you cant Left Column "G" Blank if "E"= HO
Regards
Harish Upadhyay
-
6th Flr, Solaris Building # 3,
Opp L & T Gate No - 6,
Saki Vihar Road, Powai
And
26 matches
Mail list logo
