Tough: Vlookup, Match, Sumproduct? To create list of persistence
Data is input in the last 4 columns on the right.
Output is the first 3 columns on the left. What formulas go in the columns in the left to return the data as shown below? To explain in detail: Col A = Col C Col B counts the number of times the label in Col A appears in Col D through G. Col C returns the label if it does not appear in Col A. Cell A1 "May-2006" is a date reference: It pulls information relative to the Column Label. In this case, it is pulling in labels from ColG, and doing the matching/counting. Columns of data are added each month. So next month, I will add data to Col H and label it June-2006. Then I would like to type in Cell A1 "June 2006" and have the matching/counting formulas work. A very tough one... thanks a lot for taking a look... Regards, Steve C Col A ColB ColC ColD ColE ColF ColG May-06 On List PersistenceOff List Feb-06 March-06 April-06 May-06 Apples 4 Radio Dogs Dogs Apples Apples Cats 2 Coconut Apples Apples Cats Cats Dogs 4 Horse Horse Dogs Dogs Birds 2 Birds Monkey Birds Birds House 1 Tiger Tiger Birds House Gimp 2 Zebra Zebra Radio Gimp Pancake 2 Car Car Pancake Pancake Bus 1 Fish Giraffe Gimp Bus Beetle 1 Coconut Coconut Coconut Beetle |
Tough: Vlookup, Match, Sumproduct? To create list of persistence
One more thing: only need to look back 4 consecutive monthly periods...
so if you starting with May, you only need to look at May, April, March, Feb... |
All times are GMT +1. The time now is 04:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com