Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-09-2011, 12:59 PM
where_pc where_pc is offline how to create two columns based on a certain criterior from the original two column? Windows XP how to create two columns based on a certain criterior from the original two column? Office 2007
Novice
how to create two columns based on a certain criterior from the original two column?
 
Join Date: Jun 2011
Posts: 2
where_pc is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 06-10-2011, 02:19 AM
OTPM OTPM is offline how to create two columns based on a certain criterior from the original two column? Windows 7 32bit how to create two columns based on a certain criterior from the original two column? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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)
Reply With Quote
  #3  
Old 06-10-2011, 06:10 AM
where_pc where_pc is offline how to create two columns based on a certain criterior from the original two column? Windows XP how to create two columns based on a certain criterior from the original two column? Office 2007
Novice
how to create two columns based on a certain criterior from the original two column?
 
Join Date: Jun 2011
Posts: 2
where_pc is on a distinguished road
Default

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:
Originally Posted by OTPM View Post
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)
Reply With Quote
  #4  
Old 06-13-2011, 10:39 AM
OTPM OTPM is offline how to create two columns based on a certain criterior from the original two column? Windows 7 32bit how to create two columns based on a certain criterior from the original two column? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Sorry but you are still not making it clear what you want to achieve.
Tony (OTPM)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create two columns based on a certain criterior from the original two column? 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
how to create two columns based on a certain criterior from the original two column? Sequentail Number Each Row Based On Another Column Entry KramerJ Excel 3 05-07-2009 11:35 PM
how to create two columns based on a certain criterior from the original two column? Graphing in Excel - one plot many columns/pick one column jerryjaysr Excel 4 06-29-2006 07:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft