Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Align & Compare row with column
Current Scenario:
A1: USB 2.0, B1: USB, C1: Type A A2: FW, B2: FW400 A3: Serial, B3: DB-9, C3: RS-232 I have another list. F1: TypeA F2: DB-9 G1: USB 2.0 G2: RS-232 G3: FW400 H1: USB H2: Serial H3 FW What I want is to sort A1:C3 row wise, and it will compare with column F,G & H. if column F matched with row1 then a particular value should be appear. In other words no matter what data lies in A1:A4....its order should be like F1:H1 Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
align 3 concatenated strings for column appearnace | New Users to Excel | |||
Left align '$' and right align numbers? | Excel Discussion (Misc queries) | |||
Align Clustered Column Chart Category Axis Labels | Charts and Charting in Excel | |||
Macro to align and compare multiple rows and columns | New Users to Excel | |||
What is short-Cut forleft align and Right align? | Excel Discussion (Misc queries) |