Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help: Filter numbers
Hi
I work in office 2003, and don't have acces to newer formulars. We have a worksheet with names in column A and dates in row 2. The numbers(dates) changes downwards along with the names. The worksheet is called may, so they are just formatted numbers; not dates.. Its a rather large list of names and the numbers varies from name to name...The persons comes in different days in the month. Allan (in A1)comes in from the 14th to the 20th, so in B14:B20 the numbers 14,15,16,17....20 are written. Barbara (in B1)comes in from the 1st to the 12th and then again from the 17th to the 22nd. In cell A32 we would like "14" to appear, and "20" in A33. The same goes for row B; in cell B32 we would like "1" to appear and "12" in B33. In B34 we would like to see "17" and "22" in B34. Is this possible? Some comes in twice. If it's too complicated to get two sets of numbers, we would be super-duper happy to just have the first and last dates in A32 and A33. Thanks Therese |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter numbers | Excel Discussion (Misc queries) | |||
FILTER (REPEATED NUMBERS) | Excel Worksheet Functions | |||
How to filter only the numbers I need | Excel Worksheet Functions | |||
filter for even numbers in Excel | Excel Worksheet Functions | |||
Keep text filter away numbers | Excel Worksheet Functions |