Hi my name is susy,
I wanted to know how can I make use of a list thats in another sheet
(sheet3) to validate a cell(in sheet 1).
I'm trying to make a drop down list with some options but if ome one else

Using an example from "Count how often multiple text or number values occur
by using functions" returns #VALUE!  Why?  Currently using Excel 2002 with
Add-Ins Conditional Sum Wizard, Solver Add-in, and Lookup Wizard.
fx:

Although I'm suspecting this cannot be done, generally, Excel surprises me
with neat tricks and tools. So, that's why I'm asking, since I haven't found
a way . . .
I have a value in a cell. In the next column, I have an If/then formula to

Is there a way to customize the label of the values on the Y axis?  For
example, instead of 10, 20 and 30 (points) I'd like the labels to be "High
School", "College" and "University".

I have a table where I want to sum Colum E, Data.
However I only want to sum those rows where the same row in Column B
have the value <=1.
I tried to set the condition OR(1,<1) but does not work. Also tried

I have data showing time as xx.xx.xx( i.e. 117.23.55). I would like to count
spent hours, but the format of the data needs to be changed. Replacing the
fullstop by a colon works for some cells, but some cells turn out showing a
date and another time. Any ideas how to change the ...

I am Radha krishna, I am having a doubt in Excel VBA programming. In our
work we are doing formats such as Merging, row banding, Button creation,
Print area setting, Hidding and deleting of rows and columns etc. At present
we are doing that in a for loop by selecting each sheet ...

Hi Guys, I think I need a lookup function (which ive rarely used) and excel
help is confusing me...
I have sheet2 where col A has every date for this year, Col B has its
corresponding week # (1-52). Then, in sheet 1 i have several columns. Col B

I want to find multiple text from a set of data and show the data of some
other cell if the data is found.
Eg: Cell A1 contains data - Business class
      Cell B2 contains Amount

I want to check if the value of a cell divided by a constant is a whole
number or integer - can anyone help
Thanks
DavidJ

Hi i am trying to create a graoh between x-axis and y-axis. basically
generating a simple distance formula graph :
x y
3 4

Hi, I am using a UDF to strip non numeric text out of a cell.
That is:
Function StripTxt(a As String) As String
' Strips all non-numeric characters from a string

G'day All,
Is it possible to refer to a cell on the previous sheet IN A FUNCTION
without refering to the sheet name?
Do sheets have index number or similar?

Hi
I use this formula a lot.
My question is, is it possible to use it with dates either by actually
entering a date as below or referencing the date to a cell?

Within a pivot table, how can I calculate a VARIANCE between 2 columns,
rather than the default "Grand Total" as shown below (i.e., I need to see a
variance of 8 on the Dog/Male row, rather than the "total" of 12) ?
Animal     Gender     Born     Sold     Grand Total