0helpful

1answer

In Excel Worksheet 2007 the maximum number of rows per worksheet is 1,048,576 and the no. of cols. is 16,384 which is col. XFD, which makes it 17,179,869,184 cells.

Jul 26, 2010 •
Microsoft Windows Vista Ultimate Edition

1helpful

1answer

Your camera is creating new folders and not continuing the number sequence resulting in duplicate numbers on different pictures. You need to use a card reader to download pictures to a folder you create on your desktop. Open the folder and examine the pictures. If you find different pictures but with the same numbers, you will need to manually rename them.

Sep 27, 2009 •
Kodak EasyShare P850 Digital Camera

1helpful

1answer

I don think u are in the right way to program the Matrix in C language, i found a lot of syntax error in your code, but nevermind i had correct it for u. Maybe still need a little correction for your own. Following code:

void matrix(int a[2][2],int b[2][2],int c[2][2]);

main()

{

int a[2][2]={{3,3},{4,4}};

int b[2][2]={{1,1},{2,2}};

int c[2][2]={0},i,j;

matrix(a,b,c);

printf("product of 2 matrix is");

for(i=0;i<2;i++)

{

for(j=0;j<2;j++)

printf(" %d",c[i][j]);

printf(" ");

}

}

void matrix(int a[2][2],int b[2][2],int c[2][2])

{

int row,col,sum1=0,sum2=0;

for(col=0;col<2;col++)

{

row=0;

sum1=(a[row][col]*b[row][col])+(a[row][col]*b[row+1][col]);

c[row][col]=sum1;

sum2=(a[row+1][col]*b[row][col])+(a[row+1][col]*b[row+1][col]);

c[row+1][col]=sum2;

}

}

void matrix(int a[2][2],int b[2][2],int c[2][2]);

main()

{

int a[2][2]={{3,3},{4,4}};

int b[2][2]={{1,1},{2,2}};

int c[2][2]={0},i,j;

matrix(a,b,c);

printf("product of 2 matrix is");

for(i=0;i<2;i++)

{

for(j=0;j<2;j++)

printf(" %d",c[i][j]);

printf(" ");

}

}

void matrix(int a[2][2],int b[2][2],int c[2][2])

{

int row,col,sum1=0,sum2=0;

for(col=0;col<2;col++)

{

row=0;

sum1=(a[row][col]*b[row][col])+(a[row][col]*b[row+1][col]);

c[row][col]=sum1;

sum2=(a[row+1][col]*b[row][col])+(a[row+1][col]*b[row+1][col]);

c[row+1][col]=sum2;

}

}

Sep 10, 2009 •
Intel Computers & Internet

0helpful

1answer

Yes, you would do a LOOKUP do display the row number.

LOOKUP(H53,A1:G1000,0)

LOOKUP(H53,A1:G1000,0)

Feb 18, 2009 •
Microsoft Computers & Internet

0helpful

1answer

You would have to combine the use of 2 functions. The Address and Match funbctions.

Lets say the number you want the address of is located in cell F1 and you have 2 columns of numbers. One colum in Column A and the other in column B. I will give you 2 formulas. The 1st one will return just the row number. The 2nd one will return the cell address.

Option 1: Lets say you just want to know the row reference of the number in cell F1. Place this formula in cell D1. =MATCH(F1,A1:A20)

If you have another column ytou want the row number of, place the formula in lets say cell D2 and change the column references from 'A' to 'B'.

Option 2: If you want the cell reference, place this formula in cell D1 and D2 instead of the firt formula.

=ADDRESS(MATCH(F1,A1:A20,0),1,1,TRUE)

And just like the first option, for the 2nd column, put the formula in D2 and change the column reference 'A' to 'B'.

Lets say the number you want the address of is located in cell F1 and you have 2 columns of numbers. One colum in Column A and the other in column B. I will give you 2 formulas. The 1st one will return just the row number. The 2nd one will return the cell address.

Option 1: Lets say you just want to know the row reference of the number in cell F1. Place this formula in cell D1. =MATCH(F1,A1:A20)

If you have another column ytou want the row number of, place the formula in lets say cell D2 and change the column references from 'A' to 'B'.

Option 2: If you want the cell reference, place this formula in cell D1 and D2 instead of the firt formula.

=ADDRESS(MATCH(F1,A1:A20,0),1,1,TRUE)

And just like the first option, for the 2nd column, put the formula in D2 and change the column reference 'A' to 'B'.

Feb 17, 2009 •
Microsoft Excel for PC

0helpful

