Myrna Larson

Posts: n/a

You need an array formula for this: type this formula

=ADDRESS(SMALL(IF(A1:A10=B1,ROW(A1:A10),65536),3), 1)

then press CTRL+SHIFT+ENTER, not just ENTER

On Thu, 4 Nov 2004 03:44:03 +0800, "Chris" wrote:

3, 1, 1, 2, 1, 2, 2, 2, 1,
3

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
Problem sorting in Excel	Kat	Excel Discussion (Misc queries)	2	January 19th 05 03:29 PM
Difficult Sorting Problem	Rob	Excel Discussion (Misc queries)	2	January 5th 05 03:05 PM
Crazy Sorting Problem.....	Neal	Excel Discussion (Misc queries)	1	December 30th 04 06:56 PM
Sorting problem	Klaus	Excel Discussion (Misc queries)	3	December 4th 04 01:55 AM
Problem Sorting	Douglas Sey	New Users to Excel	1	November 28th 04 07:26 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us