In very large spreadsheets I often want to scroll down to a specific row multiple times. Does Excel have anything similar to a tab or marker that you could...

Is there a way to diasplay in a cell the "Last updated date" the workbook was saved without using a marco? thanks in advance,

Hi, Would like to get some advice on function OR I have two column both returning information TRUE or FALSE, It looks like this TRUE FALSE TRUE TRUE

Hi Tim, Furniture pick up at Sears please Tkx Dad

Hi all Heres my question and i wonder if someone can help I need to change this number for example 52253580000 into this number for example...

Hi, Pardon me if I have already posted this question, because I cant locate my question anywhere. I guess, it is not saved. I know I need to use NETWORKDAYS,...

Is it possible to search for a keyword in column A in sheet 1 and return the whole row containing that keyword into sheet 2?

The following calculation is in column D9, this is stating to look at the Customer account # entered into Column D3 by the user and perform the calculations...

I am using Excel 2007. In the example below I need to return a count of "2" for each of the unique data elements in column "B" based on the values in column...

=IFERROR(VLOOKUP(U2,agt_ary!$A$1:$E$500,5)," ") col 5 is a live email address, witht his function I only get text, Is there a way to have the hyperlink on my...

Hello group. I have attempted to consolidate fields with no luck. The first field column I have changed to Store, so I can insert it into my address book. The...

I've got a tricky one, well for me anyway. I need to classify a list of products into Hardware and Software. The trouble is the items can be called Licensed...

Good morning everyone, I would really appreciate if somebody could give me a hand with this: I'm trying to extract the state for each one of my cells on the...

How do I get the date to remain static when a sheet is saved and not change to the current date when it is re opened. It is a daily log and each shift it...

Does anyone know how to take 7 rows/20 columns and place into a single column as the example I have here???? This information is uploaded into our database...

I NEED TO PUT PAGE NUMBERS INTO A CELL IN THE WORKSHEET. NOT A HEADER OR FOOTER. PLEASE HELP[

How do I write a formula that will return a '1' if an adjoining cells contains a value between 1 - 7? Help please - many thanks.

Hi, I have two columns A and B as shown below. When I choose North in Col A, I should get only values correspondig to North in Col B . ( 1,4,2 and 6). Can...

I want to that once a number is entered in a cell it would be converted to a form that has a comma inserted after every two digits from right to left. ...