Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste text according to value in corresponding cell
Hi,
in Col B I have names, something like below.. Col B Name ABC MNO MNO MNO MNO XYZ XYZ UTV ABC MNO XYZ XYZ UTV ABC MNO XYZ XYZ UTV ABC XYZ UTV ABC XYZ UTV ABC XYZ UTV ABC XYZ UTV ABC XYZ UTV I need to insert same name in Col K as per value in Col F. That is I have Unique Name list in Cil E and value in Col F.. ColE ColF ABC 2 MNO 2 XYZ 3 UTV 2 If, F1=2 then I need E1 (ABC) Twice (In K1 & K2) and accordingly for F3=3, then E3 (XYZ) should come in after ABC & MNO in ColK. Pls assist Thnaks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell contents, then paste into the same cell with other text. | Excel Discussion (Misc queries) | |||
Extract Cell Comments and Paste as text in a cell | Excel Worksheet Functions | |||
how to cut part of a text from one cell and automatically paste itonto another cell | Excel Discussion (Misc queries) | |||
select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc... | Excel Programming | |||
if a cell contains certain text, cut and paste to another sheet | Excel Worksheet Functions |