I want through CountA($A:$A)-1 formula,
but there are other small query if possible pls try to solve then my work
is completely done all side.
Pls see attached file for detailed
Appreciate the help very much sir
Regards
Amar
On Fri, Feb 15, 2013 at 12:53 PM, RAJA SEKAR apkra...@gmail.com
Dear Amar,
In this file we have applied logic of Min as indicator to fix the range,
i.e., Min is located in F 57 in attached file and range is arrived 57 -2
(55th) row.
you can use *CountA($A:$A)-1* instead of *MATCH(MIN,ABB!$F:$F)-2*
On 15 February 2013 11:11, amar takale
Hi,
You have to use Excel 2003 to convert excel into dbf... Excel 2007 doesnt
having option to export excel into DBF
On 8 January 2013 10:52, jmothilal gjmothi...@gmail.com wrote:
dear any one
how to convert to excel 2007 to dbf files.
Thanks with
--
*J.Mothilal : **Universal
On 3 November 2012 15:44, Pravin Gunjal isk1...@gmail.com wrote:
*Thanks Kuldeep for your reply.*
*I want the cursor should go in the cell D1 when the ENTER key is
pressed.*
*
*
On Sat, Nov 3, 2012 at 3:35 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Pravin,
You want to press
edit a cell and press enter
On 3 November 2012 22:10, Rohan Young rohan.j...@gmail.com wrote:
hi raja,
its not working
regds
On Sat, Nov 3, 2012 at 10:03 PM, RAJA SEKAR apkra...@gmail.com wrote:
On 3 November 2012 15:44, Pravin Gunjal isk1...@gmail.com wrote:
*Thanks Kuldeep
=IF(EXACT(COUNTIF($A$1:A1,A1),1),A1,)
copy at b1 and drag it
On 30 October 2012 13:21, Priyanka Vaish vaishpriyanka2...@gmail.comwrote:
Dear All,
Thanks
but i want solution through formula.
On Tue, Oct 30, 2012 at 1:16 PM, SAGAR KASANGOTTUWAR
sagarkasangottu...@gmail.com wrote:
file with formula
On 30 October 2012 16:41, Sundarvelan N nsund...@gmail.com wrote:
Dear Gurus,
Please help me to Count the no of Red colored cells and green colored
cells.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
Hi,
if all values are in same column use convert text to column wizard..
On 17 September 2012 13:12, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Raobinson,
Please try..
*=--SUBSTITUTE(A2,CHAR(10),)*
--
With Regards,
Noorain Ansari
http://
Dear All,
Is it Possible to get OFX (Open Financial Exchange) data in to Excel.
--
Making a million friends is not a miracle, the miracle is to make a friend
who will stand by you when a million are against you.
Hi Sharad,
can u explain in brief??, Unable to get what exactly you want
On 10 August 2012 11:32, sharad jain jainshar...@gmail.com wrote:
Hi,
I need a formula or macro for calculating payback period which is dynamic.
I mean that it can calculate the payback period for series of data
Hi Shekhar,
you can use same formula by changing the column type to Text.
excel will treat (8911.11) as negative numeric value.
You just change the Column Type from General to Text and apply the same
formula..
Else
try this...
Try This
=RIGHT(A1,LEN(A1)-FIND((,A1,2)) B1 IF(LEN(C1)FIND(),C1,1),
LEFT(C1,FIND(),C1,1)-1),)
On 7 August 2012 16:48, Shekhar Sharma shekhar1...@gmail.com wrote:
Hi Friends
I am struggling with one problem and need your help.
I have three columns available like:
*Column A*
12 matches
Mail list logo