Remember Me?

#1
May 25th 14, 07:40 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2007 Posts: 279
Finding missorted cell in range

I have a worksheet consisting of about 400 rows, with about 80 columns
in each row.
The data in column(1) should be sorted and is so.
I just found data in column(62), which ought to be sorted, but is not.

I decided to look for an array formula to hit the spot.

I simplified the problem to playing card suits.
I want an array formula which finds the first unsorted item.

I have

A B C
1 Suits Random Random
2 Club Club Club
3 Diamond Heart Heart
4 Heart Diamond Diamond
6 Sort Shuffle Diamond

A5 is [=IF(AND(A\$2:A\$4<=A\$3:A\$5),"Sort","Shuffle")]
B5 is [=IF(AND(B\$2:B\$4<=B\$3:B\$5),"Sort","Shuffle")]
C5 is beyond my limited skill.

While I suspect Conditional Formatting ought to be usable to flag
unsorted cells, putting Cell Value is greater than C2 in C3 actually
compares the value in C3 with the constant "C2".

In principle, I should be able to add a "NoTrump" row, and have formulae
which continue to work, but can't currently think how.
--
Walter Briscoe

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Stilltrader47 Excel Programming 20 April 29th 10 03:36 AM maninashed Excel Worksheet Functions 10 October 4th 09 05:13 PM Minitman Excel Worksheet Functions 3 April 15th 08 06:34 AM Alex Excel Programming 3 August 10th 04 10:18 PM [email protected] Excel Programming 2 October 31st 03 10:57 PM

All times are GMT +1. The time now is 01:29 AM.