Sometimes - especially when I copy/paste from Access - dates look like dates, I can format the cells as dates, but they're not *really* dates. For instance,...

I am a student studying RE law and have a lot of terms to learn. I would like to make an alphebetic list of terms from multiple textbooks into a spreadsheet...

I have two similar macros that usually takes 45 seconds to run however one of them takes 4 minutes to run with the only difference is the filtering from one...

Am trying to do a countif when the criteria can be one of many from a list I am currently using...

I have a number of people who will enter data: name, date, age, gender. In order to avoid having Joe inadvertantly change that which Bob has entered, I...

The goal of this is to be able to format only part of the text in a cell. I am trying to create a line of text which changes formatting depending on a number...

Hello, This is somewhat of a repost from...

Sometimes - especially when I copy/paste from Access - dates look like dates, I can format the cells as dates, but they're not *really* dates. For instance,...

this is close to my problem. Trying to check any of three cells for entry or value to allow a entry into another. Example If(and(a60,d60,f60),9.75,(""))...

I need to look at a single cell and it will contain a value from 1-1000, I want to return different letters based on the cell value. Using ranges for...

I just finished a spreadsheet last night that was opened from a flash/jump drive and saved back on it after editing. I took the drive to work and now it is...

I have a formula in ColB of my worksheet. The value of the formula will be zero or a positive number. Is it possible for a macro to change the formula to its...

Dear All, In my program, RANGE will be change eveytime.Like first time A1:B35 , Next time B2:D234, Third time C22:E46, ..etc. So that can you suggest how to...

I have a spreadsheet containing over 3000 lines of data. Looking through the row numbers some rows are "missing". However, pointing the cursor over the...

Hi, I am trying to link to different files in the same folder. I have wrote in a cell the name of the file that I want to link to and the used the formula...

Hi, I am trying to link to different files in the same folder. I have wrote in a cell the name of the file that I want to link to and the used the formula...

Hi, How can I convert a whole number representing seconds, e.g. 460, 1259, 82 etc into a number that displays minutes and seconds? For example, 460 divided...

Is there a way to create a "proability distribution" in Excel? I am in a statistics class and it would be really helpful. Thanks!

I need to be able to find the cheapest out of a range of data and then specify which is the cheapest as a name (text). I also need to be able to use an if...

I have an IF formula question. My cell has a formula in it =sum(H43/G43). I want this cell blank “� if the result is not a percentage (the cell has...