Convert Frequency Table To Vector?
Jul 4, 2013
I have a large frequency table, the dataset looks like:-
Category Age Frequency
A 1 4
A 2 3
A 3 2
B 7 1
B 8 3
C 4 2
C 6 4
I would like a formula to get:
A B C
1 7 4
1 8 4
1 8 6
1 8 6
2 6
2 6
2
3
3
View 3 Replies
ADVERTISEMENT
Dec 18, 2007
I'm looking for a way to automatically convert a list of values into a matrix.
For example,
A1A11000
A1A2998
A1A3468
A1A4491
A2A1998
[Code] .......
should be converted to
A1A2A3A4
A11000998468491
A29981000464488
A34684641000992
A44914889921000
In this case it could still easily be done manually, but if the matrix has more dimensions it will get harder.
View 5 Replies
View Related
Dec 21, 2012
I am wondering if there is a way to drag a formula, for instance, down, and each cell that I drag down, it references one cell to the right.
Excel Example.png
I attached a photo -- I understand that this is an overly simplified example, but the idea is that it would reference the row as you drag down the column.
View 4 Replies
View Related
Oct 22, 2009
I explained my request in detail inside the attached WB.
View 6 Replies
View Related
Mar 8, 2009
I am looking to find the frequency of times 1 number appears with another number in a row in a table
Click here for an example
or see the attached spreadsheet. I included the excel 2007 and 2003 versions.
View 6 Replies
View Related
Jun 29, 2007
how to make a frequency table and a bar chart for 6 different branches of industries. These categories have numbers (1 for branche A and 2 for Brance B and so on) I tried Tools > Data analysis > Histogram yet. But then the categories are displayed as numerators. I just want to show how many companies there are in Branche A, Branche B, etc. I tried to change the categories into text, but it wont make a difference. I will include the file.
View 3 Replies
View Related
Dec 18, 2008
I want to insert a frequency column in my pivot table. See frequency.jpg for an example.
The column has to count the number of times "artikel" is represented in the pivot. Is it possible to do this in a pivot table, and if so, how?
View 9 Replies
View Related
Mar 27, 2012
I have a very large excel data file, which I want to analyse using pivot tables. The problem is that while most of the columns are headed with the variable name (e.g. country) and have the list of variables displayed under that heading for each observation (e.g. Italy), the years are spread across the columns - i.e. the heading for column X is not "Year", but is 2003, with the next column being 2004, etc.
Is there a quick way I can re-arrange the data so that the layout is consistent and so that I can use it for pivot tables? I have way too many observations to do this by hand.
View 1 Replies
View Related
Sep 11, 2009
Is there a function to convert the data shown in table 1 to table 2 without rearranging the columns and rows? because i don't want to use TRANSPOSE. I want a function, somthing like SUMIF with OFFSET or INDEX and MATCH or any other function.
Table 1
Team 1Team 2Team 3Team 4Team 4Team 5Team 5ABABCity 12531642City 231173705City 367891125City 436251348
Table 2
City 4City 2City 1City 3Team 4BTeam 2Team 5ATeam 4ATeam 1Team 3Team 5B
View 2 Replies
View Related
Nov 2, 2009
I have received a database containing listings of products and their sales, by month (see left side of attached file). What I actually need is to have this table converted (transposed) into a “flat database” which I can later manipulate with a pivot table (see desired output on the right side of the attached file). In the attached file I have drafted the desired output format of 1 line from the raw table, which I would like to get.
What I am looking for (if I might be so bold and ask) is a macro that will allow me to have a simmilar result for ALL the lines (there can quite a few). I think this output format can be achieved with a few simple loops, probably nested, but unfortunately I was not able to find the right sequence (being a novice in VBA).
I have tried to find the answer here, between all the posts regarding “transpose” but couldn’t find something that looked (to me) as containing a relevant solution.
View 2 Replies
View Related
Jan 31, 2013
I want to find a number in my array and return the value in column A. Trouble is if the array goes past column R I get the wrong Answer. the formula I am using is
=LOOKUP($C$22,$B$2:$AC$18,$A$2:$A$18)
Some cells are blank I am trying to draw a raffle.
Here is my data and formulas below:
The lookup of value 209 produces correct results when I look up as far as column R after that I get the wrong answer.
A
B
C
D
E
F
G
[Code] ....
View 2 Replies
View Related
Nov 10, 2009
I am looking up values L, M, and S from a seperate worksheet based on two factors. age in months, and gender. I have read enough to figure out how to lookup values L,M,S one at a time using a vectorlookup, from one worksheet to another. However, the LMS values being looked up are for females only. I know I must get the gender codes worked in but not sure how to work this in.
I don't know if I need an and If function, to meet the gender (1male, 2 female) or what.
View 11 Replies
View Related
Apr 9, 2008
I want to use the V lookup function to return a value, but rather than returning the value in the same row as the match in the specified column, I want to return the value in the cell below.
Eg.
=VLOOKUP(B397, A$267:H$351, 7, FALSE)
... but rather than returning the value in column 7 on the row that matched with B397, I want the field below.
View 9 Replies
View Related
Apr 24, 2007
I have = LOOKUP(REPT("z",255),CHOOSE({1,2},"",LOOKUP(C3,{1,2,3},{2,1,0}) )) in cell D3. C3=1 so I expected a result of D3=2. Instead I am getting a blank cell.
View 4 Replies
View Related
Oct 1, 2007
I am running a fairly complex simulation at work and have quite a few different functions in it. For the simulation to work properly, i need to have the Solver add-in and the Analysis ToolPak installed. Everytime that i try and use the simulation on a different computer (or if anyone else tries to run it) the add-ins must be enabled again. Is there a way to set up a macro to enable them when either i open the simulation (first preference) or when a button is pressed (2nd preference).
View 2 Replies
View Related
Dec 24, 2009
Is there a way to use the lookup function in reverse? The "lookup vector" on mine has to be descending, that is it it is a column going from high values at the top of the page to lower values at the bottom of the page. When using lookup function in this setup, excel gives me to wrong answer for some reason. If I make the lookup vector ascending, it works, but unfortunately the vector has to be descending in my worksheet.
View 2 Replies
View Related
Aug 27, 2009
I am trying to convert a table into three columns so that I can use the data in a vlookup.
View 8 Replies
View Related
Mar 4, 2013
I am doing a literature review and at the moment I have a table where I am listing all articles and ticking of their "theme", "theories used" and "methodology" like this:
How_do_I_get_from-this.jpg
Now I need to map the theories onto the articles, like this:
to_this.jpg
How do I accomplish this? (in an automated manner, obviously)
I hope the pictures are sufficiently self-explanatory, it is kind of hard to explain what I am trying to achieve otherwise. Note that ticking boxes is accomplished by changing the font to wingdings 2 and using uppercase P for checking a box. I know there are real checkboxes for this purpose, but I am generating the table from imported data and can't find another way to program excel to tick boxes if a condition evaluates to true.
Go to this link to download the original file: [URL] ....
View 2 Replies
View Related
Dec 5, 2013
How do i consistently convert a PDF table to Excel? When in the PDF i am recognizing the text and then trying all available ways to either copy or export the selection (to all available file types!) but it only works in a usable manner about 10% of the time....
View 5 Replies
View Related
Jun 4, 2014
I need to convert a Matrix to a Table. Something like this:
Input file:
Capture1.PNG
Output :
Capture2.PNG
View 4 Replies
View Related
Jun 14, 2012
I have three columns of data starting in row 5, the headers of these columns show Origin, Destination and mileage. Is it possible to have a macro that converts the data into a table?
View 2 Replies
View Related
Jun 3, 2014
I am trying to convert a table into a list, please see the example, I want to convert this table
10547
aaa
140x200
160x230
300x400
10549
bbb
140x200
150x260
[Code] ........
View 1 Replies
View Related
Sep 18, 2008
I need to convert this kind of table to a list (like in below example)
Can someone give me an instruction or macro to do this ?
Table
X Y Z
A 3 5 7
B 2 4 6
C 8 9 10
List
Column1 Column2 Column3
A X 3
A Y 5
A Z 7
B X 2
B Y 4
B Z 6
C X 8
C Y 9
C Z 10
View 9 Replies
View Related
Jul 13, 2007
In the attached file you'll find an original table and the requested Table in its new layout. I thought to use TRANSPOSE in an Array- Function but it didn't work as expected. However, I managed to present the DATA (light green range) with the help of SumProduct. My Question goes like this: Is there a way to present the Upper and Left Headers (in red font) with Formulas ?! (I typed them by hand).
View 2 Replies
View Related
Jan 23, 2014
I have a table with Companies in a column and Countries in the heading row. Now in this table I have an entry "1" against certain countries for each company.
I need to get a concatenated (Company&Country) list, but I need this is all in a single column.
Companies list.xlsx
View 2 Replies
View Related
Aug 21, 2014
I have a table in Sheet1 and it's about of student's name, lessons and class.
I want to create a macro which convert to all data like Sheet2.
View 2 Replies
View Related
Dec 22, 2009
Need to fit my raw data (Raw Data Sheet) to fit my table template.
Need to convert my daily data to weekly to fit to my table template.
Please see attached file for reference.
View 6 Replies
View Related
Sep 26, 2012
How can I convert the top dataset to the bottom dataset?
Row Labels
2011.13
2011.14
2011.15
[Code].....
View 6 Replies
View Related
Feb 1, 2006
I've posted an example workbook that has sheet1 as how the data comes and sheet2 as what I need it to look like (through some kind of automatic process). I really don't have a clue as to how to get this done, and I'm guessing some VBA is going to be required.
View 3 Replies
View Related
Oct 9, 2007
I would like to convert the data by VBA macro from a table format into a list format. The convention of the TABLE data is as follows:
First row is Header Titles
[TABLE]
[SITE],[LOC],[PROD], [MTH1], [MTH2], to ->[MTH12]
North, Office, Cooling, 100, 125, 85
[/TABLE]
I would like the data to be provided into a list format for each month.
For example:
[TABLE]
Row 1: North, Office, Cooling, Month 1, Value
Row 2: North, Office, Heating, Month 1, Value
Row 3: North, Office, Electricity, Month 1, Value
Row 4: North, Retail, Cooling, Month 1, Value
Row 5: North, Retail, Heating, Month 1, Value
Row 6: North, Retail, Electricity, Month 1, Value
etc
[/TABLE]
View 7 Replies
View Related
