Hello from Steved Can I please find duplicates with the first three digit that are the same. And can the bottom formula be Altered please to do...

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...

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...

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'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 I would suggest you take a look at piot tables for this (group them by week)....

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...

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 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...

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...

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 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 series of tabs within a workbook labelled "April 2008", "May 2008", "June 2008", and so on. In cell A1 of each tab, I have entered the start date of...

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

I have seen the VB code that will count cells with a specific color. I have seen the VB code that will set the font color of all characters in a cell. What is...

I just did a search through the newsgroup but didn't find anything specific to this. I'm trying to look for duplicates so that it would recognize ROWS A and C...

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...