1answer

The most common multidimensional array, the two dimensional array table, is
best presented to your users in row and column format. The grid control offers
a convenient way for you to display table data to your users. The users can
navigate the table's values using scrollbars. Therefore, the grid control does
not have to be as large as the table, because the grid control automatically
displays scrollbars.

To add the flex grid control to your toolbox, select**project** and **components**.
Add the flex grid control:

Once it is added, you will see the yellow flex grid control in your toolbox:

When you place the grid control on your form, you will have to resize it before the control takes on a tabular appearance. As you expand the size of the control, it does not look to much like a table. The problem is that the table's default number of rows and columns are two. To fix this problem, you must configure the rows and columns in the properties window:

The grid control supports fixed rows and columns. These refer to rows and columns in a grid control that do not scroll when the user clicks the scrollbars. The fixed rows and columns provides labels that describe the data. The fixed rows and columns are often called row and column headers.

When working with the grid control, much code is needed to provide the grid with functionality. Call statements are used to break the code required by the grid control into smaller, more manageable procedures. This is referred to as modular programming (which refers to the practice of placing code with a single purpose in a general subroutine procedure and then calling the code from a second procedure.)

Here is the code for the form load procedure (this example is based on the computer disk example used in the last lesson)

Private Sub Form_Load()

Call SizeCells

Call CenterCells

grdGrid.Row = 0

grdGrid.Col = 1

grdGrid.Text = "Single Sided; Low Density "

grdGrid.Col = 2

grdGrid.Text = "Double Sided; Low Density"

grdGrid.Col = 3

grdGrid.Text = "Singled Sided; High Density"

grdGrid.Col = 4

grdGrid.Text = "Double Sided; High Density"

grdGrid.Row = 1

grdGrid.Col = 0

grdGrid.Text = "3 1/2 inch"

grdGrid.Col = 1

grdGrid.Text = "$2.30"

grdGrid.Col = 2

grdGrid.Text = "$2.75"

grdGrid.Col = 3

grdGrid.Text = "$3.20"

grdGrid.Col = 4

grdGrid.Text = "$3.50"

grdGrid.Row = 2

grdGrid.Col = 0

grdGrid.Text = "5 1/4 inch"

grdGrid.Col = 1

grdGrid.Text = "$1.75"

grdGrid.Col = 2

grdGrid.Text = "$2.10"

grdGrid.Col = 3

grdGrid.Text = "$2.60"

grdGrid.Col = 4

grdGrid.Text = "$2.95"

End Sub

Notice how the form load procedure is used to populate the cells in the grid control. To control cell size and cell alignment, two smaller procedures are created and each procedure is called by the form load procedure.

Private Sub SizeCells()

Dim intColumn As Integer

grdGrid.ColWidth(0) = 1100

For intColumn = 1 To 4

grdGrid.ColWidth(intColumn) = 2200

Next intColumn

End Sub

Private Sub CenterCells()

Dim intColumn As Integer

For intColumn = 1 To 4

grdGrid.ColAlignment(intColumn) = flexAlignCenterCenter

Next intColumn

End Sub

Notice that the size and alignment procedures are only applied to columns 1 through 4. Column 0, which is a fixed column reserved for labels, is not formatted using either of the above two procedures.

Here is the final result:

To add the flex grid control to your toolbox, select

Once it is added, you will see the yellow flex grid control in your toolbox:

When you place the grid control on your form, you will have to resize it before the control takes on a tabular appearance. As you expand the size of the control, it does not look to much like a table. The problem is that the table's default number of rows and columns are two. To fix this problem, you must configure the rows and columns in the properties window:

The grid control supports fixed rows and columns. These refer to rows and columns in a grid control that do not scroll when the user clicks the scrollbars. The fixed rows and columns provides labels that describe the data. The fixed rows and columns are often called row and column headers.

When working with the grid control, much code is needed to provide the grid with functionality. Call statements are used to break the code required by the grid control into smaller, more manageable procedures. This is referred to as modular programming (which refers to the practice of placing code with a single purpose in a general subroutine procedure and then calling the code from a second procedure.)

Here is the code for the form load procedure (this example is based on the computer disk example used in the last lesson)

Private Sub Form_Load()

Call SizeCells

Call CenterCells

grdGrid.Row = 0

grdGrid.Col = 1

grdGrid.Text = "Single Sided; Low Density "

grdGrid.Col = 2

grdGrid.Text = "Double Sided; Low Density"

grdGrid.Col = 3

grdGrid.Text = "Singled Sided; High Density"

