Re: $$Excel-Macros$$ minimum numeric positive value

Hi sundar here is the solution for all without array Min (-)tive value =MIN(A1:A10) Min (+)itive value =SMALL(A1:A10,(COUNT(A1:A10)-COUNTIF(A1:A10,">=0")+1)) Max (-)tive value =LARGE(A1:A10,(COUNT(A1:A10)-COUNTIF(A1:A10,"<0")+1)) Max (+)itive value =MAX(A1:A9) -- *Great

$$Excel-Macros$$ Excel Test

Dear All, Please find attached Excel Test. -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* -- -- Some important links for excel users: 1. Follow us on

Re: $$Excel-Macros$$ Extracting data from Website

can you send me link and text you want to extract On Thu, Jul 28, 2011 at 11:54 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi Ashish, > > Any solution for this. Thanks in advance. > > -- Forwarded message -- > From: Chandra Shekar > Date: Fri, Jul 22, 2011 at 1:2

Re: $$Excel-Macros$$ need formula for find specif value based on multiple crteria

Hi Mohan, If you want to get the data based on Multiple Criteria in 2007 You May Try Countifs,Sumifs,Averageifs *Best Regards,* *Venkat* * * * * On Thu, Jul 28, 2011 at 8:38 AM, Mohanraj shunmugam wrote: > dear team member, > > i need formula for multiple criteria to find specfic value > > i

Fwd: $$Excel-Macros$$ Extracting data from Website

Hi Ashish, Any solution for this. Thanks in advance. -- Forwarded message -- From: Chandra Shekar Date: Fri, Jul 22, 2011 at 1:21 PM Subject: Re: $$Excel-Macros$$ Extracting data from Website To: excel-macros@googlegroups.com Hi Asish, How to pull out particular lines or parag

Re: $$Excel-Macros$$ Lesson 1: The Visual Basic Editor in Excel (VBE)

Hi Harish, Welcome... On Thu, Jul 28, 2011 at 2:10 AM, hanumant shinde wrote: > awesome* *thanks* *Venkat > * > From:* Venkat CV > *To:* excel-macros@googlegroups.com > *Sent:* Tue, 26 July, 2011 12:16:54 PM > *Subject:* Re: $$Excel-Macros$$ Lesson 1: The Visual Basic Editor in Excel > (VBE) >

Re: $$Excel-Macros$$ need formula to summarize based on multiple crteria

Hi, Thanks a lot for quick reply. It works well. Regards Anwar On Thu, Jul 28, 2011 at 11:24 AM, §»VIPER«§ wrote: > Hi Anwer > > pfa. it may help > > -- > *Great day,* > *viper > * > > > On Thu, Jul 28, 2011 at 10:17 AM, Anwar Mohd wrote: > >> Hi Experts, >> >> I need a formula to summar

Re: $$Excel-Macros$$ multi find function

both file from Haseeb and Ashish working GRAET!!! thanks a lot to you both Pawel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Joi

Re: $$Excel-Macros$$ How to read a log file using excel VBA code

Dear Praneet, Try Ms Access(or)Sql Server.. -- *Best Regards,* *Venkat* *Chennai* * * On Wed, Jul 27, 2011 at 10:42 PM, XLS S wrote: > Dear Praneet, > > Use Ms Access,..is it possible to provide the data? > > please provide the raw data > > > > > On Wed, Jul 27, 2011 at 10:33 PM,

Re: $$Excel-Macros$$ How to read a log file using excel VBA code

Dear Praneet, Please convert your Excel File in Access and use below query SELECT Logfile.Salary from Logfile WHERE (Logfile.Name)=[Enter a Name]; *ORDER BY *Logfile* ASC* -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Wed

Re: $$Excel-Macros$$ need formula to summarize based on multiple crteria

Hi Anwer pfa. it may help -- *Great day,* *viper * On Thu, Jul 28, 2011 at 10:17 AM, Anwar Mohd wrote: > Hi Experts, > > I need a formula to summarize based on multiple crteria as per the attached > sheet. > > From the data sheet i need to summarize partner revenue based on the > winprob%

Re: $$Excel-Macros$$ minimum numeric positive value

Try it... {=SMALL(IF(F14:F23>0,F14:F23,""),1)} -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Wed, Jul 27, 2011 at 6:33 PM, sundar nayal wrote: > > Hi friends, > > i have a data, in which so many numeric value, some are p

$$Excel-Macros$$ need formula to summarize based on multiple crteria

Hi Experts, I need a formula to summarize based on multiple crteria as per the attached sheet. >From the data sheet i need to summarize partner revenue based on the winprob% Regards Anwar -- -- Some important link

Re: $$Excel-Macros$$ need formula for find specif value based on multiple crteria

