Re: $$Excel-Macros$$ Subtotal for visible/unhidden column

2014-07-08 Thread Vaibhav Joshi
pl share sheet with example.. Cheers!! On Wed, Jul 9, 2014 at 12:17 PM, Rajeev wrote: > Dear Group, > > > > We use subtotal for row now I like to following please help if it is > possible: - > > > > 1 In one worksheet i am using Column A1 to EL82 > > 2

$$Excel-Macros$$ Subtotal for visible/unhidden column

2014-07-08 Thread Rajeev
Dear Group, We use subtotal for row now I like to following please help if it is possible: - 1 In one worksheet i am using Column A1 to EL82 2 In each cell there is value 0 or I or R 3 I want a count value in column EM 4

$$Excel-Macros$$ Urgent required .Net developer - Redmond, WA

2014-07-08 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com Position: Software/ .Net DeveloperLocation: Redmond, WADuration: 3-6 months, with extension* Technical skills: C#, Entity Framework SQL Development, Audio File Processing and Format familiarity, XML serialization and methodology Thanks and Regards,

Re: $$Excel-Macros$$ Re: How to get most used number in the cell using formula

2014-07-08 Thread Vaibhav Joshi
check this.. i have added one more UDF MultiMode in second yellow cell to get multiple liked value... Cheers!! On Tue, Jul 8, 2014 at 10:33 PM, Vaibhav Joshi wrote: > Hi > > In that case you will get 1st lowest value! > > Are you looking for both values ? > > Cheers!! > > > On Tue, Jul 8, 201

Re: $$Excel-Macros$$ Re: How to get most used number in the cell using formula

2014-07-08 Thread Vaibhav Joshi
Hi In that case you will get 1st lowest value! Are you looking for both values ? Cheers!! On Tue, Jul 8, 2014 at 9:36 PM, Deb wrote: > Hi Vabz, > > Thanks for the quick reply and its wonderful. But i have noticed there is > an issue. Suppose I have 6 cells where first 3 numbers are 1 and las

Re: $$Excel-Macros$$ ****Unable to RUN Stored Procedue*****

2014-07-08 Thread yogananda muthaiah
Add UNION ALL. In between select statement. On Monday, July 7, 2014, sreekanth m wrote: > Hi All, > I am unable to execute a stored procedure, in Excel or Excel/VBA, which has got more than one "SELECT" statement in it. > If I execute a STORED PROCEDURE in Excel or Excel/VBA, it is giving me onl

$$Excel-Macros$$ Re: How to get most used number in the cell using formula

2014-07-08 Thread Deb
Hi Vabz, Thanks for the quick reply and its wonderful. But i have noticed there is an issue. Suppose I have 6 cells where first 3 numbers are 1 and last 3 numbers are 2. Then its taking as 1. So my question is suppose if there is 2 similar value which one will it choose? I have attached the sam

Re: $$Excel-Macros$$ Formula Required

2014-07-08 Thread Paul Schreiner
I'm sorry, but your explanation is confusing. Can you give an example?   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you c

$$Excel-Macros$$ Urgent required Software/ .Net Developer - Redmond, WA

2014-07-08 Thread Gary .
Please respond to *gurjant.si...@damcosoft.com * *Position: Software/ .Net DeveloperLocation: Redmond, WA (Locals only)Duration: 3-6 months, with extension* *Need Local candidatesInterview Process: 1 Internal Interview + 2 Client Interviews (telephonic and F2F)* Technical skills: C#, Entity F

$$Excel-Macros$$ Urgent required PL/SQL developer - San Jose, CA

2014-07-08 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com * *Position: PL/SQL developerLocation: San Jose, CA Duration: 6-12 Months possibility of extension* *Need Local CandidatesInterview Process: 1 Internal Interview + 2 Client Interviews (telephonic and F2F)* Technical skills: PLSQl developer with

Re: $$Excel-Macros$$ Disable Row and sheet name

2014-07-08 Thread Ashish Kumar
Hi Ashish, For Hide Sheet Names. Click on the File TAB. Click on the Option Button. Go to Advanced category and uncheck the show sheet tabs option for hide the sheet names. Click OK For Hide and show (Row & Columns) Select the rows and columns according to your requirement and choose Hide opt

$$Excel-Macros$$ Disable Row and sheet name

2014-07-08 Thread Ashish Bhalara
Dear expert, Kindly know me how to hide sheet name which displayed with scroll bar and also know me how to disable and to show of row/column number only particular which is not use. The demo sheet is attached herewith. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it

Re: $$Excel-Macros$$ How to get most used number in the cell using formula

2014-07-08 Thread Vaibhav Joshi
hi check this attachment, i have written UDF name cMode. The same way you use mode command you need to use cMode. Syntex is =cMode(Range of cells) Cheers!! On Tue, Jul 8, 2014 at 9:43 AM, Deb wrote: > Hello All, > > I need a quick help. I have a work to select most rated pics using excel.