Hi, I have data of blood test results for patients in an excel file, with each patient's data being placed on one worksheet. For instance: Data for PatientA...

Hi, (Excel 2007) I'm in the US, created 2 tabs, 1 with US dates (formatted as DATE) and the other tab with UK dates (also formatted as DATE). File sent to UK...

How do I select noncontiguous (nonadjacent) columns?

I have 3 work sheets that contain data re a rota patten. I have a list off 12 employees in 1 column and then 5 Columns with ranges from Mon,Tue,Wed,Thu,Fri. I...

I have a list of applications that have gone overdue. Here is a sample of my list: Program Code Case # Delay Code P60 401133012 P60 ...

I have a pivot table based on a list of data that has the following columns: Budget Category, Line Item, Budget, YTD Spent, Balance, and % Spent. Budget...

I am trying to set up a form for co-workers with limited computer skills. In cell "A" the employee would enter a name and I need to have a corresponding...

I have 2 worksheets, W1 has a unique id that I need to place on W2, if the names match. If name matches from W1, then place Unique ID on W2 Worksheet 1 -...

After some help please - at my wits end now! I am using Excel 2007 and am trying to count cells which meet a certain criteria. Originally had no problems...

I have a macro set up that pulls out the dates from my information. I am not sure but I think what I have below is the spot that defines the date format to...

How do I write a formula to count a cell if the font is strikethrough? I can really make the conditional format to be any type of font or cell change -...

I downloaded a Microsoft template called General Ledger (Green, multi-sheet/one per account code plus YTD Budget Summary and Monthly Expenses sheets). The...

I'm trying to set up a chart to compare costs of various projects. Each project will have a heading of the project name and size, and two sub-headings of...

HI All Gary's Student kindly made some to code to allow input of variables via popup : Dim colstring As String Dim findit As Double, replacewith As...

25/01/10 04:39 AM IST I want to write a function which will compare the timing given in format mentioned above with 04:10 pm or 16:10 hrs and highlight if...

Hi, right now I'm using the below formula to pull the tab name of the tab I'm working in. I need to also pull in the subsequent tab names into each...

I am creating an invoice in Excel. I would like to be able to creat a formula that will enter an amount in say column B IF there is ANY text in column A....

could you please help with identifying what is '^' used for?

I am trying to markup a column of numbers but do not wish to add a column (eg. Column A * .05 for Column B). Is this possible?

I have a VLookup formula to another worksheet, but I need the bold text of the referenced cells to show up as bold in the formula cell. I understand you...