=SUMIFS($C$2:$C$31,$A$2:$A$31,A35,$B$2:$B$31,B35) On Thu, Jul 28, 2011 at 8:38 AM, Mohanraj shunmugam wrote: > dear team member, > > i need formula for multiple criteria to find specfic value > > i here attach sample file > my question on sample file is > how to find fundvalue for date 15/07/20

Re: $$Excel-Macros$$ ABOUT EXCEL

okay thanks dear On Wed, Jul 27, 2011 at 6:03 PM, XLS S wrote: > Dear Akabr, > > Coming soon Daily Doze VBA Classes Just wait. > > Just Download PDF for learn VB > > http://www.4shared.com/file/rLCjKIEO/learn_vb_6.htm > http://www.4shared.com/document/q8JGPFa6/Build_Your_Own_ASPNET_2

$$Excel-Macros$$ need formula for find specif value based on multiple crteria

dear team member, i need formula for multiple criteria to find specfic value i here attach sample file my question on sample file is how to find fundvalue for date 15/07/2011 and fund id 20 need formula help me thanking you regards, mohanraj s -- --

Re: $$Excel-Macros$$ VBA Needed to summarize employee data from raw data

Thanks for responding. Attached is the sample dataset. On Wed, Jul 27, 2011 at 7:06 PM, ashish koul wrote: > can you attach the sample file > > On Thu, Jul 28, 2011 at 7:28 AM, Adam Hamilton > wrote: >> >> Hello, >> >> I have a large amount of data that I receive with timesheets each >> week.  

Re: $$Excel-Macros$$ VBA Needed to summarize employee data from raw data

can you attach the sample file On Thu, Jul 28, 2011 at 7:28 AM, Adam Hamilton wrote: > Hello, > > I have a large amount of data that I receive with timesheets each > week. I am currently using many, many vlookups and pivots to achieve > the results that I need. But I know there is a VBA, but I

$$Excel-Macros$$ VBA Needed to summarize employee data from raw data

Hello, I have a large amount of data that I receive with timesheets each week. I am currently using many, many vlookups and pivots to achieve the results that I need. But I know there is a VBA, but I can't figure out what it is. Please take a moment and look at the samlple file, and desired res

$$Excel-Macros$$ Formula or macro to find a word that is all capitlaized

Hi, Can anyone help me with some sort of formula or Macro that would identify any word (minmum 3 letters) that is all in caps. I would like whatever is found to be highlighted in yellow. Thanks. -- -- Some important

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

