Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find last entry in row based on matching value
PHYZX 5.26 5.29 5.31 5.33 5.33 5.33 5.33
NAMAX 11.27 11.34 11.41 11.51 11.57 11.54 11.40 JSVAX 13.45 13.59 13.58 13.68 13.66 13.66 13.42 Assuming PHYZX is at Sheet1!C2, I want to find the last entry for PHYZX from within Sheet2 for use in a formula specific to PHYZX. Value PHYZX can be sorted to any row depending on other criteria, so the formula must always find the last value for PHYZX. I would like to do this for each row. i would prefer not to use VB code. -- newbie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Based of Cells Based on Data Entry in anoth | Excel Discussion (Misc queries) | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
only returning 1st matching entry in table, need to find next matc | Excel Worksheet Functions | |||
matching part of an entry in a cell | Excel Worksheet Functions |