I hope this makes sense!
I'm using Excel 03
if b2 is 34 or less then d2=250 and if b2 is between 35 to 39 then d2=500
and if b2 is between 40 to 44 then d2=750 and if b2 is between 45-49 then

Example, in workbook "Apples", column B3, I want to count what is in workbook
"Oranges", column P3:P5000 if in workbook "Oranges", column A3:A5000 contains
the number 500400. Please help.

How can I categorise answers in excel?

I do not have any problems migrating numerical data from one worksheet to
another, however I am not able to do the same with text data.  If anyone can
help with a formula that would allow me to migrate text data that would be
great!  Thanks.

Autofiltering Dates - stored as string
Is there a way to Autofilter a column of dates, when these dates are
stored as strings?.
15 Apr 2007

Hi All..........
I am trying to make a formula that will return the SUM of the range O:R of
the row in which is found the value in column A.......ie
=SUM("O"&MATCH(A12,'All WO''s'!$B:B)&":R"&MATCH(A12,'All WO''s'!$B:B))

HELP!!  important data for work!!
Trying to return a cell value when 2 conditions are met using 2 lookup values:
i.e.
A      B      C

In an array, I need to identify the total number of days and dollars out of
sync if specific conditions are not met.  For instance,
A report is due on X date but 3 reports later, the dollars were finally
correct.  I need to calculate the number of days it took to finally get the

How do i remove duplicates from a massive range in a column.
thanks
Karen

How can I write as an expression in excel that:
identifies the full 12 months prior to a given date
AND
identifies the full 12 months after a given date

Here is the problem - If  cell A1 has 0 then I want B1 to be
0...however if A1= 1 I want B1 to display the result from a look up
table.
I just keep getting error messages and I am ready to chuck the

I know this sounds basic but it driving me crazy!
I need to do the following
If a1=0 then I want C1 = 0
If A1 =1 I want  C1 to = the value from a lookup table ( solver will

if i store a number in one cell.
i want to see tht number in words in other cell how can i do it.

I have a long list of numbers that I need to change.
the original number is:
1961-04-10-2691
I need it to be:

I'm trying to Hlookup a cell but the reference cell is merged. I only receive
information from the first of the two columns underneath the merged reference
cell and not the second - is their a way to change the formula so that I can
recieve both sets of looked up information?