matrix in range

<tbody> Weight From Weight To Weight Category Route 1 Route 2 Route 3 Route 4 Route 5 0 30 1 43 20 35 28 41 30.01 50 2 43 20 35 28 41 50.01 75 3 52 25 40 35 49 75.01 100 4 55 29 43 39 53 </tbody> Hi there, I’m trying to work out a formula to...

I have a matrix with a lot of blanks. I need to convert them with a matrix formular to a single column with no blanks. Can anyone help? Thanks in advance, Andrew

hello experts, i have a question, i never used advanced formulas in excel. Hope you guys will help me. I want to make a matrix like table (below) from the raw data table my answer table is this <tbody> <colgroup><col><col span="5"></colgroup><tbody> ABC XYZ JKD ASD ABD james 1 1...

I am looking for a Macro that will make the process in the document as simple as possible. Its currently a lot of manual work and I would like to automate the process. The document involves a two tables in a Matrix form input Volumes and Budget and an out Actuals. In the same document we have...

we have an interesting formula to figure out. First, we count the following, where MYDATE needs to fall between the two dates. REGISTER.DT and EXIT.DT are both named ranges A:A and B:B, MYDATE is a named range that points at C1 =SUMPRODUCT(--(REGISTER.DT<=MYDATE)*(EXIT.DT>=MYDATE)) Now for...

Hello, My objective is to select specific positions in a moving matrix of a fix range with VBA for Excel 2003. The fix range is about 5 or so columns wide and has a few thousand rows. I select a matrix of 5 to 7 rows and the same number of columns as range. I then choose a specific position...