### Similar Threads:

1.input a date or update it based on date in another cell

-Someone asked me to setup a spreadsheet like this
cell b2 is entered as a date
cell c2 is entered as a number
cell d2 is a calculated date =b2+c2
now cell c2 gets more interesting. the user will enter a date like they did
in b2, but if the number in c2 is changed modifing the date in d2 they want
the date in c3 to be advanced as well.
They want to use it to track some projects using software they have already
paid for and not buy additional software.
--
Doug P

2.rearrange cells in random order

I have a list of words in a column that I would like to rearrange in a random
order. Any help would be appreciated.

3.Rearrange numbers from a column in a different order in a second c

Hi, I'm using Excel 2003 on Windows. I have a list of 4800 numbers in a
column divided by groups of 5 within a larger group of 80. I need to
rearrange them in a second column with a different order but with a pattern.
Each group of five consecutive numbers are separated by a jump of 6 numbers
up to 75, starting at number ''1''. By using exactly the same pattern, start
this time with number ''6'' up to 80. The same pattern is repeated from 81 to
160, ... up to 4800.
I'm not an expert. Is there an efficient way to rearrange these numbers? Any
help would be great!
In other words, in column A, you have numbers from 1 to 4800. In column B, I
need the numbers to be in the following order:
A B
1 1 1st group of 80
2 2
3 3
4 4
5 5
6 11
7 12
8 13
9 14
10 15
11 21
12 22
13 23
14 24
15 25
16 31
17 32
18 33
19 34
20 35
'' ''
'' ''
36 71
37 72
38 73
39 74
40 75
41 6
42 7
43 8
44 9
45 10
46 16
47 17
48 18
49 19
50 20
51 26
52 27
53 28
54 29
55 30
56 36
57 37
58 38
59 39
60 40
61 46
62 47
63 48
64 49
65 50
66 56
67 57
68 58
69 59
70 60
71 66
72 67
73 68
74 69
75 70
76 76
77 77
78 78
79 79
80 80 2nd group of 80 with identical pattern to group 1
81 81
82 82
83 83
84 84
85 85
86 91
87 92
88 93
89 94
90 95
'' ''
151 146
152 147
153 148
154 149
155 150
156 156
157 157
158 158
159 159
160 160
Thanks a lot!

4.Rearrange numbers from a column in a different order in a seco

The data are % which could be negative. The '' '' was just to say that the
series are continuing following the same pattern. These % are not in order.
Each group of five are data associated with one compound. They have to be
rearranged because they are automatically plotted on a graph with very
complex algorythms.
Thanks for your interest to fix my problem.
"driller" wrote:
> gaetae,
> 1. if u say numbers, on column A,
> a. is it in sequence <min to max or max to min>
> b. is it a mixture of different numbers, not in order, (i.e. %,
> Currency, Date, etc.)
> c. if it is "", do you mean it is a blank cell, or a text number "n" ?
> pls. be specific about the details of your numbers, for any reason why you
> group them..
>
> "Gaetan58" wrote:
>
> > Hi, I'm using Excel 2003 on Windows. I have a list of 4800 numbers in a
> > column divided by groups of 5 within a larger group of 80. I need to
> > rearrange them in a second column with a different order but with a pattern.
> > Each group of five consecutive numbers are separated by a jump of 6 numbers
> > up to 75, starting at number ''1''. By using exactly the same pattern, start
> > this time with number ''6'' up to 80. The same pattern is repeated from 81 to
> > 160, ... up to 4800.
> >
> > I'm not an expert. Is there an efficient way to rearrange these numbers? Any
> > help would be great!
> >
> > In other words, in column A, you have numbers from 1 to 4800. In column B, I
> > need the numbers to be in the following order:
> >
> > A B
> >
> > 1 1 1st group of 80
> > 2 2
> > 3 3
> > 4 4
> > 5 5
> > 6 11
> > 7 12
> > 8 13
> > 9 14
> > 10 15
> > 11 21
> > 12 22
> > 13 23
> > 14 24
> > 15 25
> > 16 31
> > 17 32
> > 18 33
> > 19 34
> > 20 35
> > '' ''
> > '' ''
> > 36 71
> > 37 72
> > 38 73
> > 39 74
> > 40 75
> > 41 6
> > 42 7
> > 43 8
> > 44 9
> > 45 10
> > 46 16
> > 47 17
> > 48 18
> > 49 19
> > 50 20
> > 51 26
> > 52 27
> > 53 28
> > 54 29
> > 55 30
> > 56 36
> > 57 37
> > 58 38
> > 59 39
> > 60 40
> > 61 46
> > 62 47
> > 63 48
> > 64 49
> > 65 50
> > 66 56
> > 67 57
> > 68 58
> > 69 59
> > 70 60
> > 71 66
> > 72 67
> > 73 68
> > 74 69
> > 75 70
> > 76 76
> > 77 77
> > 78 78
> > 79 79
> > 80 80 2nd group of 80 with identical pattern to group 1
> > 81 81
> > 82 82
> > 83 83
> > 84 84
> > 85 85
> > 86 91
> > 87 92
> > 88 93
> > 89 94
> > 90 95
> > '' ''
> > 151 146
> > 152 147
> > 153 148
> > 154 149
> > 155 150
> > 156 156
> > 157 157
> > 158 158
> > 159 159
> > 160 160
> >
> > Thanks a lot!
> >
> >
> >
> >
> >
> >
> >

5.can i rearrange names in alphabetic order...

Hi friends i hope all u peple are fine..
i have following names in my excel sheet.......
Hussain
Zain sohail
Nauman Khan
Qazmi Ahmad
I want these names to rearrange in alphabetic order is there any way t
do this after writing these name sin excel sheet.....
Its urgent.bye take car

6. Rearranging order of digits in a cell

7. rearrange Columns according to predefined order

8. rearrange an array in a different order