*Hi siti Vi*
*
*
*Thanks for your reply .That was efficient*
*
*
*But i had a problem the order of the values may not be the same in all
sheets*
*
*
*for example:if 17 is in row 17 in sheet A it may be in row 20 in sheet
B*
*Your code works effectively if the order is same.You are comparing with
Dear Siti
Really thaks for the reply This reduce my work greatly
Shrinivas
On Sun, Oct 10, 2010 at 5:37 PM, siti Vi villager.g...@gmail.com wrote:
Dear shrinivas,
you can put this formula
*=B4+BeforeThisSheet(C4)*
and copy to another sheet (except sheet1 / *most left* tab sheet in
Hi Alfred,
Please don't apologise for your English. We are quite tolerant here.
Have a look at the attached. First click on the 'Subject' buttons. You will
notice that clicking any one of them puts a Yes in it's Row, and changes the
other Rows to No.
Use these buttons to select which subject
Dear Alan
Apply tis formula and your problem will be over.
VlOOKUP Function needs 4 parameters your 1st,2nd, 4th parameters are
correct but in the 3rd parameter (Column no.) you supplied the column
address that is $E:$E. I have just changed it to column no. 2 which is
second column of your table
Dear,
Please find herewith VBA vlookup
one
Value look up in column 1 6
Value look up in column 2 vlookup2(F10, F11, tLookupDemo, 3) Result
Option Explicit
''
I have a simple function that looks at a single cell for it's value.
If it's an X, then i'd like for a form to appear. I'd like to pass
the value rng.row to the form so I can know which row I'm
manipulating. I've failed so far in my attempts to do just that. Any
tips would be awesome.
Function
How are you calling the function?
I copied your function to a module.
I changed it to:
Function DeviceForm(rng As Range) As String
If UCase(rng.Value) = X Then
MsgBox Row: rng.Row
End If
End Function
so that I didn't have to create a userform.
then put a X in A2.
in B2 I put:
hi excel experts i have a small problem
MY DATE AND TIME FORMAT IS mm/dd/ hh:mm am/pm
I WANT
TO CHANGE COL: A CHANGED IN TO COL:A
=
col:a col:a
=
10/11/2010 18:37
The trick here is to understand that Excel doesn't know anything
about dates and time.
What it does is take the number of days since 1/1/1900
and INTERPRETS it as days and fraction of days.
So..
10/11/2010 @ 6:37pm is actually
40462 days since 1/1/1900
and .775694 of another day,
or
HI ALL EXPERRTS
IS THERE ANY WAY TO FILTER THE DATA 1/10/10 TO 10/10/10 IN EXCEL,
THANKS IN ADVANCE TO HELP ME.
RAJESH KAINIKKARA
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
refer the attachment
Srinivasan
On Mon, Oct 11, 2010 at 10:21 PM, Rajesh K R rajeshkainikk...@gmail.comwrote:
HI ALL EXPERRTS
IS THERE ANY WAY TO FILTER THE DATA 1/10/10 TO 10/10/10 IN EXCEL,
THANKS IN ADVANCE TO HELP ME.
RAJESH KAINIKKARA
--
updated one
On Mon, Oct 11, 2010 at 10:41 PM, Srinivasan Ethirajalu
srinivasan.ethiraj...@gmail.com wrote:
refer the attachment
Srinivasan
On Mon, Oct 11, 2010 at 10:21 PM, Rajesh K R
rajeshkainikk...@gmail.comwrote:
HI ALL EXPERRTS
IS THERE ANY WAY TO FILTER THE DATA 1/10/10
First of all thank you for any effort put in this direction. I am
having problems with a couple excel formulas that I really need to get
right for a client.
Here is the deal:
WORKSHEET 1
Column1 = email address
Column2 = ***This column I want the sum of events on new years but
having problems
I am having a problem with a forumla I am hoping someone out there can
help me with.
What I am trying to do is use a vlookup to give me the amount of
unique stores attributed to an email address. OR if it is better to
use one of the many SUM options (which one?) to create an additional
column to
Hi
I'm trying to have an interactive text box which I could input some
words and at the same time refer to a few different data cells in the
spreadsheet. I'm not familiar with VBA thus is there any easy way?
Many Thanks
--
I have a file that is gl accts and $$ amts with a subtotal at the
bottom. I need to copy down and then over and then come back up off
of the subtotal line. I tried offset and resize but couldn't get it
to do a row instead of a cell.
--
Hi,
what about a hidden sheet?
On Mon, Oct 11, 2010 at 11:23 PM, hemant shah hemanthin...@gmail.comwrote:
Hi All,
Can you please help me with my query regarding the password change in VBA.
Thanks in advance.
Waiting for the resolution on my query.
Regards,
Hemant Shah
--
if your list of data (some data = duplicated data) are stored in C3:C26
then *The Count of Unique Values *is
*=SUM(1/(COUNTIF(C3:C26,C3:C26)))*
best regards
siti
On Tue, Oct 12, 2010 at 7:13 AM, MikeMikeMike michael.lovel...@gmail.com
wrote:
I am having a problem with a forumla I am hoping
Use pivot table. don't use vba for easy work like this.
On Mon, Oct 11, 2010 at 5:43 PM, sreekanth m
sreekanthm.namb...@gmail.comwrote:
Hi All,
Can someone help me to resolve the attached issue, to paste the unique
records to Report sheet!
I want to have the answer like the
Dear siti Vi,
Brillient!
Could you please give me some VBA assignments, so that i can try myself and
can improve my VBA skill.
Thank you once again for your kind help, hope it will continue...!
Many Thanks,
Sreekanth M
Mobile:9916941744
On Tue, Oct 12, 2010 at 8:56 AM, siti Vi
20 matches
Mail list logo