I have a name field that contains first middle lastname. I want to extract the lastname and put it in another column. I think what I need is a function to...

My cell contains several strings, a carriage return, and the more strings. Iam trying to italicize the strings that follow the carriage return. This is the...

I dont actually know what function i should use to my problem... I want to make a list of different text-cells, if they contain a number. example A ...

Hi. I made a list with four different types to filter on, lets say, A, B, C and D. In one row, cell, (lets call it A&B row) i want to have A and B, so when...

I have a workbook that has many simple functions moving data around to different cells and processing some if statements on some of the data. The problem...

I AM TRYING TO USE COUNTIF IN MORE THAN ONE SHEET. I CAN GET IT TO WORK IN ONE WORKSHEET. WHAT I NEED IS TO SEE HOW MANY TIMES A CERTAIN CRITERIA HITS IN ONE...

I'm trying to create a date range in Excel in a column on a worksheet I use a userform to enter a start and end date, using control source for the userform...

OK, I can get overtime and doubletime figured out for Mon-Fri it's Rows: Monday 11's Tuesday 12's Wednesday 13's Thursday 14's Friday 15's Saturday ...

Fairly large Excel Workbook has 60 Sheets, 10Meg size, 1500 Rangenames. Macro (VBA) adds a sheet backgound when entering a sheet, if sheetname.gif exists in...

I have a long list in columns A to I. In some cases, all the items in adjacent rows are identical, and I need to be able to find these as quickly as...

I would like to read a cell value then create a Windows folder using the value in the cell as the folder name

I need to find the max value out of one colume and display the value of the colume to the left of the max value. -- Brian

I've got a multiple sheet budget model that I need some help with. I have all of my employee salary data on a master tab with gl account codes that are...

Im trying to reference a cell's content including it's format in a different cell. I cannot seem to figure out how to reference a cell format or its color....

Hey all, I am looking for a function or group of functions that will: Match Column C and for every unique item in column A, it will sum column...

7/21/2007 Thank you in advance for your assistance. I have a two computer network. Files from Computer #1 are backed up to Computer #2. On both computers...

I was sent a spreadsheet with descriptions of product we sell. In each cell, displayed is a fraction, however if you click on the cell you see the decimal...

Does anyone know how to send the results of a calculated cell to another cell as a raw number. Example: Cell A1=100, cell A2 contains this formula: ...

I have a column in my Excel spreadsheet that contains times. All the times are for one day and always will be for one day only. I'm trying to subtotal a...

Hi I am using a 15-day moving average function in one workbook. It updates the average figure when I enter todays reading. Now I have opened a new workbook and...