|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to create two columns based on a certain criterior from the original two column?
Hi there , I may have a simple question, however it is difficult for me. If you can help, that would be great! there is two columns, lets say 0.1 3 0.2 10 0.3 8 0.4 41 0.5 16 0.6 19 0.7 21 0.8 15 0.9 17 I want to creat a new two columns partially from the original column based on the criterior, when A=0.1*N( N=3i) , choose B 0.1 3 0.3 8 0.6 19 0.9 17 I am not sure if I fully state it. Thanks ! Where_pc |
#2
|
|||
|
|||
Hi
I am not sure you are clearly stating what you want to acheive. You cannot create two new columns based on a formula. You can however populate other columns based on a calculation on other adjacent cells. PLease try and be more clear what you want to achiev and we will try and help you. Tony (OTPM) |
#3
|
|||
|
|||
Basically I want to reduce the row by a certain criterior . You can understand if you look at the number of the row change I presented . Thanks !
Quote:
|
#4
|
|||
|
|||
Sorry but you are still not making it clear what you want to achieve.
Tony (OTPM) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to expand one column into two columns? | Jamal NUMAN | Excel | 1 | 01-12-2011 07:59 PM |
Single-click to archive emails to dif't folders based on original folder? | Dougmeister | Outlook | 0 | 09-23-2010 01:18 PM |
Create index based on bullet numbers | EZRider | Word | 0 | 07-10-2009 09:21 AM |
Sequentail Number Each Row Based On Another Column Entry | KramerJ | Excel | 3 | 05-07-2009 11:35 PM |
Graphing in Excel - one plot many columns/pick one column | jerryjaysr | Excel | 4 | 06-29-2006 07:27 AM |