| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get numbers from row
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. Allan (in A1)comes in from the 14th to the 20th, so in B14:B20 the numbers 14,15,16,17....20 appears. 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? 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. Thanks Therese |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
Threaded Mode
