Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
On sheet X
Cell A1 either displays an "S" or an "R". ( this comes in when the numbers in B1 thru B16 is downloaded. On sheet X Cells B1 thru B16 will display from 6 to 16 numbers in any random order ex. 3-4-7-1-9-5-16-2, , , . Note: They are never the same or is there ever a duplication of a single number in the same set of 6 to 16. The data set comes in ten times a day 9 different sets at a time. This part of the display is complete. This is what I need, , , On sheet Z Cell Q1 needs to display If A1 = S then display the first four numbers in B1:B16 ex. 1,2,3,4 ( this is an easy IF statement but the next one if not an S but is an R has me wondering ) If A1 = R then display the FIRST THREE AND THE LAST THREE NUMBERS in B1:B16 ex. 1,2,3 / 4,5,6 or 1,2,3 / 14,15,16 depending on length of number values Can anyone supply me with a formula for cell Q1 on sheet Z to do this? Thanks |