|
|
Counting 3 columns? by
Owen
I have 3 columns with different text values. I want to know the # of times
col a = texta, and col b=textb and colc = text c - how do I do this in excel?
|
November 9th, 2009 01:01 AM
by JLatham
|
2 |
122 |
|
|
Counting ? by
Owen
I have a spreadsheet with 3 columns - I want to know the number of times col
A = texta, and col b = textb and col c = text c. how do I do this in excel?
|
|
1 |
116 |
|
|
CountIf formula by
Verne
I am using a count if formula =COUNTIF(P2:P25,"x") - everytime I add a new
row, that row is not included in the formula. What can I do so it is
included....
|
|
4 |
166 |
|
|
formulas by
Cazza
Hi.
I'm hoping someone can understand what I am trying to do and point me in the
right direction of where I can learn to do it.
I want to have a 2 sheet...
|
|
2 |
114 |
|
|
Number format TextBox? by
hoyos
How do I number format this code to read ("###0")
..Range("J188") = .Range("J187").Value
|
November 9th, 2009 12:04 AM
by hoyos
|
2 |
140 |
|
|
printing setup issue in 2007 by
Zhi Sheng
while in 2003, if i select multi tabs(sheets), set the printer to print on
both sides, and in "print what" area choose "active sheet(s)", all tabs will
be...
|
|
1 |
126 |
|
|
printing setup in excel 2007 by
Zhi Sheng
while in 2003, if i select multi tabs(sheets), set the printer to print on
both sides, and in "print what" area choose "active sheet(s)", all tabs will
be...
|
|
0 |
178 |
|
|
printing setup in excel 2007 by
Zhi Sheng
while in 2003, if i select multi tabs(sheets), set the printer to print on
both sides, and in "print what" area choose "active sheet(s)", all tabs will
be...
|
|
0 |
118 |
|
|
printing setup issue in 2007 by
Zhi Sheng
while in 2003, if i select multi tabs(sheets), set the printer to print on
both sides, and in "print what" area choose "active sheet(s)", all tabs will
be...
|
|
0 |
135 |
|
|
Find Cut and paste by
kingie
Hi,
I have a large amount of data containing unique codes.
I want to type in a list of codes and the program to find them in worksheet
1 Cut and paste it...
|
November 8th, 2009 09:33 PM
by kingie
|
4 |
123 |
|
|
User Defined Functions by
MoTrekker
I imported a Excel 2003 spreadsheet with UDFs and the UDFs are not found.
Additionally, I have tried to rebuild the UDFs in 2007 and I can't get the...
|
|
2 |
146 |
|
|
Different cells that need to sum in one by
Cbdavis
I have one cell that needs to contain the possible sum of cell
(A1*B1) or (C1*D1) or (E1*F1) but only one of the 3 possibles
For example :
A1 is $10.00 B1...
|
November 8th, 2009 04:10 PM
by Cbdavis
|
4 |
152 |
|
|
Deactivating a macro button by
Victor Delta[_2_]
I have a macro in a spreadsheet which is linked to a toolbar button in the
usual way.
Is there any way please that the button can be deactivated (and if...
|
|
2 |
132 |
|
|
Jululian Excel by
George A. Jululian[_2_]
Hi all,
i have table as below
A B C D E F G
Date Retail car Fleet Car Total car Retail turck Fleet Truck Total Truck
Colunm A date from January...
|
|
3 |
123 |
|
|
Excel Function by
Nasr Mostafa
Hi What is the formula to get the following
Mark Points
90 & more 4
85 & less 90 3.7
82.5 & less 85 3.3
77.5 & less 82.5 ...
|
|
1 |
102 |
|
|
How do I lock certain cells in excel 2007? by
Dr Alok Modi MD
My query is as follows :
I have created an excel sheet that automates the billing procedure of my
hospital. It has multiple complicated formulas that i have...
|
|
1 |
114 |
|
|
Header in row to column by
Venice
I have the following data:
Row 1 has 3 columns that is B1 = Opening, C1 = Spent, D1 = End balance. From
E1 to G1 it has the same header. Every 3 columns has...
|
|
1 |
114 |
|
|
Sort data in rows to column by
Venice
I would need to re-arrange the format of the data. My current data is:
In row 1, every 3 columns has headers Opening, Spent, End balance (ie A1 is
Opening, B1...
|
|
1 |
121 |
|
|
|
November 8th, 2009 06:23 AM
by FSt1
|
4 |
197 |
|
|
|
|
5 |
173 |