| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quickest way to find a row number a value
I have a spreadsheet as follows:
column A column B DEK S01 0 DEK S01 300 DEK S01 400 DEK S01 450 LIC G13 25 LIC G13 50 LIC G14 100 etc... I am trying to write a function to return the first non-zero value in column B of the Item in column A. So when I call the function Get_Cost("DEK S01") it will return 300. When I call Get_Cost("LIC G13") it will return 25. A quick way of getting the row number for LIC G13 would be a help, so I don't have to loop so much. DG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find previous number and find next number in column | Excel Discussion (Misc queries) | |||
| quickest way to find last "used" row in a 2D array? (repost) | Excel Programming | |||
| Quickest way to find/replace based on values? | Excel Worksheet Functions | |||
| IRR: is there a quickest way? | Excel Worksheet Functions | |||
| Find and Replace - Quickest Option? | Excel Worksheet Functions | |||
Threaded Mode
