Ayuda con Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2225058%22%20slang%3D%22es-ES%22%3EHelp%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2225058%22%20slang%3D%22es-ES%22%3E%3CP%3EHello!%20I%20need%20help%20because%20I%20don't%20know%20what%20formula%20I%20should%20use%20to%20do%20a%20couple%20of%20things...%3C%2FP%3E%3CP%3EI%20have%20some%20data%20that%20is%20as%20follows%3A%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%221131%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E5%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E6%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E7%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E8%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E9%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E10%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E11%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E12%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3ETo%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C548%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C314%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E3%2C029%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C7%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C591%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C293%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C309%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C409%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EB%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C395%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C583%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C593%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C484%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C223%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C463%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C486%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C42%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EC%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C331%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C19%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C401%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C209%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E1%2C91%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C17%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E1%2C913%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C117%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3ED%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C289%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C176%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C394%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C225%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C262%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C155%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C253%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EE%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C394%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C563%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C599%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C622%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C234%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C389%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C447%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EF%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C39%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C563%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C539%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C819%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C321%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C428%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C595%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C504%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EG%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C144%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C333%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C327%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C316%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C151%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C249%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C219%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C19%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EH%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C207%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C313%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C247%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C272%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C198%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C278%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C135%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C268%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E5%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E6%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E7%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E8%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E9%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E10%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E11%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E12%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3ETo%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C508%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C586%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E3%2C011%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C658%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C611%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C426%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C339%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C432%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EB%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C436%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C563%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C6%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C567%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C226%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C518%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C476%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C458%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EC%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C275%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C17%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C333%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C192%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E1%2C852%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C117%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E1%2C889%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C074%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3ED%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C275%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C197%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C359%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C19%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E1%2C906%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C251%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C107%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C235%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EE%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C402%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C563%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C584%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C614%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C233%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C42%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C455%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C505%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EF%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C395%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C557%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C543%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C809%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C341%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C437%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C595%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C501%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EG%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C104%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C322%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C305%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C312%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C08%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C264%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C192%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C149%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EH%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C159%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C289%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C258%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C273%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C136%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C262%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C113%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C222%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E5%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E6%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E7%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E8%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E9%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E10%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E11%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E12%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3ETo%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C509%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C578%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E3%2C02%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C67%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C619%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C412%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C356%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C439%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EB%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C444%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C567%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C603%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C572%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C23%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C512%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C484%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C469%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EC%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C261%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C166%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C329%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C162%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E1%2C784%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C09%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E1%2C843%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C03%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3ED%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C273%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C186%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C356%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C159%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E1%2C832%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C235%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C067%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C184%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EE%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C405%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C556%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C572%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C612%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C238%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C434%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C465%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C51%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EF%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C398%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C557%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C552%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C801%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C355%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C453%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C586%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C515%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EG%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C068%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C302%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C29%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C289%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E1%2C994%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C262%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C176%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C106%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%20height%3D%2220%22%3EH%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C13%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C276%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C253%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C258%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C065%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C243%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C095%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E2%2C191%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20data%20group%20is%20data%20collected%20on%20time%200%2C%201%2C%202%20min%20from%20an%20enzymatic%20reaction%20on%20a%20multiwell%20plate.%20The%20thing%20is%2C%20now%20I%20want%20to%20put%20the%20data%20in%20value%20vs%20time%20format%20for%20each%20of%20those%20samples.%20To%20do%20this%20I%20make%20another%20table%20where%20I%20put%20the%20times%3A%200%2C%201%2C%202%2C%20and%20to%20put%20the%20values%20should%20put%20for%20example%20for%20the%20first%20sample%20cells%20B2%2C%20B12%2C%20B22...%20The%20thing%20is%20that%20I%20don't%20know%20what%20I'm%20formulating%20I%20should%20use%20to%20be%20able%20to%20copy%20and%20paste%20the%20values%20of%20those%20cells%20only%2C%20because%20when%20I%20use%20B2%20and%20try%20to%20drag%2C%20it%20takes%20me%20B3%20and%20not%20B12%2C%20which%20is%20what%20I%20would%20like.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20if%20I've%20explained%20myself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2225058%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2225081%22%20slang%3D%22en-US%22%3ERe%3A%20Ayuda%20con%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2225081%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1003536%22%20target%3D%22_blank%22%3E%40ErrMathew%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDigamos%20que%20la%20primera%20f%C3%B3rmula%20est%C3%A1%20en%20la%20celda%20B2.%20Usa%20la%20f%C3%B3rmula%3CBR%20%2F%3E%3D%C3%8DNDICE(Hoja1!%24B%3A%24B%3B10*FILA()-8)%3CBR%20%2F%3Edonde%20Hoja1%20es%20el%20nombre%20de%20la%20hoja%20con%20los%20datos.%3CBR%20%2F%3ELlenar%20hacia%20abajo.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hola! Necesito ayuda porque no se que formula debería usar para hacer un par de cosas...

