LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default How to intersect two coloumns in a third coloumns

Hi guys,

I am not so expert using excel so I need your help for this simple
problem.

What I have to do is to intersect the values contained in two coloumns
in a third coloumn.

For ex:

A1 - 1 B1-4
A2 - 3 B2-2
A2 - 5 B3-6
A2 - 7 B4-8
A2 - 9 B5-10

The result of coloumn C should be (the condition is that the values of
A,B coloumns have to be put in sequence in the coloumn C)

C1-1
C2-2
C3-3
C4-4
C5-5
C6-6
........

Anyone know how to do that using an excel formula or macro?

Thanks in advance to all.
BR,
Jessie

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Coloumns that are Formula's heritage1450 Excel Worksheet Functions 1 June 25th 09 05:37 PM
How do COUNTIF from two different coloumns but not all rows? JP Excel Worksheet Functions 1 December 16th 08 01:47 AM
FILTER applied to many coloumns [email protected] Excel Discussion (Misc queries) 0 September 12th 06 09:52 AM
searching rows and coloumns Juuljus Excel Programming 4 December 6th 05 02:43 PM
Multiple coloumns data dok112[_5_] Excel Programming 3 June 17th 04 04:30 PM


All times are GMT +1. The time now is 12:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"