I am currently producing a data sheet which used values selected from 2 combo boxes to produce a given output. The problem is that I would like to have the...

A co-worker of mine has a question pertaining to Microsoft Excel 97. She is wondering if, if the same text appears in both an Excel spreadsheet and in a chart...

Hello All, I am creating a worksheet as follows: Col Headings A1 = Team (can be either Y or Z) B1 = Criteria (can be either A or...

Hi all, I am attempting to write (and I aim to be successful at it) a custom Excel function using VBA. The function will encapsulate the calculations and...

newbie question; Payroll in excell, is there a way to make a specific cell containing a date "blink" or flash? Any help would be appreciated. Ray

Could someone help me? What I need is to compare one cell with 35 other static cells. If the data in the main cell is the same as any of the other cells it...

I was poking around this forum to try and find an answer to this but was unable, and in the process, I found not many people seem to know about this so here is...

I work at a school and need some help in creating a formula and/or program for the following problem: Our school drops students from enrollment if they have...

I'm trying to set up a time sheet at work using excel. I have set up my sheet to calculate each day of the week individually. (M, T, W, Th, F, Sa, Su). I...

Hi, Can anyone explain why it is that a vlookup table automatically 'hides' itself within a worksheet that utilizes the vlookup function but the vlookup table...

Hi I would suggest you take a look at piot tables for this (group them by week)....

I'm stumped on how to use VLOOKUP when there are multiple matches, and I want them all, one after another. I'm modifying a previous effort, adding one...

I have data that I need to import into Excel, then export to .prn (because .prn is the only text format that seems to be able to save formatting) and when I do...

I have a spreadsheet with the date as column A and hours in column B. The date is in mm/dd/yyyy format. I am trying to sumarize the hours in column B for a...

How can I search and remove duplicate records from an excel work sheet?

I am trying to insert a refernce to a dymnamic cell into a text field. In other words, my text field says "number of days: AF5", where AF5 refers to the cell...

I am tracking dates of service and I need to be able to see if dates fall within a certain time frame. column F Column H row 1 (date 1) ...

I have created a Spreadsheet, that basically contains Radio Option Buttons, when the user clicks on the button, I have programmed a response to show up below...

Hi all, First, I need to be able to list the unique values in a column. Then I am going to have to retrieve info from surrounding columns for each...

I have a workbook with 5 sheets. sheet 1-4 have weekly data and sheet 5 total's up the data in sheets 1-4. The problem is that when a new weeks data comes...