Hello, I am still new to excel and I am working on a project. I have been looking all over the net to try and find out what the $ in a function means. For...

I have IF formulas referencing information that is populated monthly. I've copied the formula's down for the next several years, but won't need those...

Changing the format to number didn't make any difference.

I have a sample file that contains just 1...

Hello, I have a problem with selecting cells. The selection allways goes from column A to M. The number of rows starts allways from A 11, to the LAST CELL in...

one of the segments to this worksheet includes 12 boxes where users would enter one of 4 letters. E,S,O or R. E being the most valuable then S then O then R....

I previously posted a question about how to get error bars on a bar graph. Jon Peltier was very helpful. I have another question now. Is there anyway to...

I want to have a new spreadsheet that pulls the position number, percentage allocated, and the accounts. I know how to easily pull this information in when...

Nevermind. Found the answer right after I asked...

I left an Excel document open and unactive last night. I made some changes this morning and when I went to save the file it told me that the file was locked...

I want to add the sum of cell D20 in all worksheets from the first up to the current. I have...

Here's our problem... we have some things listed in LBS and others in BGS for their unit of measure... so when reviewing inventory - we're constantly having...

Hello all- I have two sheets, sheet1 and sheet2. I am condensing sheet1 (filled with approx 5000 rows to sort through) Sheet1: branch acct# name ...

I'm making a spreadsheet that shows the circumcenter of a triangle with the 3 points as input from the user. I can get the circumcenter calculated no problem,...

I need to create a list in Word of the names on (20) Excel worksheet tabs. I can find the list, but I cannot copy and paste.

Hi I have a workbook with two sheets. Each sheet contain a pivot table. The first sheet lists the bottom 25 files based on revenue and some of the detail. ...

How do you enter the text or "options" into the combo box list? I was trying to use the Control Toolbox for this but after reading some other posts wasn't...

Hi All....I posted the following query few days back and got a couple of answers. But the problem is none of'em seem to work. All the formulas that you guys...

By using the "&" formula to string comments with formula, how to insert a comma (i.e. thousands separator) for a value? E.g. if I use the following...

Hi appreciate help on getting Countif to work on this situation: =80% =80% =100% 60% Formula is COUNTIF(A5:A8,G11), where A5:A8 is the table above, and...