$$Excel-Macros$$ Re: Best Way to Mimic Relational Data?

r this. See the attached solution. > > Regards > Sandeep > > > > On Wed, Oct 7, 2009 at 2:34 AM, HumanJHawkins wrote: > > > I have a list of 15000 rows of response data about questions that > > showed up on a series of tests. There is often more than one row for > > ea

$$Excel-Macros$$ Best Way to Mimic Relational Data?

I have a list of 15000 rows of response data about questions that showed up on a series of tests. There is often more than one row for each test question, because each question was used in more than one event. So the data may be like: 1 A 3.33 1 B 2.99 2 A 1.11 2 C 1.13 etc. Unfo

$$Excel-Macros$$ Re: How to Show Count of Zero in Pivot Table

ote: > Have a look at the attaché file. > I added 3 columns to the data (see formulas in the columns) > HTH > Daniel > > > > > > > -Original Message- > > From: excel-macros@googlegroups.com [mailto:excel- > > mac...@googlegroups.com] On Behalf

$$Excel-Macros$$ How to Show Count of Zero in Pivot Table

I have a table that has this structure: ThingID ThingGrouping ThingStatus 1 A Done 2 A Started 3 B Started 4 B NotStarted It is easy to make a pivot Table that shows a count of things in groups at a statu

$$Excel-Macros$$ Re: How to Make Excel Recalculate When Cell is Tied to VBA Macro

On Aug 9, 1:57 pm, Chris Spicer wrote: > Hi Jeffrey, > >  Are you saying that you've written a custom function in VBA and when > you use the function in the spreadsheet it references the drop down > list?  If this is the case your function should update when you change > the drop-down list. > > I

$$Excel-Macros$$ Find a Value From Other Worksheet Without Activating?

Hi, The following code snippit works fine: Dim iMyValue As Integer Worksheets("Config").Activate iMyValue = Cells(Cells.Find(What:="FindMe", After:=Cells(1, 1), LookIn:=xlFormulas, LookAt:=xlPart, _ SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= False, SearchF