I have on my main worksheet information that I am trying to use in formulas to reference data on other worksheets. My worksheets are named for the different...

Hi, I'm using subtotals. I want the value that is the result of the subtotal to be bold. Can you help me with the syntax I use in the conditional...

Hi all, struggling a little... I'm new to the VLookup function and need some help.. I know this might be fairly simple - so if someone could help or recommend...

Hi all, I am trying to do the following on the same worksheet: Calculate a total in one column based on an 'if' function from another column and return it in...

I have a column of dates that I need to sort through. At the moment I am using =COUNTIF(E8:E1000,"15/04/2005") to check dates that were before todays date....

=SUMIF(B1:B199,"business account",D1:D199) The formula above returns the correct total - this is displayed in another worksheet - the sheet the formula...

I'm using a sumproduct formula because I have 2 (or sometimes more) criteria to meet. This has worked in the past for me, but this time one of the criteria is...

How anc I consolidate data from several workbooks which have same data format?

I am trying to generate "Drop down list" using formula. The path I am using is : Data Validation ---List ----Formula It seems there is limitation on no....

I'm building tiresome SQL statements by concatenating text and cell contents. I need to be able to insert double quotation marks into the actual text strings...

How do i do a Countif than var1 and var2? eg. Countif var1 =COUNTIF($T:$T,"" & $C2) I have tried Countif var1 AND var2...

Hi, I am typing some details on CUSTOMISE HEADER but it says that total character exceeds 255.Is there a way to increase the space to accomodate more then 255...

In excel how do I remove a formula and leave just the resultant value in that cell? I'm fairly sure that there is a way to "remove" the formula and keep...

can I create a validation formula that will allow either a preset value or a user defined value depending upon the value of another cell

How do I set a formula in Excel so it will not allow me to enter duplicate values on a worksheet? I have used the Data Validation tool before to set the...

Hello, I have data on the company's server that can be exported in comma deliminated format and when I import and open, the header row is complete. My question...

Put this into a cell and change the format of the cell to number with 16 decimal places... =1131.97-1123 The answer is 8.9700000000000300 Notice the 3 at...

I have a long spreadsheet with birth dates (ie. 01/01/2001) on column A. Is there a formula that can calculate into number of years to the present date. For...