|
|
Turn of 'Read Only' by
Barb
We have a spreadsheet that was created in 2003 and has been saved now as 2007
(*.xlsx). In 2003, we were able to request the spreadsheet to be opened as...
|
June 25th, 2009 04:20 PM
by Barb
|
2 |
106 |
|
|
|
June 25th, 2009 04:13 PM
by Eduardo
|
2 |
126 |
|
|
Track Changes by
Kanmi
How can i track changes by column made to a worksheet. I have list of data like
A B C
...
|
June 25th, 2009 03:59 PM
by Kanmi
|
0 |
101 |
|
|
|
June 25th, 2009 03:26 PM
by Stefi
|
6 |
78 |
|
|
Array formulas by
Lynda
I have taken over a workbook from a former work colleague. The workbook has a
spreadsheet with array formulas in it. I have never used array formulas
before...
|
|
3 |
153 |
|
|
Merge 2 datasheets into single Pivot Table. by
free_ur_mind
I use Excel 2003.
In a single Excel File, I have similar data in 2 different worksheets & I
need to combine them in a single Pivot Table. I cannot paste them...
|
June 25th, 2009 03:05 PM
by Eduardo
|
2 |
167 |
|
|
Woman age 40 by
Tony_student
Let's say one colomn is a list of different gender types (man, woman, man,
woman and so on) and another colomn a a list og ages (25, 35, 40, 35 and so
on)....
|
|
6 |
75 |
|
|
IF formula & formatting by
JD
I am trying to do a time sheet using the 24-hour clock. Here is a snapshot of
one day:
IN 8:00
OUT 17:30
LT 1:00
TT 8:30
ST 00:00
OT 00:00
|
|
8 |
117 |
|
|
DSUM using alpha numeric codes by
brian
using Excel 2007, I am having difficulty trying to dsum values where the
criteria is for greater than one alpha numeric code and less than another
alpha...
|
June 25th, 2009 01:47 PM
by brian
|
1 |
99 |
|
|
What If Scenario and/or Pivot Table by
eightandup
I need help and appreciate any provided. I need to run a ‘what-if’ and/or a
pivot table to find out the number of personnel needing to be hired based on...
|
|
0 |
70 |
|
|
Protected worksheet/tab key by
bev
I have a worksheet that I have protected but allow users to edit some cells.
In the protected mode the tab key doesn't function; only the arrow keys and...
|
June 25th, 2009 01:17 PM
by bev
|
2 |
99 |
|
|
|
June 25th, 2009 01:07 PM
by John P
|
7 |
128 |
|
|
Limit data entry in range of cells by
JStiehl
I have 6 columns with headings that repeat in a row. Users should make a
check under a maximum of 3 out of the 6 heading choices--is there a way to
restrict...
|
June 25th, 2009 12:08 PM
by JStiehl
|
2 |
88 |
|
|
Sports Tipping Formula! by
Mully
If your up for a challenge please have a go at this formula as I'm stumped
:eek:
If you can imagine there are a bunch of sports games played during the week,...
|
June 25th, 2009 11:57 AM
by Mully
|
1 |
73 |
|
|
Search by
backmara
Hi,
I have large ecxel-sheet and I try to find not selected data (not mach).
I mean if I have columns where is (A1)=A, (A2)=B and (A3)=C. I need to find
A...
|
June 25th, 2009 11:41 AM
by Joel
|
1 |
75 |
|
|
adding a zero in front of a colon by
303mike
Hello,
I am importing data into a worksheet (Excel 2002 SP3) that is minutes and
seconds. If the data is for one minute 27 seconds, it imports as 1:27. If it...
|
|
5 |
92 |
|
|
|
|
1 |
77 |
|
|
|
June 25th, 2009 05:51 AM
by Sheeloo
|
1 |
74 |
|
|
Change Chart Data by
KIOhio
Excel 2007. I do weekly reports including charts from an established four
page spreadsheet. It is very tedious to update the data ranges each week for
the...
|
June 25th, 2009 04:50 AM
by KIOhio
|
0 |
75 |
|
|
Countif Criteria Reference Cell by
StephonM
How can I use Countif to allow me to reference a cell that contains the area
codes of phone numbers to be counted? Below is my feble...
|
|
3 |
97 |