$$Excel-Macros$$ RE: [XL-VBA Clinic] URGENT OPENING WITH SERCO - MIS

2013-11-02 Thread santosh subudhi
Hi Dharmendra, Please find attached my updated resume -- Regards Santosh santoshkumar.subu...@gmail.com > Date: Wed, 30 Oct 2013 11:20:03 +0530 > Subject: [XL-VBA Clinic] URGENT OPENING WITH SERCO - MIS > From: dharmendra2...@gmail.com > To: excelvbacli...@googlegroups.com > CC: rajachauh...@r

$$Excel-Macros$$ Halp Neede in Sheet Protection Macro

2013-11-02 Thread Secret Shot
Dear Experts, I am working on a project and stuck at a very critical stage, I want help in a macro for sheet protection. where the condition is that I have to option in sells of column A using (data validation) options are "Pending" and "confirm", Now whenever i select "Confirm in any cell of col

Re: $$Excel-Macros$$ excel question

2013-11-02 Thread Robert Barnes
You are a GENIUS!!! On Fri, Nov 1, 2013 at 6:41 PM, Sam Mathai Chacko wrote: > Are you looking for this? > > =COUNTIF($D$2:$D$15,"S") > > Regards, > Sam Mathai Chacko > > > On Sat, Nov 2, 2013 at 4:16 AM, Robert Barnes wrote: > >> >> >> First of all thank you. I am, at best, a novice user of exc

$$Excel-Macros$$ Formula for calculate max number for unique values

2013-11-02 Thread Ali Abbas
Dear All, How can we develop a Formula for calculate max number in unique values like if we have 1000 total values and 10 values are unique in this data. I have needed a single formula which can calculate unique values max number (problem is all 1000 values in a single column and their number in ot