I've vertically data in each cell like this.
A1 john
A2 sam
A3 robin
A4 xxx
A5 xxx
A6 yourself
A7 xxx
A8 no need
So on..... in very large amount.
But need substitution here.
I dont want "xxx".
I mean I need data in B row vertically but like this.
B1 john
B2 sam
B3 robin
B6 yourself
B8 no need
Please suggest any formula for the "B" cells.
I am trying to get my data to be visualized on a monthly basis. A Pivot Table works perfectly in getting the right arrangement, except that it performs a calculation in the values summary field. Is there a solution that allows the Pivot Table to plop the actual text values that it is pulling from? Maybe Excel Pivot Tables aren't the right solution, so maybe another type of software might be useful? Or perhaps a change in the VBA script? The original table looks like this:
ID Description Date Code Building
10223 Package/Split 02/01/2015 ALRM1 A
10223 Package/Split 02/01/2015 PLMB1 A
10992 Pump Test 03/13/2015 ALRM1 B
10992 Pump Test 03/13/2015 PLMB1 B
10992 Pump Test 03/13/2015 ALRM1 B
11432 Inspection 03/13/2015 ALRM1 C
The way I would like for it to look is this:
January February March
Building ID Description Building ID Description Building ID Description
A 10223 Package/Split B 10992 Pump Test
C 11432 Inspection
In the original report, there can be multiple codes for the same ID (ALRM1 and PLMB1 for 10223). In such cases, Pivot Table works by summing up the values, therefore displaying the ID in just one row. I would like for it to do the same thing (spit a multiple row ID as one row) but display the actual text values of Building, ID, and Description as shown. I don't need the code in the table, but it's there in the original data simply to differentiate between the two IDs.!
I have a problem regarding making a report in excel.
My problem is :
I have a excel file where columns are
Collapse | Copy Code
S.no. Date. From To Mode_of_Transport Depart. Arrival NameRemarks
So my job is to find the persons who arrived at interval of 30 min so that vehicle can be arranged for them.
I have a range of cells that have text formatted in the following way;......
I need to change the arrangement of the cells so that the Brackets and numbers appear in the cell before the text, how can I achieve that? Poor example but each cell will only contain one of the above variants, not all of the variants.
Designing a Random Seating Arrangement
I have been given a Task of Designing a layout for seating arrangement for an Exam....
I would know the Total Number of Students appearing for the exams and their respective roll nos...
I would also be given the No of Rows and No of Columns that can be accomodated in the Examination Hall to form a Matrix...
Considering that I have around 65 students appearing for the exam and there are 10 Rows and 7 Columns to accomodate students in excess of 65..
So I need to have a mechanism which can give me the Roll Nos allocated from 1 to 65 randomly in the Matrix...in such a way that the Roll Nos don't get repeated as well as they are not in series next to each other...
In Deciding the Size of Matrix providing the No of Rows and No of Columns if possible...
Ex:-
Lets say Sheet1, Column A has a Heading Roll No and all the Roll Nos from 1 to 65 and Column B has all the Names..
Then I would like to have a code which can generate the Matrix Size in C2 which captures from the Max(A:A) and a Matrix Generated in the Sheet2 from the Starting Point being cell B2 till end...as the cell A1 would contain text as Row/Column and from cell $A2 till end will display Row Nos i.e. Row-1,Row-2,Row3 etc.. and cell B$1 and the entire 1st Row would have headings as Column-1,Column-2,Column-3 etc..
Is this possible as these exams are held every week and its a tedious task to Manually design a Random Seating arrangement as well as the Matrix...
I want to change arrangements of cell by using macro
A
B
C
1
Code
C1
C2
2
Dr2890
2150
2670
[Code] .........
I'm at an impass and need some help please. I'm trying to create a spreadsheet that will look up UNSORTED data in Column A and return the value of the corresponding Row data in the adjacent column. Can this be done? It is my understanding that LOOKUP functions only work with sorted, ascending data, but this is not possible with the data I'm trying to analyze.
(eg. COLUMN A - contains unsorted list of names
COLUMN B - contains numbers indicating skill level of the person in the next column
I need the formula to look at column A, pick out "Joe Smith" and return the number value from COLUMN B)
If is there a way to get more styles or increase the colour schemes for the charts.
View 2 Replies View Related