excel 2010 formula

Hi, How to calculate in Slab. below is example. <tbody> <tbody> Total Days Deducted </tbody> <tbody> 48 </tbody> <tbody> Already Deducted Days </tbody> <tbody> 32 </tbody> <tbody> Need to be Deduct </tbody> <tbody> 16 </tbody> </tbody> <tbody> </tbody>...

Hi Guys, I am trying to run a report for dates for product supply and so far I have managed to use VLOOKUP to bring me back the dates for all of the products I am reporting but I now want to improve the report by providing a value other than dates such as " made to order" for products that have...

What I am trying to do is use vba to loop through all the worksheets in my workbook and multiply a range of values by 100 in three columns: AA,AB and AC. After doing research I found a function that works for the first two columns AA and AB the numbers in columns AA and AB are correct the value...

Dear Excel Experts I may be asking a question for something that cannot be done. Nevertheless, I thought there is no harm asking. Is there a way to retrieve the name of the listobject/table which is located in, for example, cell A5 without the use of VBA? Thanks Maria

I am stuck on the final formula for a vacation workbook. I am trying to return the value in column C by referencing the date in column B and placing it next to the correct date on the Sheet listed in column A. The sheet "Dummy, Taylor". The 8 entered on 02/10/2015 from above would be on row...

I am importing Data from somewhere and when it imports in it comes in like this. <colgroup><col></colgroup><tbody> 285 + 2 Is there any way I can change this to 287? There are tons of Cells like these so anything manual will not work. </tbody>

Hello, I need to write an formula to put a number in column H that will look at the name in column B then look at the same name on a different work sheet in the same book called "SHEET2". Once I have the matching name found on "SHEET2" I need to get the data from column E on "SHEET2" and put it...

Greetings from the Land of Lincoln! I have a 47x16 table (column and row headings included) in which every cell has data, but data is not visible in all cells. This is because of a VLOOKUP statement I am using: Columns!P2 <tbody>...

I am trying to create a simple statement =OR(R2:R1300="179 2015",R2="RF Priority") -- =IF(R9="179 2015","YES","NO"). Each of these work perfectly fine if I am just typing in the text 179 2015 or RF Priority, these return the expected results of True or YES. However, the issue is that wheneve I...