| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
which function
The data looks like
A B C 1/1/06 crop 1 ryegrass 2/1/06 crop 1 ryegrass 7/1/06 crop 2 millett 12/5/06 crop 1 ryegrass that data is generated in a query and changes greatly with each query but will have no more than 2 crops and all crop numbers will remain consist within each query. I need a function to allow me to lookup and return the information from crop1 into a single cell and the same for crop2. since dta is not sorted by crop lookup statements are not happy. any suggestions regarding other functions or a way to pull the info out. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Threaded Mode
