Posts Tagged ‘items’

Imagine that we have the following 2 lists each consisting of 3 columns of data: And we need to find those items that are in List 1 that are in List 2. However ALL 3 columns of data must match for items to be in both lists. One way would be to construct a comprehensive […]

Wednesday, October 22nd, 2008 at 03:58 | 2 comments
Categories: Formulas

Consider the following two lists: And that we want to see which items from column A are in Column B. This can be achieved by the MATCH function in conjunction with ISNUMBER . The MATCH function has the following syntax: MATCH(A6,C4:C13,0) And this oem software store will return the position of the value cell A6 […]

Tuesday, October 14th, 2008 at 02:57 | 1 comment
Categories: Formulas