Functions

Can a formula be "built" referencing text content from another cel
Hi, and thank you for your help. I have run across this need many times...is there any way to use to contents of one cell, to construct a formula in another cell? Here is my particular requirement. I have worksheets named January, February, March...etc. On a separate Summary Worksheet, I reference the same c... 9 Mar 2010 18:07

Normalize/concatenate
Hello, I have a data set that looks like this: Sortterm Doc # Main Term CAS # CFR REG # DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 175.105 DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 175.300 DIPHTHALATE 7065 DI(2-ETHYLHEXYL) PHTHALATE 000117817 175.380 DI... 11 Mar 2010 01:19

Earliest time in a range
Hi, I have a range of dates and times, and the following will give me the latest time: {MAX((Data!$D$2:$D$5000=B13)*(Data!$F$2:$F$5000))} However, I now want the earliest time, but "MIN" does not work: {MIN((Data!$D$2:$D$5000=B13)*(Data!$F$2:$F$5000))} What is the proper formula? Thanks. ... 9 Mar 2010 15:50

Pivot Table Defaults
In the pivot table field list, whenever I create a new pivot table and I am inserting fields into the value area, I generally get as default field setting the 'Count' value. Is there a way to format the spreadsheet to make Excel recognize the data as all numbers so it defaults to the "Sum" function as opposed t... 10 Mar 2010 04:13

"clear contents" is not working. a list is still enforced.
suggestions would be much appreciated. ... 9 Mar 2010 18:07

Can Sheet name be part of formula for a cell (+ sheet name)
Worsheet name will change from template. Would like worksheet name to auto print in cell on separate worksheet. Can this be done? ... 9 Mar 2010 13:32

Lookup changing data range in external workbook
I am using Excel 2007. I need to match an alpha numeric value from one workbook with the same alpha numeric in a different workbook and have the formula return the data in the cell adjacent (right side) to the matched cell. The data in the second workbook will be in a different row each time I run it, but the... 10 Mar 2010 04:13

How do I change the fill color of a cell using an "IF" functio
HELP! I cannot get your steps to work with Microsoft Office Excel 7 -- when I go to Data there is not a Conditional Formatting option to select from -- what am I missing? Thanks! Flojoe "bpeltzer" wrote: Use conditional formatting. Select the cell, then Data > Conditional Formatting. Set the condi... 9 Mar 2010 11:13

I know this is obvious but ..
I'm just not seeing it this morning! I have 3 columns: Col P16 to P500 contains Project Names Col Q16 to Q500 contains Pricing Mechanism descriptions Col X16 to X500 contains Dates In Col AA16 - AA 500 I want to do the following: AA16 = Last Date for Project Name in P16:P500 where Q16:Q500 <> "Fixed Price" ... 9 Mar 2010 08:56

Count
Hi, On my file I get a list of accounts. I have a look up which lets me know which account belongs to which individual. I need to know how many different individuals there are each day. There can be a lot of change with new accounts etc so was thinking of doing a pivot table and somehow using a COUNT function... 12 Mar 2010 06:08