even better would be if there in two, or more rows I have the following cell values
23-25, 26 the row for this cell would be split into several rows, one for each number, ie the row with the cell would be split into rows with the cell values 23, 24, 25 and 26 where the values in the other columns for the row are copied from the oringial row where the cell was. is this understandable? mattias "mattias davidsson" <[EMAIL PROTECTED]> skrev i meddelandet news:[EMAIL PROTECTED] > dear posters > > > I would like to do one of two things > > 1. calculate the following from different cell values > > from cell value 1-4, 7-9 (describing ranges of weeks) > I would like to calculate the number of weeks, in this case 7. > > From cellvalue 2-4, 5,6 > the same thing, number of weeks is now 5 > > or any variant of the above.. > > the result should be put in a new cell in a new column > > hopeing for help > > cheers! > mattias --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
