|
|
Excel Preview by
TC
Does Excel have a preview pane (document map) on the left like in Word ?
|
|
1 |
215 |
|
|
simple question about excel by
Μανολης Β
I have an excel list with 300 names. Each name and surname are both written
to the same cell (eg. "George Smith"). However i want name and surname be in
2...
|
November 18th, 2009 10:13 AM
by Stefi
|
5 |
232 |
|
|
|
November 18th, 2009 10:11 AM
by Niniel
|
2 |
248 |
|
|
|
|
3 |
219 |
|
|
IF function by
Phil
Can I use the "if" function to determine if a cell contains a value that is
"greater than 1 but equal to or less than 5"?
eg....
if b4 1 =5
IF TRUE....
IF...
|
|
4 |
282 |
|
|
|
November 18th, 2009 05:51 AM
by Hemi
|
2 |
321 |
|
|
military time calculations by
NedG
I am trying to write a program that tracks time entries in "Military time"
and then average multiple entries, that cover a 24 hour cylcle for three
shifts. ...
|
|
2 |
271 |
|
|
|
|
5 |
247 |
|
|
trouble in copy pasting by
Suri
HI,
I was trying to copy the formula in one cell toanother.
Eg: Copy formula "=T157*H157" in cell c5 in to cell C6.
When i drag the formula from cell C5 to...
|
November 18th, 2009 04:06 AM
by Suri
|
3 |
272 |
|
|
dividing a number into hours and minutes by
ramona
My users are entering numbers into column B. Is it possible to take the
total of column B (say Row X) and divide it into hours and minutes putting
the hours...
|
|
1 |
240 |
|
|
Lock sheets automatically by
Thu Ng[_2_]
Hi everyone,
I have 26 fortnightly timesheets in a workbook for every staff and would
like to lock each timesheet after some days.Can you please help me to...
|
November 18th, 2009 02:16 AM
by JLatham
|
2 |
227 |
|
|
|
|
0 |
252 |
|
|
Table formula optimization Question by
urlocaljeweler
I have a spreadsheet (.csv) with 1600 products/rows and several columns. One
of the columns that has the product descriptions also contains 1600 rows. In...
|
|
0 |
248 |
|
|
Summary of data using array formula by
Smitee2006
I have a spreadsheet where there are several columns with data using
validation picklists as well as free-entry columns. I would like to create a
summary of...
|
|
1 |
231 |
|
|
Move data from mulitple tabs to one sheet by
Supe
I have about 60 tabs that have the item UPC, dollars, and units for 60
different vendors. Is there a way to move the data from these tabs onto one
sheet...
|
|
2 |
279 |
|
|
Data arranged in calender format by
Chris
I'm being asked to summarize and show data in a calender view. Does anyone
know how to accomplish this without having to copy and paste each time? Is
there...
|
November 17th, 2009 09:59 PM
by Pete_UK
|
1 |
256 |
|
|
Count if using multiple date criteria by
GPearson
Hello:
I am working on a spreadsheet that records inventory. I need to create a
formula that counts if any items were completed late by a person . The...
|
November 17th, 2009 09:30 PM
by GPearson
|
4 |
264 |
|
|
Auto sum 2 adjacent row data into 3rd row? by
Tacrier
I have a list of people's names in column C and cost data for each person in
column M and N.
Is there was to provide a subtotal of all cost data for each...
|
|
1 |
219 |
|
|
|
November 17th, 2009 09:10 PM
by CG Rosen
|
4 |
215 |
|
|
|
|
7 |
183 |