Functions

convert vcf to xls
I'm trying to convert a database from vcf to an excel spreadsheet ... 22 Mar 2010 18:06

Conditional Formatting Help when a Cell is Blank
I am trying to format a cell that has three scenario's. 1. If A1=B1, then the text will be green 2. If A1 does not equal B1, then the text will be red 3. If B1 is empty/blank, then A1 has no formatting. The value of B1 is dependant on a value that is selected from the Master Sheet. So B1 has a formula that... 22 Mar 2010 14:16

how to get rid of default dates in Excel?
I want my dates to stay as I have typed them - not for them to be changed for the Excel default system. ... 22 Mar 2010 11:54

the criteria pane and table panes have disappered.
In my excel file I can't see the criteria and table panes and the functions will not reappear. ... 22 Mar 2010 10:32

formula for displaying only the last entry of a group of cells
How do you write the formula that will display only the latest entry in a succession of entries? For example, if I have 12 months in 12 columns, and the 13th column specifies "Last Update" , if I have made entries for Jan, Feb, Mar so far, I need only the latest and last entry to appear in the 13th column. When... 22 Mar 2010 10:32

IF, INDEX and MATCH
I was using the formula below to match 2 indicators listed within an array. I have another 2 indicators that I CANNOT add to the array. They lie in cells AA2 and AB2. How can I modify the formula below to Index all 4 indicators. =INDEX($A$1:$E$42, MATCH(Y2,$A$1:$A$42,0),MATCH(Z2,$A$1:$E$1,0)) Thanks for the he... 22 Mar 2010 10:32

How do I stop text from disappearing when I wrap text in Excel?
When I type in a cell then wrap text, my text no longer displays in the cell. I can see it in the formula bar and in print preview but not in the actual cell on the screen. My row and column height is completely adjusted. If I unwrap the text, I can see it in the cell. ... 22 Mar 2010 09:24

Question about syntax for conditional formatting
See below: Can someone explain the following in simple language; =AND($B$12<>"",$B$12<TODAY()+120) What does the <> after the cell location mean? and why the double quotes ""? I thought the double quotes meant whatever is in the cell is NULL....I have a date in the $B$12 position. ... 23 Mar 2010 06:45

Using match but data needs to be split.
I have a table - Y axis contains whole numbers (1 - 20) and X axis contains decimals (0.1 - 0.9). For each there is a corresponding reference that I want to be able to look up. For example, if I type 10.5, I want to be able to look up the value held at 10 on the X axis and 0.5 on the Y axis. I've tried usi... 22 Mar 2010 07:11

Why i can not protect sheet
Dear Peo and everyone, i have download sample from http://www.mcgimpsey.com/excel/lookuppics.html it's look very good for me, but i got some problum when i protect this worksheet, the picture do not come out. can u show me what is the problem when we protect sheet and how to do if i want to protect it? if any... 22 Mar 2010 11:54