| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare values, display date
There is a threshhold value that I need to compare projected values to. When the projected value becomes the threshhold value, I need to display the date when that happens and if it doesn't happen in the projected data then n/a. Dates are in rows across the spreadsheet, with corresponding projections in rows below. Threshhold and current values are in a second (summary) spreadsheet in the same workbook. Thanks for any help you can offer. DJ -- DeejGCK ------------------------------------------------------------------------ DeejGCK's Profile: http://www.excelforum.com/member.php...o&userid=32539 View this thread: http://www.excelforum.com/showthread...hreadid=523232 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare values, display date
=INDEX(Date_Range,MATCH(TRUE,Projection_RangeThre shold,0))
could look like this with dates in A2:Z2 and projections in A3:Z3 Threshold value in sheet called summary B2 =INDEX(A2:Z2,MATCH(TRUE,A3:Z3Summary!B2,0)) needs to be entered with ctrl + shift & enter -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "DeejGCK" wrote in message ... There is a threshhold value that I need to compare projected values to. When the projected value becomes the threshhold value, I need to display the date when that happens and if it doesn't happen in the projected data then n/a. Dates are in rows across the spreadsheet, with corresponding projections in rows below. Threshhold and current values are in a second (summary) spreadsheet in the same workbook. Thanks for any help you can offer. DJ -- DeejGCK ------------------------------------------------------------------------ DeejGCK's Profile: http://www.excelforum.com/member.php...o&userid=32539 View this thread: http://www.excelforum.com/showthread...hreadid=523232 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare values, display date
*YOU* are fabulous! Thanks so much! -- DeejGCK ------------------------------------------------------------------------ DeejGCK's Profile: http://www.excelforum.com/member.php...o&userid=32539 View this thread: http://www.excelforum.com/showthread...hreadid=523232 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I write an excel formula to display the file save date? | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| count and display unique values | Excel Worksheet Functions | |||
| Can I display the current date in a text box? | Excel Discussion (Misc queries) | |||
| Calculations from date and time values | Excel Worksheet Functions | |||
Linear Mode
