Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
M.A.Tyler
 
Posts: n/a
Default Cell Selection?

I have a colum of 5 numbers. They are from 0 to 198, but in any random order.
My problem is, I need to use the top three ie: A1,A2,A3, unless any of them
are 198, then it would be passed, and I would need to include the forth ie:
A4, and if that were 198, then the fith, A5.

Can someone suggest the best, or any way to do this?

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
Add "left align across selection" cell formatting Monty Analyst Excel Worksheet Functions 2 November 5th 08 03:17 PM
Combo Box selection to place $0 into another cell John Excel Discussion (Misc queries) 16 July 22nd 06 01:17 PM
Cell selection not visible Mangesh Yadav Excel Discussion (Misc queries) 1 September 1st 05 01:29 PM
Cell Selection after "Enter" Synectica Excel Discussion (Misc queries) 6 August 29th 05 09:55 PM
Can a conditional cell formula reference data selection in a comb. t_nellis Excel Worksheet Functions 1 April 19th 05 04:44 PM


All times are GMT +1. The time now is 10:03 AM.

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"