Tengo unos datos que están de la siguiente manera:

 123456789101112
A2,5482,3143,0292,7    2,5912,2932,3092,409
B2,3952,5832,5932,484    2,2232,4632,4862,42
C2,3312,192,4012,209    1,912,171,9132,117
D2,2892,1762,3942,225    22,2622,1552,253
E2,3942,5632,5992,622    2,2342,3892,4472,5
F2,392,5632,5392,819    2,3212,4282,5952,504
G2,1442,3332,3272,316    2,1512,2492,2192,19
H2,2072,3132,2472,272    2,1982,2782,1352,268
             
 123456789101112
A2,5082,5863,0112,658    2,6112,4262,3392,432
B2,4362,5632,62,567    2,2262,5182,4762,458
C2,2752,172,3332,192    1,8522,1171,8892,074
D2,2752,1972,3592,19    1,9062,2512,1072,235
E2,4022,5632,5842,614    2,2332,422,4552,505
F2,3952,5572,5432,809    2,3412,4372,5952,501
G2,1042,3222,3052,312    2,082,2642,1922,149
H2,1592,2892,2582,273    2,1362,2622,1132,222
             
 123456789101112
A2,5092,5783,022,67    2,6192,4122,3562,439
B2,4442,5672,6032,572    2,232,5122,4842,469
C2,2612,1662,3292,162    1,7842,091,8432,03
D2,2732,1862,3562,159    1,8322,2352,0672,184
E2,4052,5562,5722,612    2,2382,4342,4652,51
F2,3982,5572,5522,801    2,3552,4532,5862,515
G2,0682,3022,292,289    1,9942,2622,1762,106
H2,132,2762,2532,258    2,0652,2432,0952,191

 

Cada grupo de datos son los datos recogidos a tiempo 0, 1, 2 min de una reacción enzimática en una placa multipocillos. El caso es que ahora quiero poner los datos en formato valor vs tiempo para cada una de esas muestras. Para ello hago otra tabla donde pongo los tiempos: 0, 1, 2, y para poner los valores debería poner por ejemplo para la primera muestra las celdas B2, B12, B22... El caso es que no se que formula debería usar para poder ir copiando y pegando los valores de esas celdas solamente, ya que al usar =B2 e intentar arrastrar, me coge B3 y no B12, que es lo que querría.

 

No se si me he explicado

 

 

3 Replies

@ErrMathew 

Digamos que la primera fórmula está en la celda B2. Usa la fórmula
=ÍNDICE(Hoja1!$B:$B;10*FILA()-8)
donde Hoja1 es el nombre de la hoja con los datos.
Llenar hacia abajo.

@Hans Vogelaar 

Creo que me he expresado mal, porque lo he intentado hacer y no me sale... Voy a adjuntar el archivo que estoy usando para ver si así me puedes ayudar.

 

En este caso, quiero poner en Q3 el valor de B2, luego en R3 el de B12, en S3 el de B22, en T3 el de B32, y así sucesivamente. El caso es que si en Q3 pongo =B2 y luego de ahí arrastro la fórmula hacia la derecha, en R3 me pone el valor de B3, y no el de B12 como me gustaría. ¿Que hago para que me pueda saltar de B2 a B12? Podría hacerlo a mano, pero tendría que hacerlo a mano para más de 600 valores y me tomaría mucho tiempo. 

Gracias

@ErrMathew 

Ver la versión adjunta.