off sets

For some reason my match is exactly 1 cell down from where it needs to start and I have not been able to figure out why. Customer A should come up 1,2,3 but I'm Getting 2,3,4 =OFFSET('Customer Info'!$A$1,MATCH($B$1,'Customer Info'!$A:$A,0),1,COUNTIF('Customer Info'!$A:$A,$B$1)) Thank you.

Hi there, Im trying to create a formula to look up the 1st, 2nd 3rd... occurences off "CHUCKER" using vlookup heres my formula for the first row: =VLOOKUP("CHUCKER",'[1 (version 1).xlsb]Pivot'!$1:$1048576,2,FALSE) anyone know the formula to return the 2nd and 3rd occurences? Any help would be...

I want to refer to the last date of the data set and make the cell value move UP until cell value is equal to text or in this case "BRL" If it is text, I want excel to run the formula in BLUE, otherwise I want excel to move up the column until it finds a text. =IF(ISTEXT(A9)...

hi, thanks in advance, and pardon me for my english, i am trying to make an excel sheet to keep my inventory of my company i have a large no of products, here, what i m trying to do is >>i have a sheet(diamond) which has details of the diamonds where i have shape, size, weight, price...

Problem copying Dynamic graphs with Offset formulas (Excel 2013) I have a workbook with many sheets with the same graphs plotting different date related information – each sheet has in it its own data In the first worksheet I have set up dynamic graphs (quarterly rolling) with offset formulas...