| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Last Value
MsgBox ActiveSheet.Evaluate("MAX(IF(A1:A20=""Q1"",ROW(A1: A20)))")
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "comparini3000" wrote in message ... Mr. Phillips, thank you for your quick reply, the formula worked wonderfully. However, I was looking for a VBA solution. How would I do that? "Bob Phillips" wrote: Simple enough =MAX(IF(A1:A20="Q1",ROW(A1:A20))) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. To get the first row, change MAX to MIN -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
| find and delete text, find a 10-digit number and put it in a textbox | Excel Programming | |||
| backwards find function to find character in a string of text | Excel Programming | |||
Threaded Mode
