$$Excel-Macros$$ Re: How to filter "," from data in cell.

Just use Find and Replace Find , and Replace nothing On 2/5/09, sunil kumar wrote: > > first select the relevant column that press ctlr+F, type ";"(comma) and > then press replace button > > On 2/5/09, Sachin N Harale wrote: >> >> Dear friends, >> >> Please help me out in filtering the "," (com

$$Excel-Macros$$ Macro for Extraction of contents of specified headings

hi all I am rookie to VBA.I need a macro which takes the Heading name as input and Exports the contents of the heading into a new word document.I am new to VBA but it is extremely important as i have to submit it by tomorrow me plzz help me.

$$Excel-Macros$$ Re: Counting duplicates once

Use Pivot as an option put the fields in row and you will have non duplicate values. On 15 Feb 2009 05:42:14 -, PUNEET NASA wrote: > > on e way to do it. > take data in another sheet. and sort the data in asc order and run a > formula > if (a1=a2,1,0) > remove 1 becasue one is Duplicate data

$$Excel-Macros$$ Re: Counting duplicates once

Use pivot table and put name in rows and field H in columns then count the number non blank cells for pc laptop and cad On 2/11/09, stuartjohnw...@googlemail.com wrote: > > > Hope you can help. In column B2:B265 I have a list of names, each > name appears about 4 time each. In column H2:H265 th

$$Excel-Macros$$ Re: excel date range

use pivot table to get the report as per your requirement On 2/13/09, Paul Schreiner wrote: > > > In the "total" column, try using a formula like: > Starting in row 2: > =IF(A3<>A2,SUMIF(A:A,A2,B:B),"") > > and copy it down. > > paul > > > - Original Message > > From: patrick > > To: MS

$$Excel-Macros$$ Re: Counting duplicates once

one way to do it. take data in another sheet. and sort the data in asc order and run a formula if (a1=a2,1,0) remove 1 becasue one is Duplicate data and Zero is sigle data which we req. On Sat, 14 Feb 2009 20:24:15 +0530 wrote >for this you can create Pivot chart...If you don't know how to crea

$$Excel-Macros$$ Re: VBA: Entering a Foldername in Collumn A should list me its Subfolders in B (comma seperated)

so: after having thought way too complicated, i realized there is a simple solution: - (the changes i made are in the last 8 lines...) it all works perfect now, thanx again for your help: - subfolder-macro -- ActiveSheet.Unprotect Password:="xxx" Di