grdGrid.Col = 4

grdGrid.Text = "Double Sided; High Density"

grdGrid.Row = 1

grdGrid.Col = 0

grdGrid.Text = "3 1/2 inch"

grdGrid.Col = 1

grdGrid.Text = "$2.30"

grdGrid.Col = 2

grdGrid.Text = "$2.75"

grdGrid.Col = 3

grdGrid.Text = "$3.20"

grdGrid.Col = 4

grdGrid.Text = "$3.50"

grdGrid.Row = 2

grdGrid.Col = 0

grdGrid.Text = "5 1/4 inch"

grdGrid.Col = 1

grdGrid.Text = "$1.75"

grdGrid.Col = 2

grdGrid.Text = "$2.10"

grdGrid.Col = 3

grdGrid.Text = "$2.60"

grdGrid.Col = 4

grdGrid.Text = "$2.95"

End Sub

Notice how the form load procedure is used to populate the cells in the grid control. To control cell size and cell alignment, two smaller procedures are created and each procedure is called by the form load procedure.

Private Sub SizeCells()

Dim intColumn As Integer

grdGrid.ColWidth(0) = 1100

For intColumn = 1 To 4

grdGrid.ColWidth(intColumn) = 2200

Next intColumn

End Sub

Private Sub CenterCells()

Dim intColumn As Integer

For intColumn = 1 To 4

grdGrid.ColAlignment(intColumn) = flexAlignCenterCenter

Next intColumn

End Sub

Notice that the size and alignment procedures are only applied to columns 1 through 4. Column 0, which is a fixed column reserved for labels, is not formatted using either of the above two procedures.

Here is the final result:

Mar 26, 2008 •
Computers & Internet

0helpful

3answers

0helpful

1answer

Are you referring to the VLOOKUP function in Microsoft Excel?

I love vlookup!

Suppose you have 1 worksheet with song numbers and titles in Row 1, Cols A:B:

Song# Title

123 Love Me Tender

234 Blue Suede Shoes

345 Dixie

Another worksheet has song number and performer in Row 1, Cols A:B

Song# Performer

123 Elvis Presley

234 Carl Perkins

456 Cher

Notice there is NO performer for song number 345 in the 2nd worksheet.

Now in the 1st work sheet, cell C2 insert this LOOKUP function: =LOOKUP(A2,Sheet2!A:B)

Copy that cell to row 3 and row 4 in Col C. You should get a Performer for all songs even though there is not a song number 345 in the performer worksheet.

Help me out Mr. VLOOKUP.

Insert this VLOOKUP function in cell C2 of the first worksheet: =VLOOKUP(A2,Sheet2!A:B,2,0)

Copy that cell to row 3 and row 4 Col C. You should get the performer names for the 1st 2 songs, but not for 345 Dixie. The result should be #N/A.

That means VLOOKUP could not find a DIRECT match for song 345 in the second worksheet.

That is why I prefer VLOOKUP over LOOKUP.

I have found this explaination of the VLOOKUP parameters helpful:

1. Needle (A2)

2. Haystack (Sheet2!A:B)

3. RELATIVE Col containing result (2)

4. Need DIRECT MATCH ONLY (0)

Hope this helps.

I love vlookup!

Suppose you have 1 worksheet with song numbers and titles in Row 1, Cols A:B:

Song# Title

123 Love Me Tender

234 Blue Suede Shoes

345 Dixie

Another worksheet has song number and performer in Row 1, Cols A:B

Song# Performer

123 Elvis Presley

234 Carl Perkins

456 Cher

Notice there is NO performer for song number 345 in the 2nd worksheet.

Now in the 1st work sheet, cell C2 insert this LOOKUP function: =LOOKUP(A2,Sheet2!A:B)

Copy that cell to row 3 and row 4 in Col C. You should get a Performer for all songs even though there is not a song number 345 in the performer worksheet.

Help me out Mr. VLOOKUP.

Insert this VLOOKUP function in cell C2 of the first worksheet: =VLOOKUP(A2,Sheet2!A:B,2,0)

Copy that cell to row 3 and row 4 Col C. You should get the performer names for the 1st 2 songs, but not for 345 Dixie. The result should be #N/A.

That means VLOOKUP could not find a DIRECT match for song 345 in the second worksheet.

That is why I prefer VLOOKUP over LOOKUP.

I have found this explaination of the VLOOKUP parameters helpful:

1. Needle (A2)

2. Haystack (Sheet2!A:B)

3. RELATIVE Col containing result (2)

