If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to select one record of each from a column
Hello,
I have a large worksheet with data. Here are the columns (a,b & c): Order # Employee Hrs. 1000 Mike 2 2000 Mike 1 1000 Paul 2 3000 Rose 3 8000 Mike 1 3000 Mike 2 1000 Rose 1 4000 Paul 1 7000 Jhon 3 5000 Rose 2 1000 Jhon 3 6000 Mike 1 9000 Mike 3 1000 Mike 2 Is there a formula to select only one of each record on "Order #" (column a) and put them on another column (column d)??? Once the formula is created, column d should look like this: 1000 2000 3000 4000 5000 6000 7000 8000 9000 Help please!!! Thank you, Cesar Urquidi |
#2
|
|||
|
|||
How to select one record of each from a column
Check your other post..You dont need to multi-post
If this post helps click Yes --------------- Jacob Skaria "Cesar Urquidi" wrote: Hello, I have a large worksheet with data. Here are the columns (a,b & c): Order # Employee Hrs. 1000 Mike 2 2000 Mike 1 1000 Paul 2 3000 Rose 3 8000 Mike 1 3000 Mike 2 1000 Rose 1 4000 Paul 1 7000 Jhon 3 5000 Rose 2 1000 Jhon 3 6000 Mike 1 9000 Mike 3 1000 Mike 2 Is there a formula to select only one of each record on "Order #" (column a) and put them on another column (column d)??? Once the formula is created, column d should look like this: 1000 2000 3000 4000 5000 6000 7000 8000 9000 Help please!!! Thank you, Cesar Urquidi |
#3
|
|||
|
|||
How to select one record of each from a column
On Fri, 20 Nov 2009 09:16:01 -0800, Cesar Urquidi
wrote: Hello, I have a large worksheet with data. Here are the columns (a,b & c): Order # Employee Hrs. 1000 Mike 2 2000 Mike 1 1000 Paul 2 3000 Rose 3 8000 Mike 1 3000 Mike 2 1000 Rose 1 4000 Paul 1 7000 Jhon 3 5000 Rose 2 1000 Jhon 3 6000 Mike 1 9000 Mike 3 1000 Mike 2 Is there a formula to select only one of each record on "Order #" (column a) and put them on another column (column d)??? Once the formula is created, column d should look like this: 1000 2000 3000 4000 5000 6000 7000 8000 9000 Help please!!! Thank you, Cesar Urquidi Try this formula in cell D2: =SMALL(A$2:A$15,1) and this formula in cell D3: =MIN(IF((A$2:A$15)D2,A$2:A$15)) Copy cell D3 down as far as needed A$15 should be changed to fit the size of your data in column A. Hope this helps / Lars-Åke |
Thread Tools | |
Display Modes | |
|
|