column array

Hello, My file has company codes(CoCd) in col's and Profit centers(PC) in rows, with $'s assigned to them. I need to retrieve $'s specific to a PC and CoCd combination. Issue is sometimes same CoCds are in multiple columns. So can't do a simple sumif or Hlookup. E.g. B30 PC0001 B31 PC0002 B32...

Hello friends, a long time lurker-first time poster. This place has saved my *** on multiple occasions. Unfortunately, I have now spent days looking for a solution without much luck and felt compelled to ask my first question. The problem at hand is this. I have a list of employees (by ID) and...

Hi guys, I am trying to split an excel file with over 100 000 rows into different files based on the values in column A. In this case cases A2-A62 have value "1", cases A63-A89 "2", .., cases A120 569-A120601 "120". Row "1" includes headers for the columns. I am not very experienced with...

Good afternoon all, Background: I have a Spreadsheet that is the bane of my existence but it is the one of the most useful spreadsheet our staff has. It's an exception report that has 290+ Columns of data, 80 columns of Formula Calculations and can't/shouldn't be split up. The problem is...

I am looking for a way to transfer the data using a formula to accomplish this: <!--StartFragment--> <colgroup><col width="65" span="3" style="width:65pt"> </colgroup><tbody> A B C First x First Second Third Third x Fourth Fourth x Fifth...

Hi there, I am having a bit of a brain freeze and was hoping that someone may be able to help me. I am trying to write a VBA script that finds column "X" copies it across to column "X+1" and then pastes column "X" as values. The formula that I have in a helper cell for determining column X...

Hi, I come with a question involving excel VBA since I am no longer sure how I should proceed with this on Excel 2010. Right now I have : 1. a summary table that is summed from 2 different single cell columns 2. they come from different month worksheet (12 in total) 3. currently, there are...