Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching & adding text in the respective column
I have text data in following way
high india high australia low russia medium france medium italy low germany high spain Now in a separate sheet, I need result for high, medium & low by adding the respective text of the same such as follows High india australia spain medium france italy low russia germany Can u help me phrasing the formula for the same ? -- ashutosh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When i am at a cell, how can i highlight respective row and column | Excel Discussion (Misc queries) | |||
adding * to text to column | Excel Discussion (Misc queries) | |||
Column Chart - Adding text in the column in Excel 2007 | Charts and Charting in Excel | |||
Count matching text in column | Excel Discussion (Misc queries) | |||
Looking up data in a column, then returning values of respective row | Excel Discussion (Misc queries) |