$$Excel-Macros$$ Count function needed

Hi Group, I have added "=2+2" in cell A1 and in cell A2 I want the result to be 2 since i have added two value. Similarly if i caulculate"=2+2-1" in Cell A1 the desired result is 3 in CellA2 Is there any forumla to count this. -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (

$$Excel-Macros$$ Exl at expert level

Hi Expert. I want to learn exl at expert level. Help me. Regards, Sandhya -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get q

$$Excel-Macros$$ Congratulations!

Dear Noorain, Congratulations! Happy journey everytime with success flag in u r hand., kind regards, munnu. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Proble

Re: $$Excel-Macros$$ Exl at expert level

Hi, *Check below Weblinks.* *MVP's* *Web Link* Alan Beban http://home.pacbell.net/beban Allen Wyatt http://excel.tips.net Andrew Engwirda http://www.andrewsexceltips.net/ Andy Pope http://www

Re: $$Excel-Macros$$ Count function needed

Hi Santosh, See the attached file where I have achieved this using formulas only. Thanks. Regards, DILIPandey On Sun, Mar 18, 2012 at 1:27 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Group, > > I have added "=2+2" in cell A1 and in cell A2 I want the result to be 2 > since

RE: $$Excel-Macros$$ Count function needed

See the attached In this sheet Data Is a name Range which return Formula for cells =SUM(--(NOT(ISNUMBER(INT(MID(data,ROW(INDIRECT("1:"&LEN(data))),1)) Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of santosh subudhi Sent: Mar/Sun/201

$$Excel-Macros$$ Need help with VBAfor Excel naming and using column names for looping

I am trying to understand how to name a column of data and be able to reference the data by that name. Ideally I could set the name programatically but if it needs to be done through the ribbon command that is acceptable. Ideally inserting a new column before the named column will not affect that

Re: $$Excel-Macros$$ Need help with VBAfor Excel naming and using column names for looping

the simplest is sub nameit cells(7,4).name="whateveryouwanttonameit" end sub =whaeveryounamedit Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: tangledweb Sent: Sunday, March 18, 2012 5:22 AM To: MS EXCEL AND VBA MACROS Subject: $$Exce

$$Excel-Macros$$ Rank Formula required

Dear Expert, I want any formula to find Rank in Excel but that rank should be Unique.. if the value are same for ranking its should check second pereority. attach is the file for understanding the problme. Kindly help pls. i have tried with rank formula but it dosent work. -- Pankaj Pandey Bhopa

Re: $$Excel-Macros$$ Rank Formula required

See attached =SUM(1*(F2<$F$2:$F$9))+1+IF(ROW(F2)-ROW($F$2)=0,0,SUM(1*(F2=OFFSET($F$2,0,0,INDEX(ROW(F2)-ROW($F$2)+1,1)-1,1 Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Secret Shot Sent: Sunday, March 18, 2012 4:02 PM To: excel-mac

Re: $$Excel-Macros$$ Rank Formula required

Shorter. Also enter using CSE (ctrl+shift+enter) =COUNTIF($F$2:$F$9,">"&F2)+SUM(IF(F2=$F$2:F2,1,0)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Secret Shot Sent: Sunday, March 18, 2012 4:02 PM To: excel-macros@googlegroups.com Subj

RE: $$Excel-Macros$$ Need help with VBAfor Excel naming and using column names for looping

You can name the entire column as well; range("C:C").name="mycolumn" ' create workbook-level name then reference it as: range("mycolumn") also works as/in a cell formula: { =mycolumn } =match("findthis",mycolumn,0) evaluate("mycolumn") ' formula eval from vba [mycolumn] ' formula eval fr

$$Excel-Macros$$ cells shifting up!

Dear Friends, I need to shift the cells up to bring them in one single line. TR1 1 2 3 TR1 1 2 3 this is my target... Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED f

Re: $$Excel-Macros$$ cells shifting up!

Dear Muneer, Please follow below step and see attached Sample sheet. Select A1:D4 Range Press ctrl+G->goto Special-Check Blank Press ctrl- and Shieft Cell Up -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogs