Adding on to a formula
Is this what you mean?
=IF(ROW(1:1)<=ROUND(1*COUNT('Priced BOM'!$T$3:$T$34),0),
MATCH(LARGE('Priced BOM'!$T$3:$T$34,ROW(1:1)),'Priced BOM'!$T$3:$T$34,0),"")
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"Joe Gieder" wrote in message
...
First, thank you for looking at this and any help you can provide. I use
this
formula to get the highest extended cost from a list (kind of like auto
filter but with a formula):
=IF(ROW(1:1)<=ROUND(1*COUNT('Priced BOM'!$T$3:$T$34),0),LARGE('Priced
BOM'!$T$3:$T$34,ROW(1:1)),"")
and was wondering if there is a way to add a second formula to it to
retrieve another piece of data from a different cell but within the same
row,
an example being is suppose the highest cost is $128.00 and it's record
number 1200, can I add another formula that will also give me the record
number?
Thanks in advance for the help
Joe
|