Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Selection?
Believe col B in the earlier suggestion is a way that returns exactly what
you want. You can point whatever downstream calcs that you're going to do at col B, i.e. at B1:B3. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "M.A.Tyler" <Great Lakes State wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add "left align across selection" cell formatting | Excel Worksheet Functions | |||
Combo Box selection to place $0 into another cell | Excel Discussion (Misc queries) | |||
Cell selection not visible | Excel Discussion (Misc queries) | |||
Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
Can a conditional cell formula reference data selection in a comb. | Excel Worksheet Functions |