|
|
Excel Reports by
ABC123
Hello all,
Please note that I have ben asked to create a spreadsheet that will
generate a report for staff working in a call centre. The basic form
is as...
|
|
3 |
107 |
|
|
Formula question by
Scoober
I am trying to complete the following.
In s141 i have a drop list with 'yes' and 'no' as possiblities.
In x141 i have a drop list with 3 possible choices, ...
|
March 3rd, 2010 02:49 AM
by FSt1
|
2 |
93 |
|
|
|
March 3rd, 2010 01:55 AM
by FSt1
|
2 |
133 |
|
|
|
March 3rd, 2010 01:47 AM
by FSt1
|
1 |
1,177 |
|
|
Total for Cells with same name value by
msnyc07
I am sure I've done this before. somehow it alludes me all of a sudden;
I have a table with
ProductName | Amount Sold
Where Product Names can...
|
March 3rd, 2010 01:42 AM
by FSt1
|
1 |
122 |
|
|
Timecard functions and formulas by
Steve[_90_]
I have made a timecard with excel everything is working as planned except for
one thing. I am unable to get the roper formula or function to calculate my...
|
|
1 |
122 |
|
|
|
|
6 |
95 |
|
|
Formula Help by
mahlandj
I need to find how many times Dan occurs in a certain month. Example Below.
A B
1 1/2/10 Dan
2 ...
|
|
2 |
94 |
|
|
|
|
1 |
87 |
|
|
|
|
1 |
97 |
|
|
Finding a value by
jkrons
I have this formula:
=OFFSET(INDIRECT(ADDRESS(MATCH(MAX(B1:B26),B1:B26,0),2)),0,-1)
It looks up the value one cell left of the largest value in B1:B26,
and...
|
|
4 |
140 |
|
|
|
March 2nd, 2010 09:21 PM
by Mike H
|
5 |
126 |
|
|
Conditional Formatting using Small by
Supe
I have 9 columns and 52 rows that that have pricing for 9 brands for each
week of the year. There may be some weeks where a brand as $0.00 as a price.
I am...
|
|
1 |
102 |
|
|
|
|
0 |
92 |
|
|
|
March 2nd, 2010 08:29 PM
by Mike H
|
1 |
92 |
|
|
|
|
4 |
95 |
|
|
concatenate by
joe
I am trying t convert 2 cells, but i only want to merge if the total
characters does not exceed 70 characters, can anyone help me with a formula
for that?
|
March 2nd, 2010 08:06 PM
by Mike H
|
4 |
102 |
|
|
Blank space by
Dinesh
I have big database of customers and have blank space beoire the customer
name start. How can i remove it in bunch?
Dinesh
|
|
5 |
100 |
|
|
Excel Sheet tab names by
Carl
I am making a program in excel for some time cards then workbook starts with
sheet one to change the date next sheet has the list of names with all the
info...
( 1 2)
|
March 2nd, 2010 07:18 PM
by Billns
|
13 |
282 |
|
|
Automic allocation of numbers by
Ujpest
The numbers represent rounds.
So a name will go with a round (number) but some names know more than one
round.
Name a 1
name b 2
name c ...
|
March 2nd, 2010 06:55 PM
by Ujpest
|
0 |
80 |