4. Need DIRECT MATCH ONLY (0)

Hope this helps.

Jan 07, 2008 •
Computers & Internet

0helpful

2answers

I love vlookup!

Suppose you have 1 worksheet with song numbers and titles in Row 1, Cols A:B:

Song# Title

123 Love Me Tender

234 Blue Suede Shoes

345 Dixie

Another worksheet has song number and performer in Row 1, Cols A:B

Song# Performer

123 Elvis Presley

234 Carl Perkins

456 Cher

Notice there is NO performer for song number 345 in the 2nd worksheet.

Now in the 1st work sheet, cell C2 insert this LOOKUP function: =LOOKUP(A2,Sheet2!A:B)

Copy that cell to row 3 and row 4 in Col C. You should get a Performer for all songs even though there is not a song number 345 in the performer worksheet.

Help me out Mr. VLOOKUP.

Insert this VLOOKUP function in cell C2 of the first worksheet: =VLOOKUP(A2,Sheet2!A:B,2,0)

Copy that cell to row 3 and row 4 Col C. You should get the performer names for the 1st 2 songs, but not for 345 Dixie. The result should be #N/A.

That means VLOOKUP could not find a DIRECT match for song 345 in the second worksheet.

That is why I prefer VLOOKUP over LOOKUP.

I have found this explaination of the VLOOKUP parameters helpful:

1. Needle (A2)

2. Haystack (Sheet2!A:B)

3. RELATIVE Col containing result (2)

4. Need DIRECT MATCH ONLY (0)

Hope this helps.

Suppose you have 1 worksheet with song numbers and titles in Row 1, Cols A:B:

Song# Title

123 Love Me Tender

234 Blue Suede Shoes

345 Dixie

Another worksheet has song number and performer in Row 1, Cols A:B

Song# Performer

123 Elvis Presley

234 Carl Perkins

456 Cher

Notice there is NO performer for song number 345 in the 2nd worksheet.

Now in the 1st work sheet, cell C2 insert this LOOKUP function: =LOOKUP(A2,Sheet2!A:B)

Copy that cell to row 3 and row 4 in Col C. You should get a Performer for all songs even though there is not a song number 345 in the performer worksheet.

Help me out Mr. VLOOKUP.

Insert this VLOOKUP function in cell C2 of the first worksheet: =VLOOKUP(A2,Sheet2!A:B,2,0)

Copy that cell to row 3 and row 4 Col C. You should get the performer names for the 1st 2 songs, but not for 345 Dixie. The result should be #N/A.

That means VLOOKUP could not find a DIRECT match for song 345 in the second worksheet.

That is why I prefer VLOOKUP over LOOKUP.

I have found this explaination of the VLOOKUP parameters helpful:

1. Needle (A2)

2. Haystack (Sheet2!A:B)

3. RELATIVE Col containing result (2)

4. Need DIRECT MATCH ONLY (0)

Hope this helps.

Oct 10, 2007 •
Microsoft Office Standard for PC

0helpful

3answers

I love vlookup!
Suppose you have 1 worksheet with song numbers and titles in Row 1, Cols A:B:
Song# Title
123 Love Me Tender
234 Blue Suede Shoes
345 Dixie
Another worksheet has song number and performer in Row 1, Cols A:B
Song# Performer
123 Elvis Presley
234 Carl Perkins
456 Cher
Notice there is NO performer for song number 345 in the 2nd worksheet.
Now in the 1st work sheet, cell C2 insert this LOOKUP function: =LOOKUP(A2,Sheet2!A:B)
Copy that cell to row 3 and row 4 in Col C. You should get a Performer for all songs even though there is not a song number 345 in the performer worksheet.
Help me out Mr. VLOOKUP.
Insert this VLOOKUP function in cell C2 of the first worksheet: =VLOOKUP(A2,Sheet2!A:B,2,0)
Copy that cell to row 3 and row 4 Col C. You should get the performer names for the 1st 2 songs, but not for 345 Dixie. The result should be #N/A.
That means VLOOKUP could not find a DIRECT match for song 345 in the second worksheet.
That is why I prefer VLOOKUP over LOOKUP.
I have found this explaination of the VLOOKUP parameters helpful:
1. Needle (A2)
2. Haystack (Sheet2!A:B)
3. RELATIVE Col containing result (2)
4. Need DIRECT MATCH ONLY (0)
Hope this helps.
Let me know if you have any questions.

Aug 27, 2007 •
Microsoft Office Standard for PC

58 views

Usually answered in minutes!

×