Functions

Possible Conditional Formatting
Using Excel 2003 I have 9 columns A: Last Name B: First Name C: Initial Training D: 6 mo. Training E: 1 Year Training F: 2 Year Training G: 3 Year Training H: 4 Year Training I: 5 Year Training In the intial training column (C) I am going to record a month and year (Mar-10). I want the "6 mo. Training" ... 8 Mar 2010 17:35

If not an exact match to left of comma, then ALERT
I have two separate data columns. Col B has only last name, and Col D has last name, comma, first name. I'd like ALERTs in the F column if everything to the left of the comma in D2 Does Not Match exactly with B2, and dragged down. If it matches, then nothing. Something like this. B D ... 8 Mar 2010 16:26

Pictures won't go behind text in Excel.
I want to insert a pic of a map--send it behind text (or use as a background--but only behind certain cells, not the whole sheet) to make a grid system that a person can click on a part of the map and the cell they are clicking in contains a hyperlink. I can't get the pic to move behind text. ... 8 Mar 2010 14:10

Offset to ignore hidden cells not working in 2007
SUBTOTAL(3,OFFSET(L2:L100,ROW(L2:L100)-ROW(L2),0,1) This formula is from Domenic. It is part of the formula used to sum data while ignoring hidden rows. However, this part is not working for me in excel 2007. Highly likely, that I am the cause of the problem. Does anyone have any help for me? -- JoseB... 8 Mar 2010 19:50

Multi tab Workbooks
I have a workbook with several tabs that feed data from tab 1{Data Entry}. Tab 5 needs to be sent to the supplier and needs to be a spreadsheet that is in their specific format so that they can upload it without additional data entry . I need to be able to send "orders" to that vendor by sending them their sp... 8 Mar 2010 14:10

Can I have the right formula to list all my agencies under country
A B C A1 COUNTRY AGENCY RESULT FRANCE A2 FRANCE MAURITOURS W.S.TOURS A3 FRANCE MAURITOURS CONCORDE A4 FRANCE MAURITOURS ... 8 Mar 2010 14:10

How do I filter data by more than one column in excel
... 8 Mar 2010 11:57

ISNA Help Please Please please
Hi Can someone please add an ISNA bit to this please for use into excel 2007. I have been trying for ages and have been getting all tied up with it Many Thanks Matt =VLOOKUP(J5,A:B,2,FALSE) -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201003/1 ... 8 Mar 2010 16:26

Formula Help
I have 4 columns: Column A Column B Column C Column D First Name Last Name First Name Last Name I want to know if the First and Last Name in Column A & B can be found in Column C & D. Thanks. ... 8 Mar 2010 11:57

Excel 2007 -- Dates in Pivot Tables in wrong order after refresh
I am using excel 2007 to look at time series data via pivot tables. I am importing the base data from a csv flat file into a sheet in excel -- that all works fine. I have then created a pivot based on the imported data sheet which has dates as the only enty in the Column Label. When I build the pivot initial... 9 Mar 2010 00:15