hey
i need to put a formula in the same cell that i have text in.
is this posible
I can't split the cells, it will mess up the table layout
thanks
dave
http://www.experts-exchange.com/Other/Miscellaneous/Q_21798924.html
Zones:
MiscDate Answered: 05/13/2006 Grade: A Views: 0
I'm coming up blank trying to solve this and know there must be a way. If I have an Excel data set such as the following and want to lookup a value that has to have two criteria match, can it be d...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I am trying to run a search in Excel on about 8 different sheets.
The sheet has which sales staff sold what down the A column, and then down the H column the relevant income is displayed. I need ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 08/17/2007 Grade: A Views: 0
I downloaded an Excel file from Crystal Enterprise that my company uses. This one report pulls that date fields in two columns as text. So I get this:
Jan 31 2002
Jun 28 2002
Jun 28 2002
Ju...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 08/20/2007 Grade: A Views: 0
Hi All,
Is there any function in jExcelAPI that can strikethtrough the content of the cell?
Thanks.
http://www.experts-exchange.com/Programming/Languages/Q_22805972.html
Zones:
Languages,
JavaDate Answered: 10/18/2007 Grade: A Views: 0
Can somebody tell me what this is doing, especially the ! after table? vlookup(E11,Table!A$1:B$65533,2)
I know this is easy for someone who know excel but I am in a hurry so I am giving away way t...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 09/24/2007 Grade: A Views: 0
I need a macro that will find columns based on the headers and delete them. Alternatively i could find columns based on their header, copy them to a new sheet, and delete the original sheet. That m...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/18/2007 Grade: A Views: 0
I have a range of numbers along a row (from left to right), from B through to H. I know I can arrange the numbers lesser to greater down a column, but can I select those values along a row and chan...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/01/2007 Grade: A Views: 0
hi,
I have a quick, hopefully easy question.
I would like to know how to reference multiple columns (that are not beside each other).
I am trying to hide some columns that the user doesn't nee...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hi all,
I've set up a userform to send data to a sheet in Excel. Some of this data is taking from another worksheet and some of it is simple formulas (eg =TODAY()). The problem is that I want ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/09/2007 Grade: A Views: 0