Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
looking for a value in a collumn
Here is an example of the current sheet Type | Site cars | Automart.com cars | MSN Autos trucks| MSN Autos food | kraft.com trucks | fordtrucks.com I would like to create a new collumn titled match. The function would match if a site included both types (cars and trucks). Could I have some help with this function? Type | Site | Match cars | Automart.com | N cars | MSN Autos | Y cars | ford.com | Y trucks| MSN Autos | Y food | kraft.com | N trucks | ford.com | Y -- exceluser2 ------------------------------------------------------------------------ exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338 View this thread: http://www.excelforum.com/showthread...hreadid=510203 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking up data within a collumn | Excel Discussion (Misc queries) | |||
How to increase an entire collumn by a certain percentage? | Excel Discussion (Misc queries) | |||
How can I make the collumn headers in excel be letters rather tha. | Excel Discussion (Misc queries) |