|
|
Sum with a slash "/" by
Freshman
Dear experts,
I've columns in a workbook which, for an example, in a cell wrote as
"20/79". The users meaning is 20 persons order 79 tickets. As there are...
|
|
6 |
113 |
|
|
Macros and security by
Zita
I have check boxes in my excel sheet.
When I click a box and save as (I think enabeling macros), the next time I
open it, I cannot change the check unless I...
|
January 15th, 2010 07:26 PM
by Zita
|
0 |
77 |
|
|
Format date in header by
Sammie
I use the date button to insert the date in the spreadsheet header & ,
and I want to change the format of the date from 1/15/2010 to January 15,
2010. How...
|
January 15th, 2010 07:16 PM
by Eduardo
|
4 |
108 |
|
|
|
|
3 |
102 |
|
|
Counting current streak by
Renan Germano
Hello! I have a table with the results of each team?s recent games. In column A are the game dates, and in each other column is a team name (B1,C1,D1..). In...
|
January 15th, 2010 06:55 PM
by Luke M
|
6 |
135 |
|
|
Mark Up by
Egg Harbor
I want to calculate a marked up price on an item. IE 15%, 25% etc.
If $100.00 is marked up 15%, the selling price is $117.65
|
January 15th, 2010 06:52 PM
by Eduardo
|
4 |
90 |
|
|
|
January 15th, 2010 06:39 PM
by Luke M
|
2 |
86 |
|
|
Reading Multiple Files by
BadBoy
Good Morning,
I have a data base titled 'DISTRICT YEARLY ROLL-UP'.
This data base looks in a folder called 'NORTH BAY TIMMINS' for the name
'MARTIN114' and...
|
January 15th, 2010 06:26 PM
by BadBoy
|
5 |
87 |
|
|
IF in formula by
Denise
Help...I'm tired of trying different formulas and none are working...
I'm looking for a formula to do the following, with 9 employee names
possible in one...
|
|
1 |
92 |
|
|
|
|
2 |
92 |
|
|
Need help with formula by
Connie Martin
I am trying to adapt a formula in I2 from another spreadsheet that works
well, but won't in mine. I've traced the error, but I would need help to
understand...
|
|
8 |
118 |
|
|
Simple Count of certain cells by
JPDS
Whats the simplest way of counting how many times certain letters appear in a
list?
In cells A1:A2000, I have Ethnicity codes with singular letters A-Z, I...
|
January 15th, 2010 02:45 PM
by JPDS
|
7 |
86 |
|
|
If by
Trace
How do I get a return of 1 in column B for all numbers in column A that are
greater than 0?
|
January 15th, 2010 02:37 PM
by Eduardo
|
2 |
66 |
|
|
conditional formatting in excel 2007 by
Lofty
I have a table of 90 rows with names in column 1 followed by 6 cloumns of
numbers.
i.e.1 Alan 8 11 23 38 42 48
2 Dave 6 8 13 24 40 43
and so...
|
January 15th, 2010 02:16 PM
by Luke M
|
1 |
80 |
|
|
|
|
6 |
134 |
|
|
Vlookup in multiples columns by
Trainer
I have the following simple spreadsheet. I'm tryping to use VLOOKUP to find
the rate of pay based on the Job Type and the Hourly Pay which refers to a
table...
|
|
1 |
106 |
|
|
|
|
1 |
94 |
|
|
|
January 15th, 2010 04:21 AM
by Leung
|
1 |
129 |
|
|
|
|
2 |
106 |
|
|
If Statement by
tss
Need help with this formula?
Need to calculate a formula for CELL A based upon the following
IF CELL B = STOCK and CELL C = 1.0, 25.0 THAN CELL D * 4
|
January 15th, 2010 01:45 AM
by Pete_UK
|
4 |
86 |