LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default find last row value in column when using MATCH to find column

Hi

I have a problem where I use MATCH to find a column with a specific heading
and then I want to find the last value in the column.
I would like to achieve this just using formulas in the worksheet if possible
All the solutions I have found require the Column letter ("B") instead of a
reference.
My match range does start at column A as 1 if that helps.
Any assistance would be greatly appreciated.
Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find something in column a then find if column B matches criteria Darrell_Sarrasin via OfficeKB.com Excel Discussion (Misc queries) 8 November 28th 07 09:40 PM
Find First Non blank cell than find column header and return that value Silver Rose Excel Worksheet Functions 10 April 30th 07 05:56 PM
How can find match of one cell from a column of cells? mat Excel Discussion (Misc queries) 1 October 26th 06 04:59 PM
find LAST match in column Pantryman Excel Worksheet Functions 7 February 24th 05 11:18 AM
find LAST match in column Pantryman Excel Worksheet Functions 1 November 5th 04 04:05 PM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"