Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract values to copy in another table
Could you please help me with this matter?
I wonder if there is any Excel's formula to do the following procedu The column "found" came from a text file. Number Call Test Found 1 t gg 6 2 t rr 10 3 u de 14 4 j ty 20 5 y hu 6 u ed 7 j gt 8 d vf 9 b ki 10 h yh 11 k bg 12 u ed 13 t sw 14 t rt 15 g mk 16 n lo 17 h uy 18 g hg 19 h rt 20 m vf Then I want the formula to copy the information which correspond under the column "Call" and "Test" and get the following result as shown below: Found Call test 6 u ed 10 h yh 14 t rt 20 m vf I will appreciate your helping me. Thanks in advance. Maperalia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract values to copy in another table
Have a look at the Vlookup function:
With the help of this function you should get the things you want to have! Hth Carlo "maperalia" wrote: Could you please help me with this matter? I wonder if there is any Excel's formula to do the following procedu The column "found" came from a text file. Number Call Test Found 1 t gg 6 2 t rr 10 3 u de 14 4 j ty 20 5 y hu 6 u ed 7 j gt 8 d vf 9 b ki 10 h yh 11 k bg 12 u ed 13 t sw 14 t rt 15 g mk 16 n lo 17 h uy 18 g hg 19 h rt 20 m vf Then I want the formula to copy the information which correspond under the column "Call" and "Test" and get the following result as shown below: Found Call test 6 u ed 10 h yh 14 t rt 20 m vf I will appreciate your helping me. Thanks in advance. Maperalia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
any way to copy and paste values from pivot table and keepformatting? | Excel Discussion (Misc queries) | |||
Filter records in a table to extract to another table | Excel Discussion (Misc queries) | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
extract values | Excel Programming | |||
How do you extract the top ten values in a table? | Excel Programming |