how to create two columns based on a certain criterior from the original two column?

where_pc · #1 06-10-2011, 06:10 AM

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

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)

OTPM · #2 06-13-2011, 10:39 AM

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

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