I'm trying to see if there is a way to take another user's input of "12oz", say in cell A1, and convert it to the numeric value of just '12' in another cell,...

I have information on sheets 1, 2, 3,4 etc. Can I collate the totals from each sheet on a master speread sheet 1?c

I was page break view. Trying to reset pages in the worksheet i tried to move the boundary of the page by dragging it with the help of mouse. I could not...

I am trying to figure out how to set a default font size for the comments I add inot my excel worksheets. I have figured out how to change it in the...

I'm trying to create new worksheets using a Macro. One of my current worksheets is the layout and formula/data master (we can call it MasterLayout) and...

I have a formula that calculates an average of either 10 or 11 rows of data. I would like to be able to make the formula dynamic so that I can average either...

I am new to Macros. I have to compile several monthly reports that combine information from other reports into one or more spreadsheets. There are 7...

Hi everyone I want to populate a cell with the value of another cell..based on the following criteria: If the first of the month is a Mon-FRI then the cell...

Is it possible to auto hide/unhide rows based on a vlaue that may/may not be present? For example, instead of writing many different macros, I would like a...

what is the difference between this two functions?

I am trying to get the percentage of a group of cells using excel 2000

I am trying to get SUMIFS function to SUM a range of cells only if three criteria are met. I have tried the SUMIFS function for two of the criteria and then...

I have a work sheet that contains multiple columns, three that contain date information. The first column(G) is named Date Assigned; the second column(H) is...

i have data in a1:a31 and in a45 i am putting =a1. i then click the black box at the bottom of a45 and drag until each successive cell contains the...

Hi All! I have read through the postings and have tried on my own...the results have not been all that I would hope for.... Sheet A Column A - a list of...

I am trying to use the PROPER formula to correct the case of names in a data base. The formula will not calculate. I have set the Calculation button in tools...

How do I get around the 7 argument limitation within a formula?

I have a column of date and time stamps I want to add excatly 1 year to. The cell I want to add a year to is has this: 6/1/2007 6:35 If I use the forumula...

¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656 ----------------------------------- Àû¬”ëŠ×Ó(мÓÆÂ)ÓÐÏÞ¹«Ë¾...

¹¦ÂÊÄ£¿éÏÖ»õÏúÊÛ137-1410-2508 0755-8836 4656 ----------------------------------- Àû¬”ëŠ×Ó(мÓÆÂ)ÓÐÏÞ¹«Ë¾...