THANK YOU EVERYONE. I am in awe with the knowlege you guys have. WELL DONE ! On Jul 27, 2:25 am, "Rajan_Verma" wrote: > Try this.. > > Sub Reverse() > >  Dim fRng As Range > >  Dim Couter As Integer > >  Dim cell As Range > >     Set fRng = Application.InputBox("Please Choose A Range", , , , , ,

Re: $$Excel-Macros$$ use of indirect function

Thanks a lot Noorain This is FANTASTIC, SUPERB truly awesome. > >From: NOORAIN ANSARI >To: excel-macros@googlegroups.com >Sent: Mon, 25 July, 2011 11:14:20 PM >Subject: Re: $$Excel-Macros$$ use of indirect function > > >Dear Neil, > >Please see attached sheet with Indirect function example > >

Re: $$Excel-Macros$$ Lesson 1: The Visual Basic Editor in Excel (VBE)

awesomethanksVenkat From: Venkat CV To: excel-macros@googlegroups.com Sent: Tue, 26 July, 2011 12:16:54 PM Subject: Re: $$Excel-Macros$$ Lesson 1: The Visual Basic Editor in Excel (VBE) Hi Harsh, Try the Below link for All lessons and continuation of Below.. http://www.excel-vba.com/excel-v

Re: $$Excel-Macros$$ beginner question

thanx On Jul 26, 6:12 am, "Rajan_Verma" wrote: > Both are different Things . Range is Only range Object can hold  but array > can be define of any type > > A range is a set of contiguous cells within a spreadsheet, that is a number > of cells within a column or a row, or an a group of n rows and

Re: $$Excel-Macros$$ Result not geting using "SUMIFS", Please help

Hello Kalyan, If you just have two customers, you can hard coded as array & use 1 SUMIFS with SUM. Without checking MOC in B3 =SUM(SUMIFS('Raw data'!D:D,'Raw data'!A:A,$B5,'Raw data'!C:C,{"Distributor","Super stockist"})) With MOC in B3, =SUM(SUMIFS('Raw data'!D:D,'Raw data'!A:A,$B5,'Raw dat

Re: $$Excel-Macros$$ minimum numeric positive value

Hello Sundar, Also, a non array formula with just ENTER. =SMALL(A:A,COUNTIF(A:A,"<=0")+1) HTH Haseeb For tips visit; http://www.excelfox.com/forum -- -- Some important links for excel users: 1. Follow us on TWITTE

Re: $$Excel-Macros$$ minimum numeric positive value

Hi find attach Try : {=MIN(IF($A$2:$A$16>0,$A$2:$A$16))} Thanks Mahesh On Wed, Jul 27, 2011 at 6:33 PM, sundar nayal wrote: > > Hi friends, > > i have a data, in which so many numeric value, some are positive( like > 1,2,3,55,76,871 etc) and some are negative ( like -1,-5,-84,-7,-6 etc), > so

Re: $$Excel-Macros$$ How to read a log file using excel VBA code

Dear Praneet, Use Ms Access,..is it possible to provide the data? please provide the raw data On Wed, Jul 27, 2011 at 10:33 PM, Praneeth Akinapalli wrote: > Hi Experts, > > I have a .log file (TXT doc) with 80,000 rows. I only need 20 rows of > data based on a single column fro

$$Excel-Macros$$ How to read a log file using excel VBA code

Hi Experts, I have a .log file (TXT doc) with 80,000 rows. I only need 20 rows of data based on a single column from that log file. I am currently using 2003 excel. Can anyone please give me logic on how to read that particular data from log file. Actually I tried importing the log file and then

Re: $$Excel-Macros$$ Difference between Array formula and Normal Formula...

Hi check info on this http://www.youtube.com/watch?v=SYpHjReBbmA&feature=share Thanks Mahesh On Wed, Jul 27, 2011 at 3:53 PM, Venkat CV wrote: > Thanks to All... > > > > > On Wed, Jul 27, 2011 at 9:40 AM, Dilip Pandey wrote: > >> Hi Venkat, >> >> Check following links:- >> >> www.cpearson.com/

RE: $$Excel-Macros$$ Re: minimum numeric positive value

See the attached File From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Sent: Wednesday, July 27, 2011 6:50 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: minimum numeric positive value Hi Sunder, If you have the data in th

Re: $$Excel-Macros$$ Help for combo box

Please update... Subhash Yadav On Mon, Jul 25, 2011 at 7:00 PM, Subhash Yadav wrote: > Dear friends > > I require some help regarding Vlookup function conunction with Combo Box. > > I want vlookup in the combobox with respect to selected value in another > combo box. Also want to put value in

Re: $$Excel-Macros$$ use of indirect function

Oops there is no attachement at all any way thansk for help :) On Wed, Jul 27, 2011 at 7:11 PM, XLS S wrote: > Hey ICWAI, > > please find the attachment and try again with attachment > > > > > > On Wed, Jul 27, 2011 at 5:45 PM, ICWAI Help wrote: > >> Hi Noorin i have tireed my best but stilll no

Re: $$Excel-Macros$$ use of indirect function

Hey ICWAI, please find the attachment and try again with attachment On Wed, Jul 27, 2011 at 5:45 PM, ICWAI Help wrote: > Hi Noorin i have tireed my best but stilll not undeerstand the below point > could you please explain me > what is mean by this > > name range of below function is > getph

Re: $$Excel-Macros$$ Re: minimum numeric positive value

for Min minus value =MIN(IF($A$1:$A$10<0,A1:A10,"")) then press SHIFT+CTRL+ENTER for max positive value =MAX(IF($A$1:$A$10>0,A1:A10,"")) then press SHIFT+CTRL+ENTER On Wed, Jul 27, 2011 at 6:49 PM, Ayush wrote: > Hi Sunder, > > If you have the data in the range of G18 to G23 , then you can use

Re: $$Excel-Macros$$ minimum numeric positive value

Dear Sundar, Please try this =MAX(IF(A1:A5<>0,A1:A5,FALSE)) On Wed, Jul 27, 2011 at 6:33 PM, sundar nayal wrote: > > Hi friends, > > i have a data, in which so many numeric value, some are positive( like > 1,2,3,55,76,871 etc) and some are negative ( like -1,-5,-84,-7,-6 etc), > so how can i

$$Excel-Macros$$ Re: minimum numeric positive value

Hi Sunder, If you have the data in the range of G18 to G23 , then you can use below formula. {=MIN(IF(G18:G23>0,G18:G23,MAX(G18:G23)))} This is array formula, So you need to press SHIFT+CTRL+ENTER after writing it. I hope it helps. Feel free to let me know if any further help is required.

$$Excel-Macros$$ minimum numeric positive value

Hi friends, i have a data, in which so many numeric value, some are positive( like 1,2,3,55,76,871 etc) and some are negative ( like -1,-5,-84,-7,-6 etc), so how can i find minimum positive numeric value? example(1,2,3,4,6,-1,-7,-8,-2.) in this data, minimum numeric positive value is 1. please s

$$Excel-Macros$$ XML and VBA

Hi All Excel Experts, I want to create, read and update XML file using VBA. Can some one share an explain how to create a XML file and read or manipulate XML file. Thanks in advance. Shariq -- -- Some impo

Re: $$Excel-Macros$$ ABOUT EXCEL

Dear Akabr, Coming soon Daily Doze VBA Classes Just wait. Just Download PDF for learn VB http://www.4shared.com/file/rLCjKIEO/learn_vb_6.htm http://www.4shared.com/document/q8JGPFa6/Build_Your_Own_ASPNET_20__Web_.htm On Wed, Jul 27, 2011 at 1:36 PM, Muhammad Talal Akbar < sh.talal.ak

Re: $$Excel-Macros$$ use of indirect function

Hi Noorin i have tireed my best but stilll not undeerstand the below point could you please explain me what is mean by this name range of below function is getphoto--Formula-define name-then paste below formula and put name range =INDIRECT("Sheet4!B"&MATCH('Indirect Exa

Re: $$Excel-Macros$$ Interesting Question

Please share the sample file. Regards, DILIPandey On 7/27/11, XLS S wrote: > function > > On Wed, Jul 27, 2011 at 10:55 AM, Dilip Pandey wrote: > >> Ok... do you need solution in VBA or Function. >> Also it would be great if you can share a sample workbook. >> >> Regards, >> DILIPandey

Re: $$Excel-Macros$$ Re: Excel Formula Required - Sum data for every month for respective year.

Thanks Haseeb. I am using excel 2003 where will i get group function in pivot and how much criteria will it support? On 7/27/11, Haseeb Avarakkan wrote: > Hello Kaushik, > > You already created Pivot Table Group the date in to Month & Year. And drag > the Year in Column Area, Month in Row Area.

Re: $$Excel-Macros$$ Difference between Array formula and Normal Formula...

Thanks to All... On Wed, Jul 27, 2011 at 9:40 AM, Dilip Pandey wrote: > Hi Venkat, > > Check following links:- > > www.cpearson.com/excel/array.htm > www.ozgrid.com/Excel/arrays.htm > > Regards, > DILIPandey > > On 7/26/11, Venkat CV wrote: > > Dear All, > > > > any one Explain Difference bet

Re: $$Excel-Macros$$ Result not geting using "SUMIFS", Please help

Thanks a lot Ashish On Wed, Jul 27, 2011 at 1:14 PM, ashish koul wrote: > =SUMIFS('Raw data'!D:D,'Raw data'!A:A,Query!B5,'Raw > data'!C:C,"Distributor")+SUMIFS('Raw data'!D:D,'Raw data'!A:A,Query!B5,'Raw > data'!C:C,"Super Stockist") > > > On Wed, Jul 27, 2011 at 11:53 AM, Kal xcel wrote: > >>

Re: $$Excel-Macros$$ ABOUT EXCEL

Thanks 4 ur quick response. But dear i want to learn VB from 1st step do u guide me or have data ? once again i m very thank ful to u On Wed, Jul 27, 2011 at 12:49 PM, XLS S wrote: > Hey, > > please find the PPT for learn excel step by step..if ant query > please feel free to reply...

Re: $$Excel-Macros$$ ABOUT EXCEL

hi every one i want to learn VB with excel can anybody guide me or help me On Wed, Jul 27, 2011 at 12:20 PM, Balwinder singh wrote: > Hello Sir/Madam, > > Please Learn me about EXCEL. > > > > > Balwinder Singh > > -- > > ---

Re: $$Excel-Macros$$ Result not geting using "SUMIFS", Please help

=SUMIFS('Raw data'!D:D,'Raw data'!A:A,Query!B5,'Raw data'!C:C,"Distributor")+SUMIFS('Raw data'!D:D,'Raw data'!A:A,Query!B5,'Raw data'!C:C,"Super Stockist") On Wed, Jul 27, 2011 at 11:53 AM, Kal xcel wrote: > Dear Experts, > > I have three types of customer group Distributor, Super stokist & Kol

$$Excel-Macros$$ ABOUT EXCEL

Hello Sir/Madam, Please Learn me about EXCEL. Balwinder Singh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

Re: $$Excel-Macros$$ EXCEL 2010 VBA File: Read-Only Workbook created using EXCEL 2003

what is the benefit ? On Wed, Jul 27, 2011 at 12:28 PM, Rajan_Verma wrote: > *See the Codes of Attached Workbook to Communicate with Access2007 , you > can share this type of Workbook,* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *XL