Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What is the formula for adding up *values! in a columm in exell | Charts and Charting in Excel | |||
My formula cell has stopped adding the preceding cells. | Excel Worksheet Functions | |||
Excel formula to calculate % gain when adding cash equity to accou | Excel Worksheet Functions | |||
Adding something to a complicated formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions |