Posted to microsoft.public.excel.programming

Jim Berglund[_2_] Jim Berglund[_2_] is offline

external usenet poster

Posts: 86

Finding the end of Data

I have a data set that has a sorted column filled with either numbers or
"#N/A" (which are all found above the numbers)

I want to select the rows that have "#N/A" in them. How to I find the last
row, please?

Jim Berglund

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Finding specific data and changing cells next to the data	fozzetti	Excel Programming	1	July 30th 09 09:05 PM
Finding Data	Tabatha	Excel Worksheet Functions	3	February 25th 09 05:08 PM
Finding max row containing data...	Dan	Excel Discussion (Misc queries)	5	November 26th 05 09:33 PM
Finding data	Paulc	Excel Programming	1	March 23rd 05 12:06 PM
FINDING LAST ROW OF THE DATA	SUDHENDRA	Excel Programming	8	January 9th 04 11:02 PM

All times are GMT +1. The time now is 03:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us