New Posts For Thread: Excel questionhttps://community.betfair.com/general_betting/go/thread/view/94082/30156019/excel-questionHello I wonder if anyone would be kind enough to help with an Excel formula problem.I have two columns over 2000 rows long and I want a formula that looks at column A and column B and says that if cell A1=B1 then count it. Same with cell A2=B2 and soAhh genius, finally figured out what you were saying, didn't really know anything about ARRAY. I'd seen it mentioned in the boxes when you click on the function button for various formulas but I just assumed it was a jazzy term for a load of cells. Ahttps://community.betfair.com/general_betting/go/thread/view/94082/30156019/excel-question?post_id=536902851#536902851Ahh genius, finally figured out what you were saying, didn't really know anything about ARRAY. I'd seen it mentioned in the boxes when you click on the function button for various formulas but I just assumed it was a jazzy term for a load of cells. ASat, 14 Dec 2013 02:35:47 -0600Hi guys, thanks for the responses. I don't know much about VBA so will have to investigate this but at least i have a bit of a starting point now.Cheershttps://community.betfair.com/general_betting/go/thread/view/94082/30156019/excel-question?post_id=536894737#536894737Hi guys, thanks for the responses. I don't know much about VBA so will have to investigate this but at least i have a bit of a starting point now.CheersFri, 13 Dec 2013 14:51:12 -0600I was attempting SUM(A1:A3000 = B1:B3000) in an array formula, but couldn't get therenice solution from Ghetto Joehttps://community.betfair.com/general_betting/go/thread/view/94082/30156019/excel-question?post_id=536888221#536888221I was attempting SUM(A1:A3000 = B1:B3000) in an array formula, but couldn't get therenice solution from Ghetto JoeFri, 13 Dec 2013 08:46:49 -0600Probably easier with VBA but as long as you know how to enter the data as an array you could use a simple formula like this to count any' duplicates in the range A1 to A3000, obviously change6 the cell references to what you need, the countblank bithttps://community.betfair.com/general_betting/go/thread/view/94082/30156019/excel-question?post_id=536888077#536888077Probably easier with VBA but as long as you know how to enter the data as an array you could use a simple formula like this to count any' duplicates in the range A1 to A3000, obviously change6 the cell references to what you need, the countblank bitFri, 13 Dec 2013 08:37:39 -0600this seems difficultsuper easy if you write a VBA function, but I wouldn't go there unless you were confident with macros.https://community.betfair.com/general_betting/go/thread/view/94082/30156019/excel-question?post_id=536887703#536887703this seems difficultsuper easy if you write a VBA function, but I wouldn't go there unless you were confident with macros.Fri, 13 Dec 2013 08:11:02 -0600Hello I wonder if anyone would be kind enough to help with an Excel formula problem.I have two columns over 2000 rows long and I want a formula that looks at column A and column B and says that if cell A1=B1 then count it. Same with cell A2=B2 and sohttps://community.betfair.com/general_betting/go/thread/view/94082/30156019/excel-question?post_id=536886505#536886505Hello I wonder if anyone would be kind enough to help with an Excel formula problem.I have two columns over 2000 rows long and I want a formula that looks at column A and column B and says that if cell A1=B1 then count it. Same with cell A2=B2 and soFri, 13 Dec 2013 06:07:03 -0600