Is this at all possible. I have been consulted that it can be done by unlocking cells, through the use of macros, etc. and I have yet to find a way that truly...

How do I calculate the weekdays between 2 dates in an Excel spreadsheet

I have a spreadsheet that will eventually consist of over 30 sheets. Each sheet will have information that I want to be entered into a formula on a totals...

I have a range of data listed like this: Date1 Date2 Date3 Date 4 Data1 Data2 Data3 I'd like to sum the data in the rows if Date1 or Date2...

I'm trying to add another criteria that will look at the cell in column Z to see if the record has been tagged for use in report(s). Column Z can contain one...

Hi, I need to find a way of returning the cell values that are directly above and below a specific cell. For example, suppose I have the following list in...

Dear Sir, I like your Website, I have a big problum with my excel i hope that you will solved this problum. My every excell file are demmaged when i open my...

Is there a way to prevent changing, or re-entering data in an Excel cell after initial entry?

I need to compare text from one worksheet to another with a notification if there is a match

when i want multiple some celss like a1*b1*c1*d1 maybe some of this cells are blank and excel equal that to zero how can i ignor the zero value (balnk cells )...

I want to convert 2hr 42mn(in one cell) to 162mn. Is there a formula to do this? Also, is there anyway to enter the 2 hrs and 42 mins in one cell where...

I am trying to get my Workdays and Networkdays formulas to work right. I am measuring time in number of days, and calculating due dates and number of workdays...

I get error messages on many (if not most) of my spredsheet cells. Almost all of them are unimportant or just plain nonsense. I can fix cell by cell, but...

heloo if i have 5 columns like these suppose that this is a sell and buy stocks forum the first column is company number the second column is company...

I have a dget function that I want to use different range and criteria ranges depending on a flag. I thought that index would work but I am getting a value...

I regularly run reports which produce a column of staff by reference to their code number which I have to manually change to their initials. Is there a way of...

I have a column of data on an Excel spreadsheet that should be unique codes. I want to highlight any cells that contain duplicated data. Any idea how to do...

I'd like to add text in my footer that has an ampersand, but when I do, it adds a page number instead. I'd like the footer to read: A&B Is there a formula...

Hi Everyone, I have thousands of cells with names and addresses, and each cell combines both. I'd like to separate "Jane Doe 123 Street Road" into "Jane Doe"...

I have a spreadsheet (timesheet) that has a column (F) defaulted to 8. I need this row to subtract the numbers entered into rows G, M-U only. For instance -...