## Mapping Excel data

Hi, I’d like to create a mapping sheet to generate a report based on internal data and the data from the client. The problem is, the products don’t …

Hi, I’d like to create a mapping sheet to generate a report based on internal data and the data from the client. The problem is, the products don’t …

Hello, Don’t really know how to name this problem properly. Just made it more in a general sense rather than a specific one. Here’s the problem, …

Excel2010/Win7/Arrays/ Cell A1’s content is my array e.g. {“N”,0;”Y”,1} not recognized. Request/Goal: I want to enter the …

Hello all. In the spreadsheet below I am using the values from the table and an inputted value (yellow box) inside the formula =VLOOKUP(B16,F15:G29,2,TRUE) to …

I have a price list which i need to get back to cost price, then add a margin then add vat how do i, take off 20% add 40% and add vat to all the figures in the …

=(F2*0.4)+(G2*0.4)+(H2*0.2) This formula works well for my needs; however, I want the final answer to be a rounded number with no decimal places. I need help …

I have a Age calculating formula in an excell cell, which calculates the age as on another date. The forumala is …

Hi, I have build a absence tracking wookbook but now would like to add a funtion that adds a row into my work sheet when i search and select an employees name …

Hii I have three coilumns H I J Net VAT TOTAL I need to work out how once we enter each nett it will work out the vat and total. (iideally it can …

I am trying to make a lottery checker in excel,but dont know which formula to use to make it work. My draw numbers are in cells a1 to f1 i can make the …

Hi I am trying to work out what the VAT would be in excel formatt. I have the following at the moment but i cannot seem to change it to 20% J17-SUM(J17/1.175) …