Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
Default 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
5 Spade Spade Spade
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

Reply
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
Finding Next Empty Cell in a Range Stilltrader47 Excel Programming 20 April 29th 10 03:36 AM
An old chestnut: finding the last cell in a range maninashed Excel Worksheet Functions 10 October 4th 09 05:13 PM
Finding Cell Outside Of Range Minitman Excel Worksheet Functions 3 April 15th 08 06:34 AM
Finding the last cell in a range Alex Excel Programming 3 August 10th 04 10:18 PM
Finding if a cell is within a Range [email protected] Excel Programming 2 October 31st 03 10:57 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017