Simple (?) Match question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 08 Mar 2007 20:55 GMT

I'm trying to figure out someone else's workbook. This is the formula that
produces the correct contents of the cell in data!V4 on a different
worksheet.
=MATCH(9.99999999999999E+307,'Data'!A7:BA7)-1
How do I change this formula to obtain the contents of cell data!V5 ? & V6
The E and the +307 has me most perplexed.
The A7:BA7 is number data that is entered weekly, and the V column is the
last of the data for this week, so when next week's data is entered, the
contents of cell data! W4 will be produced, and then I'd want the formula to
obtain the contents of W5 & W6.

Thanks,

Steve

Reply to this Message

Dave F - 08 Mar 2007 21:39 GMT

9.99999999999999E+307 is scientific notation, i.e., approximately 10 *
10^307, or approximately 10 followed by 307 zeroes. Why someone is trying to
use a formula that considers such a large number, I have no clue.

Dave

Signature

A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

> I'm trying to figure out someone else's workbook. This is the formula that
> produces the correct contents of the cell in data!V4 on a different
[quoted text clipped - 10 lines]
>
> Steve

Reply to this Message