Posted on 18 October 2008
You think you've entered the right formula and yet you get the dreaded #N/A error on the sheet.....well....here are some useful tips to get you through the vlookup blues!
=vlookup(value_to_match, range_to_find_this_value, which_column_to_return , try_to_approximate_if_no_match)
(Delimited) text being compared to numbers
If you have imported data from a plain text file (a .txt file), your data may most likely have numbers which have been converted to string. Excel will still display the values ...
Continue Reading
Posted on 23 August 2008
60 useful excel formulas that are a good to know
DATE = Returns the serial number of a particular date
DATEVALUE = Converts a date in the form of text to a serial number
DAY = Converts a serial number to a day of the month
EOMONTH = Returns the serial number of the last day of the month before or after a specified number of months
MONTH = Converts a serial number to a month
NOW = ...
Continue Reading
Posted on 23 August 2008
20 Excel formulas you should know
DATEVALUE = Converts a date in the form of text to a serial number
DAY = Converts a serial number to a day of the month
MONTH = Converts a serial number to a month
YEAR = Converts a serial number to a year
LEFT = Returns the leftmost characters from a text value
LEN = Returns the number of characters in a text string
RIGHT = Returns the rightmost characters from ...
Continue Reading