I want to be able to check those identified as Male in Column A who voted YES in Column G. COUNTIF appears to work to check count of males or who voted YES...

Please help to find out how to copy every 30th cell in the column into consecutive cells in another one. Thanks

I have a rather large spreadsheet listing salesmen, customers, locations etc. I would like to create separate worksheets for each salesman listing only data...

I have made a sheet which contains a column which is used to insert installation dates, however these dates change from time to time due to failed...

How can I determine the starting position of the last occurrence of specific text within a longer string of text? For example, the text "abc" occurs last in...

Hi, I've got two rows of data (numbers) I am entering which look like this: 6319890 - 6319896 6319913 - 6319919 etc Is there another way to 'fill in' the...

Hi to All, I want to do a double vlookup, where I want to bring back cost_of_sales to sheet 1, if the location and item# from sheet 2 matches with the...

I am using Excel 2003 How do you round the contents of a cell to the closest five cents. Thanks lk

would like to ba able to calculate the last 3 entries of any given row. how ever the data(score) may not be in the last three colums. EG. Four columns A:D...

I WOULD LIKE TO RUN A MACRO THAT WOULD OPEN UP A QUERY WHICH THE USER WOULD NEED TO TYPE IN THE FILE NAME AND THEN THE QUERY WOULD CONTINUE TO PROCESS. SOME...

I am trying to write a formula where I do a lookup of anything ("same cell ie D10) in every sheet. I want to have the NAME of the 50 sheets in column B, from...

I regularly print out my management accounts and each new month has a new reference which has to be included as a footer. Is there a method whereby I can...

Hi I want to export data from excel to another database. Can I? If it’s possible how do I do it? Thanks!

Normally, when I click in a cell, the "name box" will reflect the name of that cell (i.e. A1) However, I have a cell that I click on that gives me the nem...

I am having problems opening two work books at the same time, i have to minimise one to look at the other one. I have been able to do this in the past but can...

I want to write a formula that will allow me to multiply a currency number by 9 and then round the number up so that it ends in 9. For example, $56.50 x 9 =...

Am trying to create a fomulae that will look up data dependant on rows and columns. E.g In the lookup range cells A1:A10 contains diffrent item codes and...

Is there anyway to "Animate" or make Excel look like and act like a Powerpoint Slide for the purposes of presenting to an audience. I tried pasting each...

I am trying to link a subtotal on one worksheet to the total on another worksheet in the same workbook so that as i enter information in one worksheet the...

Hi there, I'm not that familiar with macros and the information I'm finding is leading me to believe this is what I need to be using. I currently have 8...