SOLVED!Search column for next number

[ROBINSYN]

How do 1 search columnA on Summary Sheet to reutrn next number to cellK8 on Purchase Order Sheet?
This message was edited by ROBINSYN on 2002-10-26 23:44

 

[Dejan]

Please be more specific?

 

[ROBINSYN]

Summary sheet is like a database with numbers in column"A" that increase as records are recorded. I want to have a function in Cell"K8" that will search the Column with the numbers in the Summary Sheet , then Add 1 to the last number found on summary sheet. Can this be done. I tried DMax but keep getting an error.

 

[ROBINSYN]

I tried this function and it wants to work but keeps returning value# as result.

=MAX("Summary",A:A)+1

Would it be because I labeled the column. All the cells are formated as a number.

HELP!!!

 

[Yogi Anand]

Hi ROBINSYN:

use ...

=MAX(Summary!A:A)+1

see the worksheet simulation

y021026h1.xls
	A	B	C	D	E	F	G	H	I	J	K
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8										12
9	9
10	10
11	11
Summary

</SPAN>

Regards!

Yogi Anand

 

[ROBINSYN]

Thank you! worked like a charm.