| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there function to check and list data?
Can I do a logic check down the rows, and then display the cells that matches my condition? I want to paste the wanted data in a new column. Is there any function to do that or do I need a macro? Example: to match "apple" Data: apple red apple green apple melon melon strawberry strawberry apple melon strawberry output(in a new column): apple red apple green apple apple -- KH_GS ------------------------------------------------------------------------ KH_GS's Profile: http://www.excelforum.com/member.php...o&userid=32920 View this thread: http://www.excelforum.com/showthread...hreadid=529077 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Which function to check any value existed withing a list? | Excel Discussion (Misc queries) | |||
| Which function to check any value existed withing a list? | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Function to check list for specific conditions and return an answe | Excel Discussion (Misc queries) | |||
| I have a data list of 7,000, what is the easiest way to check for | Excel Worksheet Functions | |||
Threaded Mode
