- Nov 18 Sat 2006 20:10
Parsing Cells with embedded returns
- Nov 18 Sat 2006 20:10
More than calculations in time
I have set up a time sheet and want the minimum time taken at lunch to show
no less than 30 minutes. At present there are start and finish times for
- Nov 18 Sat 2006 20:10
Summing values if conditions are true
Hello, I am fairly new to advanced excel functions. I have a question that
may require multiple steps. I will describe my issue as simply as I can.
- Nov 18 Sat 2006 20:10
Entering combos without converting it to dates?
I am trying to enter locker combinations in an excel spreadsheet. However,
excel keeps converting these automatically to calendar dates. How do I turn
- Nov 18 Sat 2006 20:10
Simultaneously updating Charts in Multiple sheets
Have a spreadsheet with 12 tabs.
Each tab has 12 line charts based on a specific group.
- Nov 18 Sat 2006 20:10
Multiple IF amp; VLOOKUP functions
This formula below works as shown
=IF(D10=0.5,(VLOOKUP(I10,Table_A,2,0))). the result is shown in 'J10'
- Nov 18 Sat 2006 20:10
Excel 'Special' Characters in Expressions
I have a need to be able to create a funtion/expression that can issue a
'hard carriage return amp; line feed'. On the keyboard this would be 'Alt'
- Nov 18 Sat 2006 20:10
How can SUM use cell references in other cells?
I will be given a list of numbers (starting in A1) together with the number
of numbers in the list given in B1. I would like to be able to write
- Nov 18 Sat 2006 20:10
can you rank more than 7 items? how?
I can't get Excel to rank more than 7 items (I have 8). Is there a limit to
how many it can do? When the result is a rank of 8, it puts quot;falsequot; in the
- Nov 18 Sat 2006 20:10
Dynamic Labels