I want to auto fill a colum as shown 1 1 2 2 3 3 4 4 ect ect but everytime i do it i end up getting decimals. or sometimes ill get 3 of a number instead, is...

I am working with a series of complex equations. I need them to carry a constant 4 significant figures throughout the entire spread sheet until it is rounded...

Look @ Hack #25 "Create Validation Lists That Change Based on a Selection from Another List" in the book "Excel Hacks, 2nd Ed." by D. & R. Hawley

=IF(OR(TABLE!U6="",ISERROR(TABLE!U6)),"",TABLE!U6) this is placed in a different sheet. I want this Eqn to check if the value in Cell U6 of sheet "TABLE" is...

I am using a formula that may produce positive or negative results. Once it has produced the sum the sign is immaterial. I need the result to add as a...

hi, is there a way to show a network drive via formula when a drive is being mapped? Different users mapping of the same drive to a various letters is...

Hi. I have weekly data by Contract number over multiple worksheets. I want to sum the hours associated with the contract. The contract information will not...

I HAVE A WOOKBOOK WITH 54 WORKSHEETS, THEY ARE ALL IDENTICAL, BUT REPRESENT DIFFERENT PEOPLE. I AM CREATING A SUMMARY SHEET THAT WILL DISPLAY DATA GATHERED...

Hi, I want to count the number of times the number 3 or -3 comes up in A8:A15 depending on whether 3 or -3 comes up first. If 3 is A8 then count how many...

I have a sumproduct formula with different conditions. One of them is picking up only the first 17 caracters of a cell. So...

Is there a way to copy a page to a roll-up worksheet that, when you link it, any blank cell will stay blank instead of showing 0? I have tried the IF...

Hi, I need to convert cells that was typed in caps lock only, to lower case. How do I do this without having to retype the whole cell??

Good day. I have multiple worksheets in my workbook. I want to sum the worksheets by the column called Contract, by quarter. I have made a quarterly...

I have one template that i print for our production floor. Each sheet has seven dates printed; Monday thru Sunday. I need to print this one template 52...

I was working on a spread sheet in excell and hit F11 key by mistake. Now I can't get bat to the data I had and was working on. What do I do?

What I am looking for is that when I enter a formula (In cell B1) to pick up value in A1. Now I need value from cell A5 in cell B2. Next value I need in B3...

WHAT IS EXCEL SYNATX FOR: IF A2=C1 THEN T2 = S2?

Two individuals are completing the same data entry on two separate spreadsheets. The data entry consists of values in two fields. The following formula on...

Hi I am using Excel 2003 and I am training some people in my company on functions - I am stuck though and need help on the following functions - examples of...