I'm trying to read employee's records, and I have lots of Bobs and others,
but different last names on the following column. The question is: how do I
make it read the next column to match the last name to extract the
information for that row? I can't just use the second column ...

I have some applications that use to work, but now come up and lock up
Excel.  I am thinking that if I could delete the digital certificates
associated with them, I could at least look at the Excel code by
selecting "Disable Macros" and maybe figure out what's gone wrong.

I am trying to return text depending conditional on multiple criteria.
Again best explained by example:
Area    ID    New    Rank    Select
A    1    1    7    Yes

Not sure if this is possible...
COLUMN F       COLUMN G
6,942             292
317             0

This should be easy, but I can't quite get it.  I need an event macro that
will cause the current worksheet to "scroll down" to the end of the data set
before going to the other, selected worksheet.  The data set is fixed, so I
could use something like "ActiveWindow.ScrollRow =", ...

Someone clever helped me with the above formula to flag overdue dates in a
reminder spreadsheet.  It works beautifully, except that I'd prefer "expired"
to appear only if there is a date in the adjacent cell.  At the moment it's
referring to blank cells as well as those with an ...

I have a series of future cash flows, and a lump sum offer for them.  Is
there a function I can use in Excel to calculate what the discount rate used
to generate that lump offer was?  I can trial and error it using PV and
extrapolating a rate, but I was hoping for something that ...

I want to have my speadsheet be viewed ONLY as normal, and NOT as a page
break.  How do I set that protection, that a student will not be able to even
choose page break?  I am using the spreadsheet online in a testing format.

I'm trying to do a dynamic sum function for a daily production given table.
File A is a summary, with many tabs for each product type.  File B contains
the daily production detail.
File A has a sumif function:

I went through some of the questions and have not been successful at finding
the simplest and concise way of tracking contracts for my reporting purposes.
Currently, I track multiple tasks for one contract number. As a result, I end
up have multiple task dates for one project ...

Good afternoon...
The following function
=+OFFSET($B$10,MATCH(B7,$B$11:$B$161,0),MATCH(C2,$C$10:$V$10,0))*$C$5
Is not supported by the reporting application i am using (Excelsius)...

Hi
would anyone know how to do the following
I have hundreds of rows of data in the following several columns as per below
reference number| type | qty | value |

I have a speadsheet in which I am selecting a metal pipe based on two inputs.
The first input would be the pipe size (1", 2", 3", 4", 6", 10", etc). The
second input would further refine the selection as to the pipe schedule (Sch
10, Sch 20, Sch 40, Sch 80, etc). Is it possible ...

If the sum of (F4*H4) = a negative number I want it to return a zero but I
can't seem to come up with a workable formula. Sugestions?
=IF(ISBLANK(G4),"",SUM(F4*H4))

How do I choose the last five sets of data in a column.  I want to make a
chart that continually updates as I add in data but only with the last five
sets of data.  Is this possible with "offset" and how would I do this?
Erik