two column lookup

Hi All, Got an interesting query to ask.. Trying to work on a formula for the below, I need to remove duplicates that match on the same day.. So if the day and month is the same and the column c letter is the same then remove the duplicate. I cant seem to find a function or macro that could...

Hello Excel experts! I consider myself an expert user of Excel but I really got stuck on this problem :confused: . I prefer a solution with built-in formulas but if that isn't possible a VBA solution is fine. I have one table (the Rating table) where I occasionally put in data that is event...

I really hope I can get an answer for this question. I've spent HOURS trying to figure this out! I’M hoping that someone can help direct me. I’m able to search for an exact match using a VLOOKUP. I can only search one column though. <o:p></o:p> <o:p> </o:p> Here is my “current formula...

MS Excel 2007, Vista, The task asks that I find the item of (in this case) second hand uniform that has sold most units. To do so I need to create a list of unique items (text) found in a column that list all individual items that are or have been in stock. (which I can do using Advanced...

My spreadsheet has first and last name in two columns. I want to create a data validation the will look up both first and last name together, because there may be more than one John Smith, so just looking up Smith does not work. If I create a separate sheet and do concatenation, and then...