18, 2013 at 2:46 AM, Excel_Lover idforex...@gmail.com
mailto:idforex...@gmail.com wrote:
ha ha!!!
On Thu, Jan 17, 2013 at 2:22 PM, Ms-Exl-Learner
ms.exl.lear...@gmail.com mailto:ms.exl.lear...@gmail.com wrote:
@ Noorain Ansari,
Could you please
*
In D5 cell
=IF(LEN(TRIM(C5)),LEN(C5)-LEN(SUBSTITUTE(C5,,,))+1,)
Drag it down...*
On 17-01-2013 3:40 PM, amar takale wrote:
Dear champs
Pl suggest simple count formula in cell
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
@ Noorain Ansari,
Could you please explain what is the use of /*Sumproduct*/ in your below
formula?
/*=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,,,))+1)*/
Why not it should be /*LEN(C5)-LEN(SUBSTITUTE(C5,,,))+1*/? Since
both will result the same answer.
*My Suggestion Posted HALF AN HOUR
@ Prince,
Do you think is it a quality answer? and Dont you think you are
re-directing the OP in wrong approach?
=SUM(($D$2:D5=D2)**1**(G2:M2))*with CSE*in Cell O2
Could you please explain what is the need of **1* *and what is the need
ofCSE here* *why not then one (Non Array Approach)
*In F1 cell *- _*Non Array formula *_
*=LOOKUP(2,1/(A1:A8=D1),ROW(A1:A8))*
OR
*=SUMPRODUCT((MAX((A1:A8=D1)*ROW(A1:A8*
On 10-01-2013 4:41 PM, Hilary Lomotey wrote:
Hi Experts,
In the attached, i have a list of items, some are repetitive in the
list, if i want to find the relative
Not possible without the help of Excel VBA or Third Party Addins.
On 10-01-2013 10:57 AM, Hari wrote:
Thanks for your help. but is there any formulae to get the same answers.
Thanks,
Harish
On 10 January 2013 10:11, The Viper viper@gmail.com
mailto:viper@gmail.com wrote:
*In C4 cell* - *Non Array Formula*
=SUMPRODUCT(MAX(($A$4:$A$9567=A4)*$B$4:$B$9567))
Drag it down.
On 09-01-2013 3:35 PM, karan kanuga wrote:
Hi
Can anyone pls let me know how do i get the max value or date (using a
formula and not pivot) from the database that i have.
Attached is the
@ Noorain,
But Change in Worksheet Name or addition of sheets are not automatically
getting added in your solution, for which the user needs to press F2 in
the formula cell or close the workbook and re-open it for getting it
reflected.
Slight enhancement has been done
Your A2 cell formula
Please make it in an excel workbook and send it to us for our better
understanding of your data structure.
On 10-01-2013 1:01 PM, kumar.ashish861 wrote:
Dear Seniors,
Pls help to seperate date time, if both are in 1 cell.
7/11/2012 13:51
Formula req..!
Thanks in advance
Ashish
In A2 cell
*=INDIRECT('$D$1'!ADDRESS(ROW(),COLUMN()+1))*
Drag it down and right...
On 10-01-2013 1:14 PM, Rajesh Agarwal wrote:
Dear Sir
If I change the sheet name in column D1 all the rows of column A B
change accordingly
need formula not macro
--
*Rajesh Kumar Agarwal*
*9811063001*
--
_*Compatible, Faster Shorter Length formula
*_*=SUMPRODUCT((A2:A11=F2)*(A2:A11= G2),(-B2:B11)+(C2:C11))*
On 07-01-2013 9:00 PM, Yahya Muhammad wrote:
Thanks Ashish. Is there any way we can combine two SUMPRODUCTS/SUMIFS
into one, to reduce the length of formula ?
On Mon, Jan 7, 2013 at
I don't know why you guy's are getting surprised for this one =-O .
Because any of you can create lot more like this by just inserting any
of your flash files in excel.
*Whatever the magic is happening is just a shadow of the flash files and
excel is just a window which holds it :-P *
Same
***of functions.
Whenever I see any formula with error I just point out, so that you will
be aware of the drawbacks which will help you when building formula's in
future.
On 26-12-2012 1:38 PM, Prince wrote:
Hi Ms-Exl-Learner,
Yes dear, you are right. There are so many ways to do the same
@Prince,
Thanks for the understanding :)
On 26-12-2012 2:27 PM, Prince wrote:
Yes Dear Ms-Exl-Learner,
I also belive in correcting the things so that anything we do should
be perfect and smooth. It is best form me that guys like you are
always there who can ping me whenever i do any thing
*In C16**cell*
=IF(ISNUMBER(B16),TEXT(B16,),)
*Drag it down.*
*In D2 cell*
=SUMIF($C$16:$C$380,$B2,(D$16:D$380))
*Drag it to right...*
On 26-12-2012 11:24 AM, Rajesh thrissur wrote:
Hi Experts,
In the attachment file the sumif formula is not working I don't know
why.kindly point the
@Lalit,
Why not a *Non Array Formula* suggestion?
In D2 cell
=SUMPRODUCT((TEXT($B$16:$B$380,)=$B2)*(D$16:D$380))
Drag it right
Do you think your solution will work in all systems? The answer is *NO*.
It *FAIL* in many systems because of different date formatting in
*Regional DateTime
@ Lalit Mohan,
You're Welcome and *accept my thanks to you* for *not taking anything in
negative* :)
Anyone can point out my solutions too... if my suggestion goes wrong :)
On 26-12-2012 12:29 PM, Lalit Mohan Pandey wrote:
Thanks Ms-Exl-Learner for the suggestion.
Regards,
Lalit Mohan
@Prince,
Why not just added another m in your text function
*TEXT(C16:C35,mmm)*which will avoid unnecessary MID Function. One
more thing I don't think
you need any case sensitivity function here (Proper in your formula).
(TEXT(C16:C35,mmm)=MID(PROPER(B2),1,3))*1)
TEXT(C16:C35,mmm) = This one
*In K7*
=LOOKUP(10^10,E7:H7,E7:H7)
*Non *Array Solution.
On 14-12-2012 5:50 PM, amar takale wrote:
Dear Experts
Pls can anybody help me on this matter.
As always, Thank you very much for all the help
Regards
Amar
On Thu, Dec 13, 2012 at 1:00 PM, amar takale amartak...@gmail.com
, Dec 17, 2012 at 4:37 PM, Ms-Exl-Learner
ms.exl.lear...@gmail.comwrote:
=LOOKUP(10^10,E7:H7,E7:H7)
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need
miss=one number which same
If single number=show single number
that it simple. I used Ms-Exl-Learner that perfect but if all cell
same but last cell different number then show that numbers,I want that
time show error then i will know something is problem.If there are no
numbers in cell then cell
In addition to the below post, you cannot use Sumproduct to get the Text
Data as result.
*Ms-Exl-Learner*
On 10-10-2012 11:13 PM, Kuldeep Singh wrote:
Hi Srinivas,
Please use this.
=SUMPRODUCT((A:A=G3)*(B:B=H3)*(C:C=I3)*(D:D=J3)*(E:E))
Regards,
Kuldeep Singh
On Wed, Oct 10, 2012
Hi Vijayendra
Copy and paste the below formula in AJ6 cell
=IF(COUNT($G6:$R6),LOOKUP(10^10,$G6:$R6,$G$5:$R$5),)
Drag the AJ6 formula to the remaining cells of AJ Column.
Refer the attachment file for details.
Hope that helps!
Let us know, in case of any further assistance.
*Ms-Exl-Learner
Hi Shrinivas,
A sample workbook with the parameters and the expected output will be
helpful for giving exact solution.
*Ms-Exl-Learner*
On 06-10-2012 9:01 AM, Shrinivas Shevde wrote:
Dear Excel Learner
First of all sorry for delay.
Thanks for the reply and this is exactly I want.
Can u
Hi Manoj,
Go through the below for Non Array Formula Solution.
*Try this for getting the Maximum Date based on Name*
=SUMPRODUCT(MAX($A$2:$A$47*($C$2:$C$47=$E2)))
*Try this for getting the ID based on Maximum Date of a name*
Or in one shot...
=IF(SUMPRODUCT(--((F11:L11)($F$10:$L$10))),Failed,Passed)
Refer the attached sheet for detail.
.
*Ms.Exl.Learner*
--
*Ms.Exl.Learner*
On Wed, Sep 5, 2012 at 1:24 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Amar,
Please Use it...
Or
=IF(ISERR(FIND(),D3)),,TRIM(MID(D3,FIND(),D3)+1,255)))
*Ms.Exl.Learner*
---
On Tue, Sep 4, 2012 at 2:01 PM, amar takale amartak...@gmail.com wrote:
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for
Better you should have created it in Ms-Access.
*Ms.Exl.Learner*
On Fri, Aug 24, 2012 at 5:45 PM, jocky Beta jocky6...@gmail.com wrote:
Hi,
Please find the attached excel sheet in which their is a report Tab
which generates following report automatically
1)Current Stock
2)Current
of =--(ROW()O2) in the formula?
thanks
On Fri, Aug 24, 2012 at 4:47 AM, Ms-Exl-Learner .
ms.exl.lear...@gmail.com wrote:
Refer the attached excel for modified solution.
Let us know in case of any further assistance.
---
Ms.Exl.Learner
---
On Thu
Try This...
=SUMPRODUCT(('Jan12'!F4:F60={Corrective,Implementation,Training,Information})*('Jan12'!H4:H60=DATA)*('Jan12'!G4:G60=Completed))
Let us know in case of any further assistance.
---
Ms.Exl.Learner
---
On Fri, Aug 17, 2012 at 10:13 PM, Santosh
Type or copy and paste the below formula in A4 cell.
A4 cell
=A$3/5
Drag the A4 cell formula upto A8 cell and drag it to the right if required.
---
Ms.Exl.Learner
---
On Wed, Aug 22, 2012 at 3:41 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
i need
For Macro Solution Try the below code
Option Explicit
Sub SplitNumber()
Dim i As Long, j As Long, EndCol As Long
EndCol = Range(A2).CurrentRegion.Rows(1).Cells.Count
For i = 1 To EndCol
For j = 1 To Cells(2, i).Value
Cells(3 + j, i).Value = Cells(3, i).Value / Cells(2, i).Value
You're Welcome
---
Ms.Exl.Learner
---
On Wed, Aug 22, 2012 at 4:26 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Many many Thanks for solution...
On Wed, Aug 22, 2012 at 4:23 PM, Ms-Exl-Learner .
ms.exl.lear...@gmail.com wrote:
For Macro
Hi Pravesh,
Copy and paste the below formula in C15 cell
=VLOOKUP($D$2,INDIRECT('$D$3'!$A$1:$E$7),MATCH(C$14,INDIRECT('$D$3'!$A$1:$E$1),0),0)
Drag the C15 cell formula to Right upto F15 cell.
Hope that helps!
---
Ms.Exl.Learner
---
On Sat, Aug 18, 2012
Another Approach
Copy and paste the below formula in 2nd Row of any cell other than A2 cell
and drag it below.
=IF((LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2), ,)))1,
TRIM(MID(TRIM(A2),
FIND( ,TRIM(A2))+1,
(FIND(^,SUBSTITUTE(TRIM(A2),
,^,(LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2),
Alt+D+F+F
---
Ms.Exl.Learner
---
On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA vijayajith...@gmail.comwrote:
Hello sir
Can you tell me what is shortcut key for data clear(filter)?
Thanks
--
FORUM RULES (934+ members already BANNED for
.
On Sun, Dec 18, 2011 at 12:10 PM, Ms-Exl-Learner .
ms.exl.lear...@gmail.com wrote:
Alt+D+F+F
---
Ms.Exl.Learner
---
On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA
vijayajith...@gmail.comwrote:
Hello sir
Can you tell me what is shortcut key
Hi,
Just convert it to real time and apply time format as well.
=--(LEFT(A1,2):RIGHT(A1,2))
---
Ms.Exl.Learner
---
On Tue, Nov 22, 2011 at 5:30 PM, jmothilal gjmothi...@gmail.com wrote:
use this
=LEFT(A1,2):RIGHT(A1,2)
Mothilal.J
On Tue, Nov
Hi,
Assume that your input data is A2 cell and apply the below formula in B2
cell.
=A2-MOD(A2,5)
Refer the attachment for details.
---
Ms.Exl.Learner
---
On Wed, Nov 9, 2011 at 2:11 PM, SAJID MEMON sajidwi...@hotmail.com wrote:
Dear Experts,
I
Hi Sajid,
Refer the reply given to another post for the same subject.
---
Ms.Exl.Learner
---
On Wed, Nov 9, 2011 at 2:10 PM, Advocate kbj msma@gmail.com wrote:
Dear Experts,
I want rounding method in excel 2003
when i typed 124.90 the rounding
Hi Mothilal,
Yours is the exact and simplified solution.
In fact, I forgot that function and I was unable to recollect it while
replying to the OP's question. But, your reply helped me to recall it.
Thanks Dude...
---
Ms.Exl.Learner
---
On Wed, Nov 9,
Hi Sara,
Refer the below thread for feasibility.
http://www.excelforum.com/excel-worksheet-functions/639013-number-of-the-week-in-month.html
---
Ms.Exl.Learner
---
On Mon, Oct 31, 2011 at 6:49 AM, Sara Lee lee.sar...@gmail.com wrote:
hi
i have a
Hi Anil,
I Assume that your data is in Column A and your first row is having the
column header.
So your data will start from 2nd row of Column A (i.e. from A2 cell)
A1 Data
A2 /ENTRY-10 OCT TRF/REF 6004ABS6834230 /ORD/ Q-FAST TELECOM BV
STRIJKVIERTEL 26 A 3454 PMDE MEERN /BNF/ INVOICENO
of it, since the Legendary Excel
MVP Don Guillett also getting joined in this group.
---
Ms.Exl.Learner
--
On Wed, Oct 12, 2011 at 4:13 PM, Anil Bhange
anil.bha...@tatacommunications.com wrote:
Amazing… Ms-Exl-learner…
** **
This is exactly what
Hi B.N Chetan kumar,
Try this...
=--SUBSTITUTE(A3, ,-)
Or
=IF(ISERR(--SUBSTITUTE(A3, ,-)),,--SUBSTITUTE(A3, ,-))
Hope that helps!
---
Ms.Exl.Learner
---
On Thu, Oct 6, 2011 at 10:20 AM, B.N.Chethan kumar
chetankumar1...@gmail.com wrote:
Hi All,
I
Hi,
Something like this..
=IF(ISNUMBER(SEARCH(FL,IR3)),IR3,IF(ISNUMBER(SEARCH(FL,IS3)),IS3,IF(ISNUMBER(SEARCH(FL,IT3)),IT3,IF(ISNUMBER(SEARCH(FL,IU3)),IU3,
The above formula check from Cell IR3 to IU3, if any match is found from the
starting cell then it stops the the remaining conditions
Hi Deepak,
Copy and paste the below formula in Second Row after Column H.
=IF(B2100,B$1,IF(SUM(B2:C2)100,C$1,IF(SUM(B2:D2)100,D$1,IF(SUM(B2:E2)100,E$1,IF(SUM(B2:F2)100,F$1,IF(SUM(B2:G2)100,G$1,IF(SUM(B2:H2)100,H$1,Not
Qualified)))
I have attached an example file for your better
Hi Ankit,
Go through the below links to have a better understanding about Validation
in Excel.
http://www.contextures.com/xlDataVal06.html
http://www.contextures.com/xlDataVal04.html
http://www.contextures.com/xlDataVal07.html
Hope that helps!
---
Ms.Exl.Learner
Hi Mich Mac,
It's better if you provide some sample data in excel file, so that we can
suggest you the exact formula to your expectation.
---
Ms.Exl.Learner
---
On Fri, Sep 16, 2011 at 1:39 AM, Mich Mac michelle.maccrac...@nmss.orgwrote:
I am exporting
Hi Kalyan,
Try the below formula.
=SUMPRODUCT((TRIM(A2:A37)=TRIM(F11))*(TRIM(B2:B37)=TRIM(G7))*(LEFT(TRIM(C2:C37),3)=LEFT(TRIM(G8),3))*(--MID(TRIM(C2:C37),FIND(
,TRIM(C2:C37))+1,255)=--MID(TRIM(G8),FIND(
,TRIM(G8))+1,255))*(--MID(TRIM(C2:C37),FIND(
,TRIM(C2:C37))+1,255)=--MID(TRIM(G9),FIND(
Hi ArtySin,
Refer the attachment file for details.
Hope That Helps!
---
Ms.Exl.Learner
---
On Thu, Sep 15, 2011 at 9:39 PM, ArtySin kenstrain...@gmail.com wrote:
Hi
I have two columns as below using Excel 2000 (unfortunately, corporate
no spend
Shrinivas
On Sat, Sep 3, 2011 at 6:07 AM, Ms-Exl-Learner . ms.exl.lear...@gmail.com
wrote:
I am tired...
---
Ms.Exl.Learner
---
On Fri, Sep 2, 2011 at 11:48 PM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:
Dear MS.EXL.Learner,
Please see attached
Hi Noorain Ansari,
It might be better if you might have constructed your example data with some
duplicates, since the questioner can able to understand the difference
between the *[vlookup, Index-Match, Offset-Match]* and *[Sumproduct, Sumifs,
Dsum]*.
The *First set of formula's / Functions*
Hi Noorain Ansari,
But the text function will result text value instead of real value. It's
better to format the cell as per your desired format by using custom format.
---
Ms.Exl.Learner
---
On Fri, Sep 2, 2011 at 5:11 PM, NOORAIN ANSARI
...@gmail.comwrote:
Dear Ms-Exl-Learner,
Thanks for your valuable suggestion..
Case -I, In case of duplicay all formulas are successfull working except
vlookup(vlookup) example.
You can see fresh attachement..
Case -II, You can't compare Sumproduct with If function both are
different
,*
*Noorain Ansari*
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Fri, Sep 2, 2011 at 11:11 PM, Ms-Exl-Learner .
ms.exl.lear...@gmail.com wrote:
Hi Noorain Ansari,
Case-1
I have attached the same file for your reference and I have not changed
anything on it just
Try this…
=IF(ISNUMBER(FIND( ,TRIM(B2))),LEFT(TRIM(B2),FIND(
,TRIM(B2))),IF(LEN(TRIM(B2))0,B2,))
---
Ms.Exl.Learner
---
On Thu, Mar 24, 2011 at 4:20 AM, Jorge Marques leote.w...@gmail.com wrote:
Hi guys, is there any way i can do to for example if a
Hi Maulik,
I am sure you will get it resolved if you explain your expectation with some
more brief about the way of pulling the data with cell reference and how it
can be derived.
Because you know very well about your data and the way your expected result.
But for us the data is a new one and
is 0 /Blank. And if i change the
value and look the value y i want to hide both row 13 and 14.
pls suggest the code OR upload the example file for reference.
Thanks !!
-
Manish
On Feb 1, 11:23 pm, Ms-Exl-Learner . ms.exl.lear...@gmail.com
wrote:
Hi
all are just Wow !!! !!
Regds,
Manish
On Feb 6, 2:01 pm, Ms-Exl-Learner . ms.exl.lear...@gmail.com
wrote:
Hi Bhushan,
Sumproduct can be used when the result is Numeric Value.
Have a look in the attached excel for retrieving the text output.
---
Ms.Exl.Learner
Hi,
Have a look in the attached file.
HTH :)
---
Ms.Exl.Learner
---
On Tue, Feb 1, 2011 at 12:22 AM, jmccaski jmccask...@gmail.com wrote:
I have an arry of over 21,000 rows with data in this format:
VarName TimeString VarValue
Pos
Hi Bhushan,
Have a look in the attached files.
I never suggest array formula when the same can be done in normal way.
HTH :)
---
Ms.Exl.Learner
---
On Tue, Feb 1, 2011 at 6:22 PM, Bhushan bsabban...@gmail.com wrote:
Dear Ayush,
Pls assist me for the
Hi Thamu,
I don't know what is the need for the comparison of 2003 2007 excel column
versions since the query is not very much related to the 2003 column issue.
I agree that the column will be the issue in Excel 2003 when the repetition
of UNIQUE IDNO goes beyond 127 times then we could not
Hi John,
It will work in version 2003 if you refer the cell reference to part of the
column range instead of referring it to the whole column.
=LOOKUP(2,FIND(A1,Sheet2!A1:A65535),Sheet2!B1:B65535)
See the attached file for detail.
---
Ms.Exl.Learner
---
Hi All,
I suggest all of you don't say this function I like and then this one like
that. Just sharing the function name won't help others to gain some
knowledge. All the functions which is available in excel is having the same
set of qualities unless it is used in perfect combination.
So give
I hope you need to go through each and every post before using / declaring
the below words to the group!
---
Ms.Exl.Learner
---
On Sat, Jan 8, 2011 at 3:28 PM, Ayush Jain jainayus...@gmail.com wrote:
Ayush Jain has sent you a link to a blog:
Dear
Hi All,
Have a look in the attached excel and you can find the solution.
The formula is given below for your reference. Adapt the Cell Range A3:A8
to your desired Range.
=IF(COUNTIF(A3:A8,LARGE(A3:A8,1))=COUNTIF(A3:A8,MODE(A3:A8)),LARGE(A3:A8,1),MODE(A3:A8))
*Suggestions For All*
*
*
1)
Yes it's very clear now. Try any one of the below formula which will do the
trick.
=IF(ISNUMBER(A3),IF(A31000,2.5,IF(A3=500,3,IF(A3500,3.5,))),)
OR
=IF(ISNUMBER(A3),IF(A3500,3.5,IF(AND(A3=500,A3=1000),3,IF(A31000,2.5,))),)
At the same time herewith I have attached a sample file for your
Hi,
In addition to the above post I would like to remove the helper column and
we make the formula to do the work.
Have a look in the attached file.
---
Ms.Exl.Learner
---
On Sun, Dec 26, 2010 at 6:29 PM, ashish koul koul.ash...@gmail.com wrote:
check
Hi Chandra Shekar,
Have a look in the attached file.
Hope it's clear to you and this is what you are looking for.
---
Ms.Exl.Learner
---
On Fri, Dec 24, 2010 at 8:09 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello Team,
How to get
for this.
---
Ms.Exl.Learner
---
-- Forwarded message --
From: Ms-Exl-Learner . ms.exl.lear...@gmail.com
Date: Sat, Dec 25, 2010 at 8:39 AM
Subject: Re: $$Excel-Macros$$ Help on Advance Formula
To: excel-macros@googlegroups.com
Hi Chandra
In addition to the below the cursor (Activecell) should be in B2 cell.
---
Ms.Exl.Learner
---
On 12/23/10, siti Vi villager.g...@gmail.com wrote:
select the range of your Numbers
for example: B2:B200
you can apply a conditional formatting on that range
Excel 2003:-
You can see only 1000 records in the Autofilter Dropdown. Not more than
that.
Excel 2007/2010:-
You can see 1 records in the Autofilter Dropdown. Not more than that.
So try to use some helper column based on your data criteria use some
formula in helper column like Istext,
-Exl-Learner . ms.exl.lear...@gmail.com wrote:
Copy and paste the below formula:-
=SUMIF($R$8:$R$96,$A12,($X$8:$X$96))
Drag the formula cell below to the remaining cells and the criteria cell
will be getting changed and the Range and Sum Range will remains same.
But past the above
Hi Vebhav,
Have a look in the attached file. Hope it helps!
---
Ms.Exl.Learner
---
On Thu, Dec 16, 2010 at 11:06 PM, vebhav jain vebhav.j...@gmail.com wrote:
Hi All,
Please help me in finding the missing entries from the below data.
ListA
Copy and paste the below formula:-
=SUMIF($R$8:$R$96,$A12,($X$8:$X$96))
Drag the formula cell below to the remaining cells and the criteria cell
will be getting changed and the Range and Sum Range will remains same.
But past the above formula other than R8:R96, X8:X96 range and A12 cell.
You can use substitute in front of the UDF to replace the word to your
desired local currency right.
Another Method:-
Follow the below link and download the MoreFuction Addin from that and run
the setup.
http://download.cnet.com/Morefunc/3000-2077_4-10423159.html
After doing that open excel
Hi Sreedhar,
Check whether the buttons are working properly (Cntrl Tilde buttons)
---
Ms.Exl.Learner
---
On Fri, Dec 3, 2010 at 10:28 PM, Shreedar Pandurangaiah
shreedar.panduranga...@gmail.com wrote:
Any help on this would really great.
Thank You,
Check whether your cntrl button is working.
Ms-Exl-Learner
On Mon, Nov 22, 2010 at 10:52 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Dear All,
When i am using scroll wheel of mouse my excel sheet gets Zoom In (Moving
Forward) Zoom out
79 matches
Mail list logo